Excel In-Built Functionality

Adding Line Breaks in a CSV File

by

A CSV file is a Comma Separated Values file. And it can be opened very easily in Microsoft Excel.

Most people use data files coming from main frame computers, or other external applications, and export the data in the CSV format, as it is easy to create, access and use. The other alternative is to create a Excel file (ending with .xls or .xlsx extension), but it is quite difficult to achieve in most legacy applications.

Thus, the CSV format has come to stick, and is one of the most popular methods to transfer data from one application to another.

Microsoft Excel has the capability to read and create CSV files easily.

In Excel, you can write text in a any worksheet cell, and it can span into many lines. Sometimes, if you have a long comment, you can split it into different row lines also.

a long comment in excel, keyed in multiple lines, but in the same single cell

 

 

Want to Improve Your Excel Skills?

Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.

To Get Most out of Excel, Learn the  Pivot Table techniques in our
Pivot Table Masterclass Training!


How do you create a CSV file, which contains a long line, split into multiple rows?

Simply use  Quotation marks to enclose the data which spills into multiple lines. see below:

Department, Status
Manufacturing,“No new issues.
Previous issues need to
be addressed”
Sales, “No issues”.

Once you load such a file into Excel, it will automatically show the complete data, in a single cell.

That’s it… it is such a simple and neat trick.. and helped me numerous times..

Additional Resources:

Enjoy,

Vinai Prakash

Are you facing any problem in using Excel? Any Question?

You have come to the right place. Tell us your needs. We’ll be glad to help you!

How to Analyze Data using Excel Pivot Tables

by

Do you know how easy it is to use the Pivot Tables in Excel, for Data Analysis?

To demonstrate this, I went to the Internet, and  found some travel data. It belongs to an unnamed Travel Company. The travel company collects the amount of ticket sales, the age of the passenger, and their gender only.

Based on this, how do we analyze the data, and find some hidden gems of information that can make the data come alive, and aid us in doing some real life Marketing.

Watch this step by step video on analyzing this data, using the Pivot Table technique in Microsoft Excel. I am using Excel 2010 version for this demonstration.

As you can see, many hidden insights can be found by using the Pivot Tables in Excel. So get started… Use them in your day to day work, and become a Data Analyst, rather than a Data Gatherer or Data Reporter…

Want to Improve Your Excel Skills?

Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.

To Get Most out of Excel, Learn the  Pivot Table techniques in our
Pivot Table Masterclass Training!


Have you subscribed to the ExcelChamp.Net Email Newsletter, where we send you such tips by email?

Additional Resources

Cheers,
Vinai Prakash, PMP, ITIL, MBA, GAP
Founder: ExcelChamp.Net – Providing Everyday Tips for Improving Productivity, Using Excel!

Are you facing any problem in using Excel? Any Question?

You have come to the right place. Tell us your needs. We’ll be glad to help you!

<div class=”ml-form-embed”
data-account=”3112195:l6l5i4i1x0″
data-form=”5497493:o9q9a8″>
</div>

Additional Resources for Learning Excel & Become A Pro

  1. Top 12 Most Important Excel Functions You Absolutely Must Know
  2. Excel Beginners Guide
  3. Excel Essentials: From Beginner To Pro in Just 6 Weeks

Removing Grid lines from a Section in Microsoft Excel

by

You can switch off Gridlines completely, or you can have them on. But many people are amazed to learn that you can turn them off or on from a certain section of their Excel spreadsheet. And this trick works in Microsoft Excel 2003, Excel 2007 as well as Excel 2010.

How do you achieve this… Very simple trick that doesn’t take a minute to do… Watch this step-by-step video on how to remove gridlines from a section of the Excel Sheet.

Let me know if this works for you…

Want to Improve Your Excel Skills?

Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.

To Get Most out of Excel, Learn the  Pivot Table techniques in our
Pivot Table Masterclass Training!


Do you have any other problem in using Microsoft Excel? Simply write to me using the comments box below, and I will assist you.

And check out my other Microsoft Excel Tips & Tricks videos on YouTube.

Additional Resources:

Cheers,
Vinai

Are you facing any problem in using Excel? Any Question?

You have come to the right place. Tell us your needs. We’ll be glad to help you!

Excel Tutorial – Combine Multiple Text Columns Into a Single Column

by

Some of the attendees at my Excel Boot Camp trainings have been thrilled to find that there’s this nifty function, which can combine many text columns into a single column.

Let’s say you have a column with First Name, and a separate column for Last Name, and you want to combine them to form the full name. How would you do it?

Want to Improve Your Excel Skills?

Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.

To Get Most out of Excel, Learn the  Pivot Table techniques in our
Pivot Table Masterclass Training!


I have recorded a short video on how to achieve this, using 2 different methods. Check it out below:

Let me know if this works for you. And if you have any other method to achieve this, I’ll be glad to know it…

And check out my other Microsoft Excel Tips & Tricks videos on YouTube.

Cheers,
Vinai

Are you facing any problem in using Excel? Any Question?

You have come to the right place. Tell us your needs. We’ll be glad to help you!

Simple Functions in Excel – Video

by

Most beginners to Microsoft Excel are not aware how easy it is to use some simple functions.

I have recorded a detailed, step by step video, which shows how to use the Sum, Count, Average, Minimum and Maximum functions in Excel, to add, count numbers.


Want to Improve Your Excel Skills?

Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.

To Get Most out of Excel, Learn the  Pivot Table techniques in our
Pivot Table Masterclass Training!


Do let me know if this helps you in using Microsoft Excel. The techniques applied here are same for Excel 2003, Excel 2007, Excel 2010 or Excel 2013, Excel 2016 & Office 365, so it does not matter which version you are using.

And check out my other Microsoft Excel Tips & Tricks videos on YouTube.

Additional Resources for Learning Excel & Become A Pro

  1. ExcelChamp Video Tutorials on YouTube
  2. 2 Axis Charts in Excel
  3. Using Date and Time Functions in Excel
  4. Finding Difference in 2 Dates – Without the Weekends
  5. Top 12 Most Important Excel Functions You Absolutely Must Know
  6. Excel Beginners Guide
  7. Excel Essentials: From Beginner To Pro in Just 6 Weeks

Cheers,
Vinai Prakash

Are you facing any problem in using Excel? Any Question?

You have come to the right place. Tell us your needs. We’ll be glad to help you!