Advanced Microsoft Excel

Advanced Microsoft Excel 2016 training course is conceptualized to build the skills required to use pivot tables, audit and analyze worksheet data,

Talk to an expert Enquire Now
img

Course Objectives

The purpose of this course is provide students the necessary skills to use Advanced functions of MS Excel in the workplace as an analysis and presentation tool, above and beyond the average skill level of most users thus making the student  more effective in their workplace and also an attractive candidate in the job market.

Course Module

  • Reasons for Using Custom Format
  • Understanding Conditional Formatting
  • Managing the Conditional Format Rules
  • Changing the Conditional Formatting Rules
  • Locating Cells with Conditional Formatting
  • Working with Conditional Formatting

  • Assigning Names to Groups of Cells
  • Managing Named Range
  • Using Names in Formulas

  • Understanding Formulas & Functions
  • Quick Way to Insert a Function
  • Viewing the Formulas (and not the results)
  • How to Delete Values and not Formulas
  • Create a Relative & Absolute Reference
  • Working with Logical Functions
  • Using SUMIF and COUNTIF Functions
  • Working with Text Functions
  • Working with Date and Time Functions
  • Working with Lookup Functions
  • Understanding VLOOKUP Function

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First/Last Column
  • Outline a List of Data
  • Validating Data During Entry
  • Working with Database Functions
  • Using Advanced Filters in Excel 2016
  • Quick Analysis With New Features of Excel 2016

  • Summarizing Data Visually Using Charts
  • Creating a Chart Quickly
  • Changing the Chart Type
  • Customizing Chart Data
  • Show or Hide Chart Gridlines
  • Creating a Pie Chart
  • Saving the Chart as a Template
  • Creating Combination Charts
  • Using The New Pareto Chart Functionality
  • Using Recommended Charts Effectively

  • What is a Pivot Table
  • Anatomy of a Pivot Table
  • How does a Pivot Table Works
  • Create a Basic Pivot Table Report
  • Rearranging a Pivot Table Report
  • Customizing a Pivot Table
  • Changing Summary Calculations
  • Adding and Removing Subtotals
  • Sorting in a Pivot Table
  • Filtering in a Pivot Table
  • Create Report Filter Pages
  • Using Slicers in Pivot Table
  • Working with Pivot Chart

  • Working in a Group Environment
  • Sharing Workbooks in Excel
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Accepting or Rejecting Changes
  • Keeping a Backup of your Changes

  • Linking to Other Workbook
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets

  • Protecting Your Worksheet
  • Protecting Your Formulas
  • Protecting Your Workbook
  • Save Your Workbook with Password
  • Encrypting your Workbook

  • Recording & Testing a Macro
  • Using the Developer Tab
  • Create a Macro
  • Relative and Absolute Recording
  • Testing the Macro
  • Running and Deleting Macros
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • Short Introduction to Macro Programming in
    Excel 2016

Learning Approch

  • Designed with a focus on real world relevance
  • Real-world case studies
  • Hands-on Assignments
  • Individualized Instructor
  • Career Guidance
Program
Dates

Certification (LP Certificate)

Earn a Course Completion Certificate, an official Learners Point credential that confirms that you have successfully completed a course with us.

Certification (KHDA)

Earn a KHDA attested Course Certificate. The Knowledge and Human Development Authority (KHDA) is the educational quality assurance and regulatory authority of the Government of Dubai, United Arab Emirates.

Expert Instructors & Teaching Methods

test
Our Trainer

We, at Learners Point, take immense pride in our teaching methods and instructors. Our instructors are some of the best experts from their fields and employ a practical approach to learning. Many of them are globally recognised and have a diverse set of experience in their field of expertise. You are always sure to have the best in the industry as your teachers who are ready to guide you at every step and make the experience informative yet enjoyable. Apart from the focus on learning your chosen course, our instructors also encourage students to develop communication skills and interpersonal skills necessary to excel in the practical world. 

 

Our Trainer

We, at Learners Point, take immense pride in our teaching methods and instructors. Our instructors are
some of the best experts from their fields and employ a practical approach to learning. Many of them are
globally recognised and have a diverse set of experience in their field of expertise. You are always sure to have the best in the industry as your teachers who are ready to guide you at every step and make the experienceinformative yet enjoyable. Apart from the focus on learning your chosen course,our instructors also encourage students to develop communication skills and interpersonal skills necessary to excel in the practical world. We offer one of the best advanced Microsoft Excel courses in Dubai.

test

Our Trainer

Our Trainer

Learners Experience

img
Sahil Haque :Student at JAMIA HAMDARD

"I would like to say thank you toLearnersPoint. they have given me Great training to learn the Advanced Excel course. This course helps me with my current job. I learned a lot about if Condition, vlookup, pivot table, advance filler using bulk data. It's been very helpful."

img
Bryan Rivera :Laundry Coordinator at JA Resorts & Hotels

"I took advance excel and tally class in Learners Point,. Advance excel's trainer is very patient and the way of explaining very easy. he is an excellent trainer of Tally. He is very knowledgeable and conveys his knowledge of complex material in a manner easily understandable. It's great to find a supportive training centre!! Highly recommended.

img
Sahil Haque :Student at JAMIA HAMDARD

"I would like to say thank you toLearnersPoint. they have given me Great training to learn the Advanced Excel course. This course helps me with my current job. I learned a lot about if Condition, vlookup, pivot table, advance filler using bulk data. It's been very helpful."

img
Bryan Rivera :Laundry Coordinator at JA Resorts & Hotels

"I took advance excel and tally class in Learners Point,. Advance excel's trainer is very patient and the way of explaining very easy. he is an excellent trainer of Tally. He is very knowledgeable and conveys his knowledge of complex material in a manner easily understandable. It's great to find a supportive training centre!! Highly recommended.

Frequently Asked Questions

Our trainings are mostly instructor led and classroom based. However, we also offer high quality live and interactive online sessions.

Our highly skilled faculties from around the globe are experts in their fields and come with decades of diverse industry experience. Our trainers are internationally recognized and locally preferred with rich research driven experience which will ensure highly customizable, engaging and top in the class learning experience.

Choosing LearnersPoint is true value for money as our trainings are right blend of theory and practice and specially developed keeping tomorrow's business needs in mind. All the training sessions are closely monitored through specially designed progress tracker to ensure reinforced and unparalleled learning experience.

Once you have registered for a course and wish to not to proceed with the training for any reason, you are entitled for a refund of the fees provided we are notified in writing within 2 days from the date of initial registration before the training commencement. The refunds are processed within 4 weeks from the day of withdrawal.