Microsoft Excel Training Course - Online MS Excel Basic to Advanced 0
1 / 6





EXCEL TRAINER: 15 years Professional Working of Finance

ONLINE TRAINING: Zoom Cloud Meeting Application

CERTIFICATE: E-Certificate provided on completion of Training

HOME WORK: Excel Workbook provided to participants for practice at home at the end of each session


Microsoft Excel is the most widely used productivity tool, Microsoft Excel allows us to accomplish a task in multiple ways allowing us to accept more challenging tasks resulting in an efficient and effective performance.

You will learn Advanced Excel Features & Functions such as:


• Pivot Table: Value Field Setting, Slicer, Timeline, Frequency Distribution, Calculated Field items

• Excel Dashboard: Uses of Control form, Link Data with charts & dynamic presentation

• Lookup Function: VLookup, HLookup, Reversal VLookup & Index & Match Function

• Summarizing Functions: SumProduct, Sumifs, Sumif Functions

• Count Functions: Countifs, Countif, CountA, & Countblank Functions

• Offset Function, Indirect Function, Choose Function

• Database Function: Dsum, Daverage, Dcount, Dmax, & Dget Functions

• Whatif Analysis, Hyperlink, Data Consolidation, Data Sorting, Subtotal Options

• Data Validation, Logical Function IF, AND & OR

• Conditional Formatting: Highlighted Cell, Data Bars, Color Scale, Icon Set, New Rules

• Time, Days, Date, Year, Month Function, Elapsed time calculation

• Text Function: Trim, upper, Lower, Proper, Concatenate, Replace, substitute function

• Auto Format, Paste Special, Data Entry form, Text to Column

• Macro View & Record, Filter & Advance Filter

• Protection of Sheet, Cell, file & Workbook

• Large, Small, Mix & Max, Row & Column Function

• Name Manager: Define Name & Create from Selection

• Comment, Insert, Edit, Show & hide Comments

• Use & Benefit of Table, Smart Art, Shapes

• Fill Option with Series, Justify & Across sheet

• Find & Select, Go & Go to Special

• Page Setup: Margin, Orientation, Head Footer

• Screen Shot & Camera in Excel

• Connection: Links Excel Files

• Custom Formatting with Advance Option

• Short Keys, Explore Hidden & Power Feature of Microsoft Excel 2016

By the conclusion of this advanced Excel training, you will have mastered the advanced features and functions of this software


• To gain a solid understanding of the more powerful features and functions in Excel

• To be able to use Microsoft Excel in a commercial environment

• With the basic advance excel skills, you save a good amount of time and increase your productivity

• Able to create Excel Dash board reporting from Complicated large number of data. Which make you distinguish

• Excel will make you better at your job (No Matter what that is)


• This Advance Excel Training Course having 30 Exercises of most powerful function and feature of Microsoft Excel 2016.

• Participant will practice on almost more than 100 plus professional practical examples in guideline of professional trainer.

• Participant will learn Advance Excel step by step from basic to intermediate to advance level.

• Special One Day workshop Facility: Introduce all exercise to participant, uses and benefit of these exercises and give orientation of this Excel Training 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

Microsoft Excel Training Course - Online MS Excel Basic to Advanced

DHA Phase 4, Karachi, Sindh
6 days ago
Seller description
Muhammad Faisal -Excel Trainer
Member since Oct 2019
** *** ****
Show number

Posted in

DHA Phase 4, Karachi, Sindh
AD ID 1023448860

Report this ad