MS Excel is the foundation of each organizational business function, be it strategy, finance or accounting, operation, HR, Sales etc. Worldwide millions of professionals and students alike use Excel on a daily basis.
MS Excel has many user-friendly, time-saving, exciting functions and tools that has the potential to increase productivity to new horizons but most of us are not aware of the un-discovered power of MS Excel. Therefore, a strong working acquaintance of MS Excel would help professionals and students to succeed in their respective professional & career paths.
Advanced Excel Outline:
Workbooks (File) & Worksheet Handling
- Excel Limitation.
- Excel Shortcuts: use and Benefits.
- Excel Setting and Custom List Creation.
- Excel Template and File Location System.
- Advanced Paste Special.
- Calculation with Paste Special.
- Link Data Range as Picture Link.
Advanced Formatting for Reports and Dashboard
- Formatting Tricks.
- Date & Time Format.
- Advanced Custom Formatting (Number Format using Code).
- Conditional Formatting.
- Advanced Conditional Formatting using Formulas.
- Files, Sheets or Cells Protection Method.
Data Handling and Data Analysis
- Data Fill and Selection Method.
- Advanced Sorting and Filter.
- Data Summarization with Pivot Table.
- Calculation with Pivot Table.
- External Data Pivot Table.
- Timeline and Slicer in Pivot Table.
- Power Pivot in Excel 2016 / 2019 [Latest Version be succeeded by Office 2021 subsequently]
Calculation (more than 200 Formulas)
- Formula Basics for Advance Level Formulas.
- Logical Formulas (IF, AND, OR, IF Error Formulas).
- Nested IF Formulas (Multi Condition in IF, AND, OR).
- Text and Advanced Text Formulas.
- Date and Time Calculation using Data Time Formulas.
- Ref# Formulas and V Lookup.
- Lookup Method (V Lookup, H Lookup, Match, Index, Offset).
- Advanced V Lookup and V Lookup Listing.
- Math & Trigon Formulas.
- Data Summarization Formulas.
- Average If, Average Ifs, Count If, Count Ifs, Large, Small.
- Database and List Management Formulas.
- Information Formulas.
- Financial Formulas.
- Advanced Array Formulas.
- Complicated Large Formulas Creation.
- Advanced Naming Method with Formulas.
- Report Automation with Formulas.
Dashboard Report Automation
- Chart Creation.
- Chart Tricks.
- Dynamic Chart with Offset Formulas.
- Dashboard Example.
This Course contains Practical Work involving Practical Hands-On, Lab Assignments, and Real World Case Studies. This practical work can be done at your own pace. Delphi Star Training provides the best Excel Training Services you may ever have from anywhere else.
Who should attend?
- This Program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, knowledge of the basics of Excel, including how to Create, Edit, Format, and Print Worksheets that include Charts, Sorting and Filtering Data, but would like to extend their knowledge of the more Advanced functions of Excel to become more Productive and make the most of Excel.
- The Course is designed for Professionals would want to learn more Complex Formulas, Troubleshoot and Customize Excel Application, Automate Excel Files and Create Dashboards how to Sort and Filter more Specific data, Import and Export Data Sets, Analyze Data using the rich features provided in Excel. It will impart the necessary skills to create Macros.
Certified & Professional Trainers
Our faculties are qualified & industry experts with significant experience in their domain.
Live Instructor Led Training
We conduct live classes through GoToMeeting, Zoom and other live meeting software.
Cloud e-learning portal
Get live class notifications, view class recordings, or practice questions all in one access.
Flexible Batch Timings
All our batch schedules are designed to support work while you study principle.
We guide you to benefit from the newly acquired global professional certification.
Reputed Study Materials
We provide internationally reputed study materials with our customized success slides.
Self Paced Video Course
Study on your Own?
Don’t have time to attend the live classes, No worries. Get our online Self Study kit and access to our e-learning portal at the best price and prepare for your CISSP Training in Dubai in your own style.
Get Access to
- 30+ Hours Recorded Videos
- Practice Questions
- Access to e-learning portal
- Up to 4 Hours Expert Doubt Clearing Session