Microsoft Advanced Excel – 2010/2013/2016

Current Status

Not Enrolled

Price

$380

Get Started

ENQUIRE NOW

Course Title: Microsoft Advanced Excel – 2010/2013/2016

Methodology: Live Online Instructor-Led

Course Status – Accepting applications

Broad Aims Of This Course

The program is designed for executives and managers who are basic/ intermediate users of Excel and are familiar with the basics of Microsoft Excel. They desire to enrich their excel knowledge with the built-in tools/ features, functions and hidden commands available in the software. This course consists of advanced techniques which includes advanced math functions, LookUp functions, Pivot table, analysing Data in Excel using data table, Goal Seek and Solver, etc.

Click the +/- (accordion) symbol below to display relevant details in collapsible content format

Course Structure

This Microsoft Advance Excel course has a total duration of 20 hours of Virtual Classroom Training:

Level

Total weeks

Hours per week

Days

Timings

Advanced

5

4

Tuesdays and
Thursdays

(or as informed by Careerz4me)

2 days a week

19:00-21:00 UAE time

(or as informed by Careerz4me)

Language of Instruction

The language of instruction for this course is English.
The Teacher is fluent in English, Hindi, Marathi and Malayalam.
The Teacher will communicate with students in English only and all activities including assessments will be conducted in English.

Pre- requisites

Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting, printing, sort and filters.

They need to have a laptop with MS Office 2010 or above installed.

Learning Outcomes

On the completion of the Advance Excel Course, students will be able to do:
Cell Referencing	Types of Referencing Relative Referencing Absolute Referencing Mixed Referencing References to Other Spreadsheets
Working with Functions	Math Functions Sum, AVERAGE, COUNT, MAX, MIN, COUNT, COUNTA, COUNTBLANK Text Functions LEFT, RIGHT, MID, TRIM, LEN, FIND & SEARCH, REPLACE, UPPER/LOWER, CONCATENATE Date & Time Functions DATE, DAY, MONTH, YEAR, TODAY(), NOW() IF and Logical Operators IF, AND, OR, NOT Nested Functions Lookup functions VLOOKUP, HLOOKUP, LOOKUP Advanced Math functions COUNTIF, COUNTIFS, SUMIF, SUMIFS Named Range
Sorting and Filtering	Sorting Understand the use of custom list Create a Custom List Use Custom List for Sorting Filtering Understand why to use Advance Filters Complex Conditions for Filtering Implementing complex and / or conditions across columns
Protecting Sheets	Protecting Workbook Protecting Worksheets
Data Validation	Setting Validation Criteria Creating Lists Handling invalid data
Conditional Formatting	Highlight Cells based on Value Top / Bottom Rules Data Bars / Color Scales / Icon Sets Highlight based on Formulae Creating Rules
Charts	Creating a chart Customizing a chart Chart types Creating Combination charts 3-D charts
Pivot Table	Creating Pivot Table Creating 2-dimensional Pivot Tables Filtering data in Pivot Table Slicer Timeline Pivot Charts
Data Analysing Tools	Goal Seek Data Table Solver
Introducing Macros	Understanding Macros Recording macros

Methodology

Different learning material will be used:

Live Classroom Training
Practice Worksheets

Final Assessment & Certificate

Final assessment will be in the last session of the course.
‘Course Completion Certificate’ will be sent to students within 2 weeks of successful completion of the course.

ENQUIRE NOW

Previous Speak Arabic – Beginner Level Next Cabin Crew General Aviation Course- Beginner to Advanced (Airbus 320 & Boeing 737 Type Training)

Microsoft Advanced Excel – 2010/2013/2016

Broad Aims Of This Course

Quick Links

Contact Us

NewSletter