DITRP

CERTIFICATE IN ADVANCED EXCEL -(C1081)

CERTIFICATE IN ADVANCED EXCEL

About the Course

ADVANCED EXCEL

Course Syllabus

Introduction to MS Excel and Understanding Basic Working with it
Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets and
Difference between Excel 2003, 2007, 2010 and 2013
Saving Excel File as PDF, CSV and Older versions
Using Excel Shortcuts with Full List of Shortcuts
Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
Using Paste Special Options
Formatting Cells, Rows, Columns and Sheets
Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
Page Layout and Printer Properties
Inserting Pictures and other objects in Worksheets

Conditional Formatting
Using Conditional Formatting
Using Conditional Formatting with Multiple Cell Rules
Using Color Scales and Icon Sets in Conditional Formatting
Creating New Rules and Managing Existing Rules
Data Sorting and Filtering
Sorting Data A-Z and Z-A
Using Filters to Sort Data
Advance Filtering Options
Pivot Tables
Creating Pivot Tables
Using Pivot Table Options
Changing and Updating Data Range
Formatting Pivot Table and Making Dynamic Pivot Tables
Pivot Charts
Creating Pivot Charts
Types of Pivot Charts and Their Usage
Formatting Pivot Charts and Making Dynamic Pivot Charts
VBA Macro
Introduction to VBA Macro
Recording Macro & Understanding Code Behind
Editing, Writing VBA Code and Saving as Macro or Add-In
Adding Add-Ins in Excel
Trainers with minimum 6 Years+ Working Experience
Free Training Materials and References
Wi-Fi Network, Laptop and other Resources for Training
Life Time Membership for Registered Course
Small Batches for unparalleled person-to-person access to trainers
Refer Your Friends and Get up to 20% of Total Fee Paid
Certification from AKME Analytics

.