Excel Quick Start Tutorial: 36 Minutes to Learn the Basics
Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!
2 hours of content
What you'll learn
- Excel data can be entered and edited. Numbers, fonts, and alignment should all be formatted.
- Create basic pivot tables and charts.
- Make basic Excel formulas.
- Filter and sort data lists using the Excel functions IF and VLOOKUP. Determine the "Top 10" values.
- To de-duplicate data and calculate totals, use Excel table functions.
- Learn how to use Excel to analyse data in a business setting.
- Make a basic sales analysis report.
Covers entering and editing Excel data, formatting, formulas, filtering and sorting, IF and VLOOKUP functions, pivot tables, and charts. Uses a sales reporting case study to demonstrate data analysis. Learners can create basic sales analysis reports and summarize data in Excel.
Who this course is for
Ideal for beginners who need a fast introduction to Excel for business reporting and analysis.
#excel
#pivot-tables
#formulas
#vlookup
#data-analysis
#charts