Microsoft Excel Part 3
Mastering Excel is a process. Our live online classes offer hands-on experience with an expert instructor to guide you at every step, and a textbook pdf you can keep as a reference. Combine the three Excel class levels for maximum skills, or take a single class to move your talent up a notch. Excel gives you the power to organize, calculate, analyze, update and present your data, helping decision-makers move in the right direction.
With advanced Excel skills, you can wield the full power of Excel. Advanced skills allow you to get answers from vast amounts of data, use forecasting data, map data and collaborate with colleagues.
To get the most from theadvanced class, you should already know how to:
- Configure Excel options, customize the ribbon and toolbar, and enable Add-Ins
- Use range names, specialized functions and advanced conditional formatting
- Sort and filter data and use database functions
- Create, modify and format charts
- Create PivotTables and use them to analyze and present data
Course Preview Video 0:31
Prior Learning
This noncredit course is beginner-friendly, with no prior expertise required. However, to ensure success, students should:
- Be comfortable reading and understanding English, as all materials are provided in English.
- Have basic computer skills, including navigating the internet, downloading/uploading files, installing software, and using applications like Microsoft Word.
- A basic understanding of math principles such as addition, subtraction, multiplication, division, and fractions is recommended.
These foundational skills will help you engage fully with our primarily online courses.
- Use Links and External References
- Use 3-D References
- Consolidate Data
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
- Create Sparklines
- Map Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
- Microsoft Office Excel Exam 77-727
- Microsoft Office Excel Expert Exam 77–728
- Microsoft Excel Common Keyboard Shortcuts
- Cube Functions
- Importing and Export Data
- Internationalizing Workbooks
- Working with Power Pivot
- Advanced Customization Options
- Working with Forms and Controls
$160.00
Cristy Stamps
Microsfot Excel Course Instructor
Course Schedule
Professional and Workforce Development
Microsoft Excel Part 3
Modality:
Online Instructor-led
Upcoming Start Date:
June 06, 2025
Registration Deadline:
May 30, 2025
Cost:
$160
Professional and Workforce Development
Microsoft Excel Part 3
Modality:
Online Instructor-led
Upcoming Start Date:
August 22, 2025
Registration Deadline:
August 15, 2025
Cost:
$160
Professional and Workforce Development
Microsoft Excel Part 3
Modality:
Online Instructor-led
Upcoming Start Date:
November 14, 2025
Registration Deadline:
November 07, 2025
Cost:
$160