fbpx

Learn the advanced features and workings of Microsoft Excel

This course offers an exciting, innovative approach to Microsoft Excel training, making studying with us even accessible and adaptable to your needs.

Do you know that Advanced Excel can instantly increase your job prospects as well as your salary?

How exactly can your career benefit from learning Microsoft Excel?

Microsoft Excel Expert

Special offer! Enroll now and get a 30% discount !


Here’s What You’ll Get When You Sign Up

This paragraph here is to explain how your online course works. Tell them what exactly will happen after they sign up. Do they get access to all of it straight away? How much time will it take them to complete the course? What result will they get at the end?

Data Modeling

Data Modeling allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel. This is the most advanced and demanding feature of Excel.

Excel Dashboard

An Excel dashboard helps managers and business leaders in tracking key KPIs and take a decision based on it. It contains charts/tables/views that are backed by data. 

Business Intelligence

Business intelligence (BI) is essentially the set of tools and processes that Excel use to gather data, turn it into meaningful information, and then make better decisions. 

Work Automation

Automatic and repetitive work with the help of simple & dynamic macro functions to save time and better analysis.

Show them what’s in the course

Let your visitor know how many modules there are and what each one is about.

1

Module 1 - Module 4:

- Data calculations, watermarks, converting text to columns fill and flash fill.

- Data consolidation, paste special, working with ranges & name range.
- Hyperlinks and formatting charts.

- Applying functions and formulas.
- Relative, Absolute an Mixed Cell References.

2

Module 5 - Module 8

- Conditional & advanced conditional formatting.
- Single level sort, Multi level sorting, Custom sorting 

- Subtotals and database functions.
- Filter and Advanced filter
- Work Automation with macro.
- Data validation, precedent/dependent cells, tracing errors, evaluating formulas.

3

Module 9 - Module 12

- Protecting worksheets and workbooks, passwords and file properties.
- Sharing and merging workbooks and grouping and ungrouping data.
- Pivot tables & Pivot charts.
- Data Modeling with Pivot Chart
-IF,Nested IF, IF AND, IF OR, SUM IF, SUM IFS, COUNT IF, COUNTIFS

4

Module 13 - Module 17

- VLOOKUP, HLOOKUP
- Scenario manager, Goal seek, Forecasting  and data tables.
- INDEX and MATCH, NOW and TODAY and COUNTA, COUNTBLANK
- Using financial, nested and the CONCATENATE functions.
- Create and modify custom workbook elements

BONUS FEATURES

Now it’s time to introduce you Bonuses!

BONUS FeATURE 1
Dynamic VLOOKUP

VLOOKUP with approximate match.

VLOOKUP with full records using single VLOOKUP
VLOOKUP with Index match using macro


BONUS FEATURE 2
Random Data Function

Random Numeric Data and its implication.

Random Text Data and its implication.

Automatic Serial & batch Number Generation


BONUS FEATURE 3
Protecting & Saving Data

Automatic Data Backup

Permanently hiding a Sheet

Auto Data Protection  online


About The Course Teacher,
Zain-ul-Abidin

Write this section in third-person, meaning you should not use the words ‘I’ or ‘We’ or ‘Me’. Instead, talk about the course teacher objectively using 'he' or 'she' even if you are the teacher! It’s time to show off your achievements and prove why you are the right person to be teaching this topic.


But just after you’ve talked yourself up, make sure you end on a friendly note. You don’t want to sound intimidating, you want to sound knowledgeable and friendly.

Excel Trainer
Excel Trainer

Don’t wait! Look at what past students have to say about this course

Debra Grant

Reporter

Pull out a few key words for a testimonial title

These 3 testimonials should focus on why past customers found that your course was absolutely the right decision. Remember, your visitors are looking for reasons not to buy after they see the price, so include some testimonials here that alleviate that anxiety.

Linda Parker

Police Officer

Pull out a few key words for a testimonial title

These 3 testimonials should focus on why past customers found that your course was absolutely the right decision. Remember, your visitors are looking for reasons not to buy after they see the price, so include some testimonials here that alleviate that anxiety.

Glenda Sanders

Financial Advisor

Pull out a few key words for a testimonial title

These 3 testimonials should focus on why past customers found that your course was absolutely the right decision. Remember, your visitors are looking for reasons not to buy after they see the price, so include some testimonials here that alleviate that anxiety.

Frequently Asked Questions

What are common questions abou​​​​t your course?​

What are common questions abou​​​​t your course?​

Can You Put Example Questions Here? 

Can You Put Example Questions Here? 

Can You Put Example Questions Here? 

Can You Put Example Questions Here? 

Pitman Training Pakistan