*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Ms Office – Advanced Excel 🏷️

Be the first to rate Advanced Excel
Or log in to access your purchased courses
by admin
Price: 15,000
1 Month
0 Lessons

Excel Course

Ms Office – Advanced Excel Course

Microsoft Excel is a leading and very high-demand office automation tool used all across industries for example Banks, Insurance, Telecom, Public Sector and many Small and Medium size Organization to perform Complex calculations, Data Analysis, Reporting and Dashboards creation, understanding financial modeling, learning Advanced Excel is a highly valuable career Asset, a must-have criteria to qualify for many jobs!

Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance. A best and most affordable advanced excel training @ Omni Academy.

Advanced Excel Course

Course Content:

Module-I – Excel Foundation 

  • Getting Started with Excel
  • Data Entry, Data Editing, and Number Formatting
  • Data Formatting
  • Working with Cells and Ranges in Excel
  • Managing Worksheets
  • Save Your Worksheets

Module-II – Formula | Data | Charts Concepts

  • Formula Basics & Cell References
  • Auto Fills & Custom Lists
  • Working with Basic Excel Functions
  • Using Smart Tables
  • Sorting & Filtering Data
  • Working with Conditional Formats
  • Working with Charts

Module-III –  Using Advanced Functions

  • Working with Named Ranges
  • Using Complex Excel Functions
  • Using Multi-sheet Formulas
  • Using Advanced Filters
  • Data Validation & Protection
  • Consolidation & List Management
  • Automating with Macros

Module-III – Reporting & Dashboards 

  • Business Reporting with Excel Dashboards
  • Advanced Charting & Visualizations
  • Using Sparkline Charts
  • Creating Interactive Dashboard Reports

Module-IV – Working with Macros & Custom Functions 

  • Writing Customized Macros
  • Using What-If-Analysis
  • Working with Financial Functions
  • Creating Custom Excel Functions

Duration: Two Month – Approx (3 Days Fast Track Available)

Flexible Class Options

  • Evening Classes | Corporate Workshops | Fast-Track
  • Week End Classes For Professionals  SAT / SUN
  • Online Classes – Live Virtual Class (L.V.C), Online Training

-30% Discount on group of ten (10) or more
-20% Discount for Omni student

Job Interview Preparation  (Questions & Answers)

International Student Fee : 100 USD

Trainer profile

Trainer: Mr. Kashif uddin

Sir Kashif is Microsoft Certified Trainer, Industry Experience Trainer, Delivered 100+ sessions.
Professional Background: IT trainer at IBA, Sr. learning technology facilitator at Agha Khan education service.

Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses

Computerized Accounting Course 

Advanced Excel Guru 

MS Office Complete Course 

Financial Modeling Course

Microsoft Certified Solutions Associate (MCSA) Office 365



Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now



Or log in to access your purchased courses
Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise.

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us