
CERTIFICATE IN ADVANCE EXCEL:
Join our advanced Excel course to propel your skills to new heights! Designed for individuals with a fundamental understanding of excel, this program delves into advanced functions and formulas, data analysis tools like pivot tables and power query, macro automation, data visualization techniques, data validation and protection, advanced data cleaning and transformation, collaboration and sharing methods, and expert tips and tricks. Elevate your data analysis capabilities and become a proficient advanced Excel user with our comprehensive course.
What you learn:
· Introduction to formulas
· Professional charts building
· Advance functions
· Automated report building
· Data consolidation and validation
· Pivot table and pivot charts building
· Data visualization and analyzation
· Executive basic dashboard
· Database concepts
· Short keys
· Advanced lookup function
Tools
- Basic Excel
- Advanced excel
Exit Profile
- Accountant
- Assistant Accountant
Course Curriculum
ADVANCE EXCEL
-
The Named Range
-
The Lookup Functions
-
The Hlookup
-
The VLOOKUP
-
More Working with Hlookup
-
Create Currency
-
Rate Calculator with VLOOKUP
-
The Lookup
-
The If Functions
-
Financial Functions
-
Data Base Concepts & Its Functions
-
Misc. Valuable Functions
-
The Sorting
-
The Filters
-
The Advance Filters
-
The Subtotals
-
The Data Validation
-
The Form
-
Charts Concept
-
Working with Chart
-
Macro
-
Running the Macros
-
Modifying the Macro
-
Macro or Procedure
-
Adding Comments
-
Converting Numeric into Text Adding Controls
-
The Conditional Formatting
-
The Grouping and Outlines
-
The Pivot Table
-
Apply Data Analysis and Pivot Table
-
Use Pivot Table Auto Format
-
Create Pivot Chart Reports
-
Manipulating A Pivot Table
-
The Solver
-
Some More Essential Tips