Home » Course » Microsoft Advanced Excel – 2010/2013/2016

Microsoft Advanced Excel – 2010/2013/2016

ENQUIRE NOW
ENQUIRE NOW
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

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

LevelTotal weeksHours per weekDaysTimings
Advanced54

Tuesdays and
Thursdays

(or as informed by Careerz4me)

2 days a week

19:00-21:00 UAE time

(or as informed by Careerz4me)

  • 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.

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.

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

Different learning material will be used:

  • Live Classroom Training

  • Practice Worksheets

  • 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 ABOUT THIS COURSE
Buy Now
ENQUIRE NOW
ENQUIRE NOW
Previous Speak Arabic – Beginner Level Next Cabin Crew General Aviation Course- Beginner to Advanced (Airbus 320 & Boeing 737 Type Training)