Microsoft Excel: Quick Start
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.
Requirements
- Access to a recent version of Microsoft Excel would be helpful, but is not required.
Description
Who 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!
Who this course is for:
- Totally new Excel users.
- Excel users who need a refresher.
Instructor
Brenda Keller has been in various information technology roles over her 30+ year career. One of her roles was leading in-person training classes for Microsoft Office products including Excel, Word, Access, and PowerPoint, in addition to Microsoft Windows.
She has created training documentation in every position she has ever worked in and put together an entire training program for the first-level help desk she was a part of at Electronic Data Systems. Utilizing the training program she created, she trained new employees to help acclimate them to the help desk environment and prepare them to support customers.
Brenda loves working with and helping others learn how to use software applications. Her easy-going training style helps make students feel comfortable as they learn new skills.