How to Use Excel
by Julia Lee
What is Excel?
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot tables, and many other things!
Some Easy but helpful tools!
Sparklines
To create your own Sparklines, select the data range and on the ribbon click Insert and then select the Sparklines type—Line, Column or Win/Loss. Next enter the target range where you want the Sparkline displayed. That’s all there is to it.
Conditional Formatting
To create a heat map using Conditional Formatting, select your raw data and then on the ribbon under Home, click Conditional Formatting > Color Scales and then pick a color scale. You can also adjust color scale options by editing the formatting rule.
LookUp Formulas
lookup formulas (VLOOKUP, HLOOKUP, INDEX, MATCH etc.) are their favorite feature of Excel. Lookup formulas help you locate any information in your workbooks based on input criteria. By knowing how to write lookup formulas, you can build dashboards, make interactive charts, create effective models & feel pretty darn awesome.
most OF THESE FEATURES CAN BE USED IN GOOGLE sheets!!
For sparklines
You can draw a line in the drawing option in the Insert tab
lookup formulas
You can go to Insert>Function and then go to more and then it takes you to another page to where it gives you examples and options for other formulas you can use
Google Sheets
Although Google Slides is an easy to use close second to Excel I believe Excel is a much better and easier option to use with all it's multiple tools you can use!
Google Sheets vs. Microsoft Excel