This Advanced Excel Training Course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. Microsoft Excel is one of the most commonly used products of Microsoft office.
Course Contents
This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. This Micro Soft Excel course is Advance Level or Expert Level training especially for engineers, data analysts, data scientists, students, teachers, or researchers, or for anyone who has basic or intermediate level Microsoft Excel knowledge & now wants to learn Advance Level, MS Excel.
Audience
- Minimum requirement of formal education is Matric
Certificate
-
On successful completion of the Course Participants will be awarded a Participation Certificate from AUS Trainings (INSTITUTE OF MODERN TECHNOLOGIES)
Course Information
-
Classes:
8 Weeks, With 3 classes of 3 hours in a week
-
Course Duration:
2 Months
-
Total Credits:
72 Hours
-
Student Capacity:
Max 10 Students / Batch
-
Class Schedule:
Monday To Saturday
-
Class Time:
9.00 am - 10.00 pm
-
Course Experts:
01
Training Methodology
- Lectures & Demos by industry experts
- Project Driven Hands-On approach
- Focus on latest tools, technologies & industry practices
- Assignments & Quizzes for Participant’s Evaluation
Course Outlines
✓ Fundamentals of Microsoft Office
✓ Excel Introduction
✓ Customizing Excel
✓ Learn the Data Analysis
✓ Apply Functions (All Types)
✓ Formatting and Proofing
✓ Lookup Data
✓ Protecting File and Sheet
✓ Multiple Sheeting Access
✓ Advanced and Special Techniques
✓ Charts and Graphs
✓ Sorting and Filtering
✓ Printing Workbook Settings
✓ Pivot Tables
✓ Excel Dashboards
✓ VBA Macros
✓ Variables and Procedures
✓ IF and Select Statements
✓ Looping In VBA
✓ Mail Function VBA
✓ Assignments