Learn Excel in 3 Hours Flat

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

This class is perfect on-the-job training.

We will cover:

  1. Moving around in a spreadsheet
  2. Entering Data
  3. AutoFill Handle
  4. Formulas
  5. Functions
  6. Relative & Absolute Cell References
  7. Formatting
  8. Conditional Formatting
  9. Sparklines
  10. Charts
  11. Data Tables for filtering
  12. Pivot Tables
  13. Tracing Dependencies
  14. Printing tips

Expected Outcomes

  1. By the end of this course, you will be able to create a spreadsheet from scratch, format it for at-a-glance understanding, and use advanced tools for data analysis.
  2. Enter data
  3. Create formulas and functions
  4. Use Absolute Cell Formatting to copy formulas anywhere
  5. Use AutoFill to replicate values and formulas
  6. Format appearance for quick understanding
  7. Create Charts of several types
  8. Use Data Tables to manage lists
  9. Use Pivot Tables to analyze data
  10. Take control of your Printing