Microsoft Excel Advance Eminent Educational Institute

Price: AED 1,000

Duration: 2 Days
Call: +971 4 5490356

Course details

Have some experience with Excel and want to improve your skills? This course will help you learn Intermediate and Advanced Excel techniques. Whether you use Excel for work or study, this training will help you on your journey to becoming an Excel Expert!

This workshop is highly interactive, as participants will be challenged to step out of their comfort zones and demonstrate the techniques practically. You will learn how to find a value with VLOOKUP, create and format Pivot Tables, record Macros and more. Designed and delivered by internationally qualified and experienced trainer, the workshop can be tailored in alignment with your business objectives.

Course Content:

Conditional Formatting

Formatting Cells Containing Values
Clearing Conditional Formatting
Working with Data Bars, Colour Scales and Icon Sets
Creating and editing Sparklines

Sorting Data

Performing An Alphabetical Sort
Performing A Numerical Sort
Sorting On More Than One Column
Sorting By Vertically & Horizontally

Filtering Data

Understanding Filtering
Applying, Using and Clearing A Filter
Creating Compound Filters
Creating Multiple Value and Custom Filters
Using Wildcards

Filling Data

Understanding Filling
Filling A Series
Creating, Modifying and Deleting A Custom Fill List

Charting Techniques

Adding Chart and Axes Titles
Positioning The Legend
Show Data Labels and Data Table
Modifying The Axes
Creating a combination chart
Creating 2 Axis chart

Creating Charts

Choosing The Chart Type
Creating A New Chart
Working With An Embedded Chart
Resizing and changing Chart type

Advance Validation

Creating drop down in cells
Restricting values from list only
Creating error messages
Creating dependent lists

Text Options

Text to Column, SubTotal and Paste Special
Group / Ungroup
Sharing workbook

Pivot Tables

Understanding Pivot Tables
Creating A PivotTable Shell
Filtering A PivotTable Report
Clearing A Report Filter
Formatting A PivotTable Report
Understanding and Creating Slicers

Dynamic Table

Converting data into table
Automation calculation in table
Converting table to normal range
Using table in Charts & Vlookup

Logical Functions

Understanding Logical Functions
Using IF To Display Text
Using IF To Calculate Values
Nesting IF Functions
Using IFERROR, AND and OR Functions

Formula Referencing

Absolute and Relative Referencing
Problems with Relative Formulas
Creating Absolute References

Macros

Recording & Running Macros
Creating button to run the macro
Assigning shortcut to macro
Deleting Macros
Relative reference in Macros

Formulas

Count, CountA, CountIF & CountBlank
Sum, SumIF & SumIFs
Networkdays
Today, Now, Trim and Concatenate functions

Lookup Functions

Normal Vlookup & Hlookup
Vlookup with IFError
Vlookup from Multiple Sheets using IFERROR
Using IF Condition and Multiple criteria in Vlookup

File / Data Security

Open & Modify file password
Protect sheet from deletion, data copy or protect few cells, rows or columns

Updated on 03 March, 2020

Job roles this course is suitable for:

Office Manager , Project Manager , Business Professional , Administrative Assistant , Anyone who generates report , Anyone who analyzes data , Accounting and Finance professional

Course Location

Show map Location Business Bay - Dubai

About Eminent Educational Institute

Eminent offers a range of courses that will enhance your skills, improving efficiency and productivity.

Successful people invest in themselves and Eminent has been assisting individuals for the last 25 years in the process by offering an extensive range of courses, at affordable prices.

Our courses are delivered by subject matter experts with both training as well as industry experience. They are not only professional, but also considerate and sensitive towards varying individual needs and provide the necessary support to every participant during the learning process.

Take a look at what we have to offer and feel free to call us for more information and guidance on how we can help you advance your skills and thereby your career. See all Eminent Educational Institute courses

Ask Laimoon

View more similar courses

See all current Accounting jobs in UAE

Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.