MS Office Training
By the end of this course, you will be able to solve even the most difficult problems in Excel from Conditional Formatting to Vlookup at advanced Level
Daily
- Learn Advanced Functions in an easy-to-understand language
- Get Lifetime Access to session recordings
- Get Certified in MS Excel by a Microsoft Certified Trainer
Register before June 01, 2024 to unlock bonuses worth over ₹ 9,500
Who is this workshop for?
What will you learn in this workshop?
- Excel Shortcuts Part 1
- Excel Shortcuts Part 2
- Excel Shortuct Revision Part 3
- Conditional Formatting Part 1
- Conditional formatting Part 2
- Charts Part 1 Column
- Charts Part 2 Line & Pie
- Charts Part 3 Combination Chart
- Charts Part 4 Secondary Axis
- Charts Part 5 Linking to PowerPoint
- Pivot Table Part 1
- Pivot Table Part 2
- Pivot Table Part 3
- Pivot Table Part 4
- Pivot Table Part 5
- Data Validation Part 1
- Creating Drop down in Cell
- Validation Part 2 Error Alert
- Data Validation Part 3 Whole Number
- SparkLines
- Dynamic Table Part 1
- Dynamic Chart Range
- Dynamic Table Part 2
- Automatic Formulas
- Dynamic Table Part 3
- Inserting Formula and Rows
- Dynamic Table Part 4
- Using Slicer for AutoFilter
- Dynamic Table Part 5 Freeze Top Row
- Dynamic Table Part 6
- Convert Dynamic
- Table to Normal Range
- Protection Part 1 File Level
- Protection Part 2 Sheet Level
- Protection Part 3 Workbook Level
- Protection Part 4 Cell Level
- Protection Part 5 Hiding and Protecting Formula
- Viewing all the Formulas
- Protection Part 6
- Making Read only File
- Protection Part 7
- Preventing your data from Copying
- Protection Part 8
- Password to each Range
- Recover Unsaved File
- Set timing for Auto Recovery
- Saving your file on Onedrive
- Group UnGroup Rows and Columns
- Get External Data
- Hyperlink Part 1 Linking to other Sheet
- Hyperlink Part 2 Linking in Same Sheet
- Hyperling Part 3
- Linking other file
- Inserting objects
Macros Recording & Running
- Sum and SubTotal Formula
- Min Max & Average Formulas
- Removing UnWanted Characters
- Trim Formula
- Change Case Formula
- Concatenate Formula
- CountIF in Same Sheet
- CountIF & SUMIF from other Sheet
- COUNTIFS in Same Sheet
- SUMIF in Same Sheet
- SUMIFS in Same Sheet
- IF Condition Formula
- Advanced IF Formula
- Linking data from multiple sheets
- Linking Multiple Sheets with Array Formula
- Vlookup Part 1
- Vlookup Part 2
- Vlookup with IFError Part 3
- Vlookup with Match Part 4
- Left Right Formula
- Left with Find Formula
- Mid Formula
- Today and Now Formula
- Round RoundDown RoundUp
- Text Formula
- Len Formula
- Substitute Formula
- Networkdays Formula
- Networkdays Intl Formula
- IF Condition with AND & OR
- Index and Match Formula
- Adding $ Sign in Excel Formulas in Detail
Activate your exclusive bonuses worth over
₹ 9,500
Excel Tips & Tricks E-Book
An Excel cheatsheet with shortcuts to simplify your learning and save your time.
₹4500
100+ PowerPoint Infographics
Create stunning presentations easily using premium Infographic Templates
₹2000
Customised Excel Template Bundle
An easy-to-use Excel template bundle to make your life easier
₹3000
10% Flat Discount on all future 5-day workshops
Lifetime 10% discount on all future 5-days workshops and webinars.
Priceless
Grab Your Bonuses Now! Time is running out!
- 00Hours
- 00Minutes
- 00Seconds
Meet your Trainer
- Microsoft Excel Specialist
- Microsoft Certified Trainer
- Power BI Analyst
- 55,000+ Students Trained
Ramzan is passionate about telling stories with data. Microsoft Certified Trainer,Excel Specialist with Power BI.
17+ years of experience in managing large databases, from requirements gathering through implementation and support.
Currently serving corporate clients across Gulf and Europe taking care of their training programs, helping them in preparing & analysing customized summaries & MIS Reports, Creating Dynamic HR, Sales & Financial Dashboards, Automating regular reports with Macros and Creating Interactive Dashboards using Power BI
Have conducted sessions in corporates such as Ferrari, Landmark, National Bank of Fujairah, Roche, King Span and many other companies in UAE, India, Saudi Arabia, Oman, Qatar, Malaysia & Maldives with excellent feedback.
Have trained more than 55,000+ people from various companies from Junior to Senior management across GCC locations.
Ramzan helps answering business questions using data in creative ways.
Earn your Excel Formulas Expert certification
Yes, you will receive certification from a Microsoft Certified Trainer, which lends a lot of credibility to your certificate and resume.
Register before June 01, 2024 to unlock bonuses worth over ₹ 9,500
You may not believe me, but you can believe them
Experiences shared by people who previously attended this workshop
Still Wondering If the Workshop is for YOU?
If you checked ANY of the boxes above, then you’re invited to join The 7 Days Excel Formula Workshop.
Frequently Asked Questions
We have answered all common questions below that you might have about the workshop. For any further queries, please reach us at [email protected]
Write to us at [email protected] and our support team will be able to resolve your issue in the shortest amount of time.
The workshop will be completely LIVE.
Yes, you will receive a certificate of completion from a Microsoft Certified Trainer after completing the workshop.