The course is second in the series and covers the Office Specialist program necessary for Excel associate and Expert certification. During the course we teach students to execute basic calculations, modifying worksheets, analyzing data and using different functions. Those who take part 1 of the course are ideal candidates and can learn the intermediate to advanced skills.
Who should attend this course?
The course is for learners who already gained foundational knowledge through course 1 in Excel 2019 and are now wanting to proceed into a more intermediate and advanced environment of Excel for data analysis and other advanced functions and present data.
What you will learn
Working with functions.
Working with lists.
Visualizing data with charts.
Using PivotTables and Pivot Charts.
With Microtek Learning, you’ll receive:
Certified Instructor-led training
Industry Best Trainers
Official Training Course Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
- 300+ enterprise clients
- 100,000+ professionals trained
- Service 70 of the Fortune 100
- 96% of our clients would recommend us
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date and Time Functions
Work with Text Functions
Query Data with Database Functions
utline and Subtotal Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Modify and Format Charts
Use Advanced Chart Features
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
REVIEWS ON OUR POPULAR COURSES