Rating 4.75 out of 5 (13 ratings in Udemy)
What you'll learn- How to navigate the Excel application.
- Entering and formatting data in Excel.
- Writing Microsoft Excel formulas.
- Using some of Excel's built-in functions.
- Converting data into Excel tables.
- Sorting and filtering Excel data.
- Preparing and printing Excel documents.
- Building Excel pivot tables.
- Creating Excel charts.
- Using Excel's popular lookup functions.
Description Rating 4.75 out of 5 (13 ratings in Udemy)
What you'll learn- How to navigate the Excel application.
- Entering and formatting data in Excel.
- Writing Microsoft Excel formulas.
- Using some of Excel's built-in functions.
- Converting data into Excel tables.
- Sorting and filtering Excel data.
- Preparing and printing Excel documents.
- Building Excel pivot tables.
- Creating Excel charts.
- Using Excel's popular lookup functions.
DescriptionWho Is This Course For?
Anyone who wants to learn Microsoft Excel.
Those who have used Excel in the past, but need a refresher.
Why Take This Course?
Increase your earning potential by having skills employers want.
Have the skills to apply for more jobs.
Learn what you need to learn quickly with short, focused lectures.
Try out what you're learning with practice exercises.
Test your understanding with quizzes.
What's Covered in the Course?
Navigating Microsoft Excel.
Entering and formatting Excel data.
Writing Excel formulas and using some of its built-in functions.
Converting data to Excel tables.
Sorting and filtering data in your Excel worksheets.
Using multiple Excel worksheets.
Preparing and printing your data.
Building Excel pivot tables.
Creating Excel charts.
And using Excel's VLOOKUP and HLOOKUP functions.
You'll also learn some Excel shortcuts along the way.
What the Course Contains
Short, focused lectures.
Quizzes.
Practice exercises.
Practice exercise solution videos.
PDF versions of all the presentations in the course.
A zip file with all the course resource files.
The course was created on a Windows 10 PC using Excel for Microsoft 365. If you're using a Mac or an older version of Excel, you may need to make some adjustments to the steps I show you.
Why Take My Course?
I've been using spreadsheets since before Excel existed.
I've been using Microsoft Excel since it was released in 1985.
I have taught Excel to adult learners in several different settings, including as a trainer for CompUSA.
I love using Excel and use it almost every day for business and personal use.
Coming Soon!
Additional enhancements and updates are always being made to the course. I'm currently working on adding:
Challenge Exercises - Interactive videos that let you test your knowledge, even if you don't have Excel!
Conditional Formatting - This section will be added to the course.
I can't wait to see you in class!
