Microsoft Excel Advanced

Course details

What Will I Learn?

• Use Advanced IF Statements
• Use Advanced Lookup Functions
• Use Complex Logical and Text Functions
• Auditing Formulas
• Working with What-If Analysis Tools
• Protecting Worksheet and Workbook
• Use Advanced PivotTables and PowerPivot Tools
• Automate with Macros
• Work with Form Controls
• Ensure Data Integrity
• Import and Export Data to a Text File

Course Overview

This Excel 2016 Advanced course will take you through key excel functions. You will learn about the controls in excel and how to use them.

If you are interested in becoming an advanced level Excel 2016 user, then this course is for you. You will be able to formulate statements to better analyse data.

Upon completion, you will understand various tools in Excel 2016. This course will guide you through using advanced if statements, automating with macros and formula auditing. You will also learn about complex text functions. During this course, you will have the opportunity to take an assessment to consolidate your learning.

Excel 2016 Advanced is the best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant ;

This course is accredited by CPD so you will get a career boost upon completing this course. Our Excel 2016 Advanced is packed with 65 modules and 3 hours, 1 minute of study. You will be awarded a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.

It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and ;

Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

COURSE CURRICULUM

• Introduction
• Using Advanced IF Statements
• Using Advanced Lookup Functions
• Using Complex Logical and Text Functions
• Formula Auditing
• What-If Analysis Tools
• Worksheet and Workbook Protection
• Advanced Use of PivotTables and PowerPivot
• Automating with Macros
• Working with Form Controls
• Ensuring Data Integrity
• Collaborating in Excel
• Importing and Exporting Data to a Text File
• Conclusion
• Course Certification
• Mock Exam
• Final Exam

Updated on 03 August, 2023 - Read Less