*** Proof of Product ***
Exploring the Essential Features of “Centre of Excellence – Advanced Excel Diploma Course”
What Will You Learn?
Data has always been important to businesses and will only become more so. Being able to effectively manipulate, learn from and display the information within spreadsheets so that you and others can gain insight from them, is a skill that any business will find desirable – making those who can do so, a real asset.
The Advanced Excel Diploma Course will elevate your expertise in the use of Excel – explaining advanced formulas, data manipulation, graphical representation, security, accuracy, and annotation, advanced statistical analysis tools and error fixing.
We’ll begin by exploring how to set up and use pivot tables and how to slice and filter the data for advanced analysis, using macros to automate repetitive tasks and increase efficiency and take an introductory look at VBA.
From there, we’ll move onto wildcard expressions and advanced functions such as SUMIF and COUNTIF, and using AVERAGEIF, IFS, SUMIFS and COUNTIFS for advanced analysis, along with how to use the LOOKUP function, and its variations, to search and reference data.
We’ll look at how to secure and protect data from unauthorised usage, how to make information more readable for others with comments and notes, and how to perform Find and Replace queries. The course also covers how to validate data and create drop-downs and spreadsheets with advanced features to limit the entry of invalid data.
For those who require advanced statistical analysis, you’ll learn how to use Excel’s powerful statistical functions and the Analysis ToolPak add-in to extend functionality even further.
Lastly, the course covers the most common errors that you may come across in Excel and how to correct them.
By studying this course, you will:
- Know how to navigate Excel, view and print Excel files, and be aware of which tools are at your disposal and how to find them
- Understand how to effectively format and calculate within Excel
- Understand what can be achieved with Excel regarding functions and advanced formulas
- Be able to effectively present data using charts and graphs
- Learn how to use advanced statistical analysis tools
- Be able to avoid common Excel errors
Course Syllabus
What will I learn on the course?
Module 1: Pivot Tables 8 parts
Introduction
Part 1: Pivot Tables
Part 2: Advanced Pivot Table Functions
Practical Task
Practical Task Answers
Test Your Knowledge
Key Learning Points Exercise
Module 1 Assessment
Module 2: Macros 6 parts
Part 1: What is a Macro?
Part 2: Creating a Macro
Part 3: Visual Basic
Test Your Knowledge
Key Learning Points Exercise
Module 2 Assessment
Module 3: Wildcards and Advanced Functions 7 parts
Part 1: Wildcard Expressions
Part 2: Absolute Cell References
Practical Task
Practical Task Answers
Test Your Knowledge
Key Learning Points Exercise
Module 3 Assessment
Module 4: More Advanced Functions (Intro to IFS) 8 parts
Part 1: AVERAGEIF Function
Part 2: IFS Function
Part 3: COUNTIFS Function
Practical Task
Practical Task Answers
Test Your Knowledge
Key Learning Points Exercise
Module 4 Assessment
Module 5: Lookup Function and its Variations 8 parts
Part 1: Lookup Function
Part 2: HLOOKUP Function
Part 3: VLOOKUP Function
Practical Task
Practical Task Answers
Test Your Knowledge
Key Learning Points Exercise
Module 5 Assessment
Module 6: Security and Data Protection 5 parts
Part 1: Sharing a Workbook
Part 2: Protecting an Excel File
Test Your Knowledge
Key Learning Points Exercise
Module 6 Assessment
Module 7: Data Validation 6 parts
Part 1: Data Validation
Part 2: Create Drop Down Menus Through Data Validation
Part 3: Circle Invalidated Data
Test Your Knowledge
Key Learning Points Exercise
Module 7 Assessment
Module 8: Add Ins and Statistics 7 parts
Part 1: Statistical Functions
Part 2: Add Ins
Practical Task
Practical Task Answers
Test Your Knowledge
Key Learning Points Exercise
Module 8 Assessment
Module 9: Comments and Searching Data 5 parts
Part 1: Comments and Notes
Part 2: Search Functionality Within Excel
Test Your Knowledge
Key Learning Points Exercise
Module 9 Assessment
Module 10: Errors 6 parts
Part 1: Errors are Inevitable
Part 2: Understanding What the Error Means
Conclusion
Test Your Knowledge
Key Learning Points Exercise
Module 10 Assessment
Who Would Benefit from This Course?
You could be looking for an office career and want to put yourself above other candidates and be able to offer instant value to an employer. You may have a basic understanding of Excel and want to learn how to be more effective, faster, and more secure when using the software.
If you have a working knowledge of Excel and want to unlock the true potential of the software that you know is there but don’t know how to use, the Advanced Excel Diploma Course is for you.
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
