CCAE

Overview

This course helps in promoting Excel professionals to an advanced level and strengthens skills required for reporting, automation, and data handling.

Objective

Upon completion of this course, the participant will be an expert in advanced Excel features, including macro programming and functions.

Target Audience

BBA / MBA Students, Data Analyst, Auditor, BPOs, Call Centre Professionals, Data Conversion Technicians, Programmers.

Course Coverage

Advanced Excel

• Introduction to MS Excel and understanding basic working
• Formatting Worksheet
• Working with Formulas and Functions
• Lookup and Reference Functions
• Logical Functions
• Database Functions
• Date and Time Functions
• Information Functions
• Math and Trigonometry Functions
• Statistical Functions
• Text Functions
• Conditional Formatting
• Connect to other Database
• Data Sorting and Filtering
• Pivot Tables and Charts

VBA Programming

• VBA Overview
• VBA Programming Variables
• Conditional Logic
• String and String Functions
• Programming Loops
• Programming Arrays
• Subs and Functions
• Creating your First Macro
• Excel VBA
• Excel Objects
• Excel Events
• Excel VBA Error Handling
• Excel VBA and User Forms
• Connect with External Data
• Work on Automation Project

⬅ Back to Certification Courses