Skip to content
Facebook-f Twitter Instagram Linkedin-in Youtube
  • +971 4 259 6154
  • info@careerz4me.com
  • Login
  • Register
logoweb1-300x185
  • Home
  • Courses
  • Videos
  • Job Board
  • Blogs
  • Forms
    • Simple CV
    • Webinars
    • Enquire Now
    • DotR
  • Contact Us
Menu
  • Home
  • Courses
  • Videos
  • Job Board
  • Blogs
  • Forms
    • Simple CV
    • Webinars
    • Enquire Now
    • DotR
  • Contact Us
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

Course Structure

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)

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 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)
CAREERZ4ME INTERNATIONAL HR CONSULTANCY
Quick Links
  • Home
  • About Us
  • Courses
  • Services
  • Shop
  • Sectors
  • Job Board
  • Join Us
  • Blogs
  • Contact Us
  • Policies
Contact Us

Phone: +971 4 259 6154

Mobile: +971 58 570 0358

Address:
One by Omniyat, Business Bay,
Dubai, United Arab Emirates

Email: info@careerz4me.com

NewSletter
Sign up now and be informed about our latest courses, jobs and news.
© 2018- 2022 careerz4me
Facebook-f Twitter Instagram Linkedin-in Youtube
WhatsApp Chat
Send WhatsApp
×

Cart