MS-OFFICE
- Microsoft Word Basic
- Microsoft Word Advanced
- Microsoft Excel Basic
- Microsoft Excel Intermediate
- Microsoft PowerPoint Basic
- Microsoft PowerPoint Advanced
- Microsoft Outlook Basic
- Microsoft Outlook Intermediate
- Microsoft Outlook Advanced
INTERNET
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