Create Charts
First you need to enter data into a spreadsheet (or Excel) with column headers. Next, select Insert > Chart > Chart Type. If you are not confident of the type of Chart you should insert, Excel 2013 even has an option for Recommended Charts wherein it shows different types of layout/chart types based on the type of data you’re working with. Once you prepare a generic version of that chart, it could be even customized using the Chart Tools menu. It gives “n” number of options for you to change the Design & Format of the chart, as desired.
Use “IF” formula
Let’s you use conditional formulas that calculate in one way when a certain thing is true, and in other way when false.
For example, in the data shown in the spreadsheet below, you can write “Pass” or “Fail” against each Roll No., depending on the marks obtained by a student. If the marks scored by a student is greater than 60, it will write Pass else Fail against that Roll No.
Use Flash Fill
Before this features was introduced, when you worked with a column having names in “Last, First” format, you had to type everything manually. But now it has made pulling required pieces of information from a concatenated cell easier than ever before. Once you show excel what you want to extract in the next column, it can on its own, using Home > Fill > Flash Fill, automatically do exactly the same. In the example given below, in Column D as I wrote first name, using this feature, it automatically filled the first name of the remaining persons in the table.
Use Quick Analysis
While working with simple data sets, if you use Quick Analysis tool – it minimizes the time you might take to create charts. It shows at the bottom right hand corner as soon as you have your data selected. When clicked, the Quick Analysis menu provides tools like Formatting, Charts, Totals, Tables, and Sparklines. You can see a live preview of each by simply hovering your mouse over each one.
Use Keyboard Shortcuts
F2 – it opens the cell for editing in the formula bar
Control-End – Moves to the last cell that contains data
Control-Down/Up Arrow – Moves to the top or bottom cell of the column
Control-Shift-Down/Up Arrow – Select all the cells above or below the particular cell
Control-Left/Right Arrow – Moves farthest left/right in the current row
Shift-F11 – Opens up a new blank worksheet within the spreadsheet
Control-Home – Moves to cell A1
Aequor 