The course provides an overview and in-depth access to the Excel environment to equip students with skills that let them collaborate, automate complex tasks, and utilize conditional logic to create and apply formulas and functions.
Who should attend this course?
The target audience for this training are students experienced in Microsoft Excel 2019. Although, students who have deep interest in learning Microsoft Excel features can enrol in this course. You will learn how to troubleshoot complex, large spreadsheets, construct Excel functions and functionalities in performing extensive datasets.
What you will learn
Creating map data and spark lines.
Protecting and sharing workbooks.
Functioning with workbooks and multiple worksheets.
Utilize formula audit and lookup functions.
Automating workbook functionalities.
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
Use Links and External References
Use 3-D References
Collaborate on a Workbook
Protect Worksheets and Workbooks
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Use Lookup Functions
Watch and Evaluate Formulas
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecast Data Trends
REVIEWS ON OUR POPULAR COURSES