Date of Training

Jan 16 & 17 - Dubai

Get the Brochure


Pricing Structure

Platinum Package send 3 & aboved elegates
20% Discount per person


Gold Package send 2 delegates
10% Discount per person


Request Information

Advanced MS Excel Training in Dubai and Abu Dhabi

with Microsoft Certified Trainer

Lynchpin is the leader in providing Excel Training in Dubai & Abu Dhabi. Our expert Microsoft Certified Trainers deliver both public Excel Training Programs as well as in-house Excel Training Programs in Dubai, Abu Dhabi and across UAE.

Excel Training in Dubai (Upcoming Training Dates)
Tue & Wed 16 & 17 Jan, 2017 – Dubai
Click here to register for the upcoming Advanced Excel Training in Dubai

Looking for Excel Training in Dubai and Abu Dhabi? Its time to save your time and gain control over your financial, accounting, auditing, presentations and day to day data calculations, sorting, and storing work, by one of the most intelligent software application Microsoft Excel.

  • Discover methods to dramatically reduce the time you spend on spread sheets

  • Develop practical solutions to your business problems through superior spread sheet design

  • Upgrade your spreadsheet skills with advanced data management techniques

  • Use macros more efficiently

  • Consolidate worksheets from different sources into one workbook

  • Develop efficient techniques for using charts

 Take Aways

  1. Use spreadsheet skills for advanced financial applications

  2. Create, format and trouble shoot pivot tables

  3. Analyze data accurately using pivot tables and slicers

  4. Adopt logical methods to solve complex problems by
    analyzing data accurately using pivot tables

  5. Efficient working with related worksheets and workbooks by benefitting from new reporting and presentation techniques

Course Outline

Day One

Excel Overview

Conditional Formatting & Sparklines

  • Formatting data on Conditions
  • Highlight Duplicate & Unique Values
  • Finding top 5 / 10 items in the Data
  • Formatting data using Data Bars & Icons
  • Clearing & Managing Rules
  • Nested loops
  • Analyzing only total rows
  • Summarizing a data based on single attribute
  • Adding data based on two attributes

Summarizing & Consolidating Data

  • Creating Sub Totals
  • Sorting data with Multiple Level Sorts
  • Advance Filtering on more than 1 criteria
  • Extracting Unique Values with filtering
  • Tips of copying Filtered data to New File

Pivot Tables & Slicer

  • Creating Pivot table & analyzing data
  • Refreshing & Changing Pivot Table Range
  • Creating sheets from Pivot table
  • Calculations & Creating Dynamic Pivot
  • Table creation & text to column
  • Defining Name & work with tables
  • Creating Virtual Fields
  • Creating more than one Pivot table on one sheet
  • Changing Source
  • Slicer

Lookups and Data Table

  • Picking data based on row criteria
  • Analyzing data based on column criteria
  • Match and indexing
  • Data Tables single variable
  • Data Tables more than one variable
  • Data Entry Forms
  • Excel speech on data entry
  • Creating Grade sheet/Result sheet for performance Creating data list in excel
  • Slicer

Day Two

Charts & Validation

  • Creating Column, Line & Pie Charts
  • Shortcuts of Creating Charts
  • Changing Chart type
  • Adding Target Line in chart
  • Method of pasting chart into PowerPoint
  • Creating two axis chart & advance charting
  • Creating Drop Downs in cell
  • Sharing Workbook
  • Inserting object
  • Hyperlinking

Data Mining

  • Auditing spread sheet
  • Using Attendance data to calculate payroll
  • Identifying source cells
  • Changing source data year on year
  • Tracing dependent cell
  • Rearranging the data in required sequence
  • Quick summary of data

Macros

  • Record macros for automating tasks
  • Creating Button to run a Macro
  • Macro with Keyboard & its benefit
  • Run / Delete a macro

Data Security in MS Excel

  • File Level Security
  • Sheet Level Security
  • Making the worksheets invisible
  • Preventing Sheets from Deletion Cell / Row / Column Level Security
  • Limiting access to cell

Formulas

  • Statistical: Count, CountA, CountIF, CountIFs, & CountBlank
  • Trim & Conatenate, Sum, SumIF & SumIFs
  • Change Case: Upper, Lower & Proper
  • Logical: If Condition with Multiple IF’s, Using
  • AND & OR in IF Condition
  • Lookup: Advance & Multiple Vlookup & Hlookup

 Course Director

Ramzan Rajani

Microsoft Certified Trainer Microsoft Office Specialist & ITIL Foundation

Mr. Ramzan Rajani Carries more than 8 years of experience in the field of IT Training & Project Management. Afer getting a Diploma in Information Technology he did his MBA with Dual specialization in IT Project Management. He has experience of designing, manag- ing & implementing large databases bearing Very good understanding and extensive expe- rience in Advance Excel, VBA – Macros, advance PowerPoint, Excel Dashboard, Access & MSP (Microsoft Project 2010). Along with other companies around the world he has done train- ings for the following companies in Dubai : Manipal University, Etisalat , IFC (World Bank Group), Emirated NBD (Largest UAE Local Bank), Sharjah Islamic Bank, RedBull , CareStream Health , Rotana, Funcity, Johnson & Johnson, Mastercard, Internet City, Dulsco, AstraZeneca (Pharma) , MAF (Majid al Futtaim Properties).

Microsoft Certified Trainer
Microsoft Office Specialist


 

Participants Feedback

 
 

Our Prestigious Clients

 

Upcoming Trainings !