Microsoft Excel Part 2
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.
You have basic Excel knowledge, but you want more. This mid-level class offers skills needed to create customized, advanced Excel workbooks and sheets. You will begin to analyze data by using functions, conditional formatting and PivotTables.
To get the most from the intermediate class, you should already know how to:
- Create, format, save and print a workbook
- Insert, delete and adjust cells, columns and rows
- Search for and automatically replace data
- Use worksheet formulas, functions and formats
- Manage Worksheets and Workbooks (views and properties)
Course Preview Video 0:21
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.
- Configure Excel Options
- Customize the Ribbon and the Quick Access Toolbar
- Enable Excel Add-Ins
- Use Range Names in Formulas
- Use Specialized Functions
- Use Array Formulas
- Analyze Data by Using Text and Logical Functions
- Apply Advanced Conditional Formatting
- Create and Modify Tables
- Sort Data
- Filter Data
- Use SUBTOTAL and Database Functions
- Create Charts
- Modify and Format Charts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Slicers
$160.00
Cristy Stamps
Microsfot Excel Course Instructor
Course Schedule
Professional and Workforce Development
Microsoft Excel Part 2
Modality:
Online Instructor-led
Upcoming Start Date:
April 25, 2025
Registration Deadline:
April 18, 2025
Cost:
$160
Professional and Workforce Development
Microsoft Excel Part 2
Modality:
Online Instructor-led
Upcoming Start Date:
July 25, 2025
Registration Deadline:
July 18, 2025
Cost:
$160
Professional and Workforce Development
Microsoft Excel Part 2
Modality:
Online Instructor-led
Upcoming Start Date:
October 17, 2025
Registration Deadline:
October 10, 2025
Cost:
$160