WELCOME TO DITRP
CERTIFICATE IN ADVANCED EXCEL ( C1081 )

BASIC INFORMATION

  • Course Duration : 3 MONTHS

 

 

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

 

 

.