Hacker's Guide To Microsoft Excel (How To Use Excel, Shortcuts, Modeling, Macros, and more)

For an in-depth discussion of how to construct formulas, please refer to the Lehman College Information Technology Division’s thorough and easy-to-use Excel Formulas & Functions: Tips & Techniques.

According to Microsoft, “About Macros in Excel,”

Tip: Take the PivotTable tutorial on the Microsoft website before attempting one of your own.

One of the best ways to learn more about Microsoft Excel is to go to the Microsoft Support website to view tutorials.

Tip: To better acquaint yourself with the parts of a chart, check out Getting to Know the Parts of an Excel 2010 Chart by Greg Harvey at Dummies.com.

Tip: For details on how to format cell appearance (e.g. change font type, color or size), please see this excellent Excel formatting tutorial YouTube by MotionTraining.