Advance Excel Training Dubai | Advanced Microsoft Excel Training in Dubai & Abu Dhabi | Online Excel Test - Simfotix
 
×
  • One Day Training Workshop
    one day vat training
  • Two Day Traning Workshop
    Two Day VAT Training

Advanced Microsoft Excel



23 April 2018

Dubai



USD 490

per participant

MS Excel Training in Dubai and Abu Dhabi give your hands on practice to optimize your daily work and present meaningful data. Intermediate MS Excel Training and advance excel training are the flagship courses Simfotix is offering in UAE including Dubai, Abu Dhabi, and entire GCC region actively in Oman and KSA.

Simfotix Master Trainer will help you understand how to work simultaneously on a spreadsheet, how to analyze data by using Vlookup and nested Vlookup functions. Also, the advance Excel training being offered in Dubai and Abu Dhabi offers you to learn how to make amazing use of Graphs, pivot table and power pivot tables.

In this Intermediate and advanced excel training abu dhabi, we also focus on designing formulas to manipulate, summarize and refine raw data, Troubleshooting and tracing formula errors.

Videos for Intermediate and Advance MS Excel Training: We also provide videos made by certified MS Excel Trainers which you can use for future reference. These videos will be given to all participants as a gift and they cover all levels of MS Excel Training.

Simfotix also provides One to One Excel Training in which participants can share their specific problems and get immediate solutions.
In-house Advance MS Excel Training is the most demanding session in which cost is less and quality is high due to customization of modules.
Advance Microsoft Excel course will also help to make Charts and Pivot Tables and then to connect them to the power point. You can link data from a saved Excel spreadsheet or copy cells from an Excel spreadsheet into your Microsoft PowerPoint presentation.
Simfotix has developed online excel test for the MS Excel which can be used to check the skill level for your team and allocate them for intermediate MS Excel and Advance MS Excel and Dashboard Reporting courses in Dubai.
Online Test for MS Excel Training : http://www.simfotix.com/ExcelQuiz/
Overview
Microsoft Excel has always been a top recommended application for business users for making simple to complex calculations, data presentation, analysis and on top work efficiently and productively. We have seem business user going home late just because they don’t know the right use of this useful program, you may work with little knowledge but true value comes when you work efficiently with maximum use of formulas, features and tricks in this wonderful application. Get ready 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 available in market.
Course Outline
Excel Ice Breaking Session !
  • Brief ice breaking session to bring all participants on the same learning pace
  • Be Ready for quick questions and to learn daily use short cuts
  • Utilizing fill handle tricks
  • Formatting and editing a series
  • Using multiple worksheets and workbooks
  • Using special number formats – Custom Formatting
  • Using functions to format text
Formatting Your Spreadsheets
  • Freezing row and column titles
  • Using auto format
  • Custom number formats
  • Conditional formatting
  • Using Paste Special
  • Why use paste special?
  • Pasting different types of information
  • The operations area
  • Special options
Summarizing & Consolidating Data
  • Working with Data Tables & its practical usage
  • Using Paste Special (In depth)
  • Splitting forename & surname in different columns with formulas
  • Advanced Subtotals
  • Formatting the Subtotal Rows
  • Quick Analysis
  • Adding and Copying with Subtotals
  • Consolidating Data
  • SUMIF & SUMIFS
  • Using Array Formulas
  • Looking at AutoSum Tricks
  • Utilizing Fill Handle Tricks
List Management
  • 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
Filter, Sorting & Conditional Formatting
  • Creating Sub Totals
  • Sorting data with Multiple Level Sorts
  • Advance Filtering on more than 1 Criteria
  • Extracting Unique Values with Filtering
  • Sorting Data ( By Values, By Cell Color, By Font Color , By Cell Icon )
  • Multi column Sort
  • Filter ( By Values, By Cell Color, By Font Color , By Cell Icon )
  • Format As a table
Charts/Graphs & Techniques
  • Recommended Charts
  • Trend lines
  • Sparkline’s charts
  • Saving Custom Chart as Template
  • Formatting and Editing a series
Advanced Validation
  • Controlling The Limits Of Numeric Data
  • Dropdown List
  • Date Controls
  • Text Length Control
  • Specialized Custom Formula Control
  • Custom Formula
Advanced Validation
  • Controlling The Limits Of Numeric Data
  • Dropdown List
  • Date Controls
  • Text Length Control
  • Specialized Custom Formula Control
  • Custom Formula
Advanced Formula & Powerful Functions
  • Auditing Formulas
  • Shrinking the Formula Bar
  • Understanding Errors
  • Using Custom Formatting Codes
  • Pasting Values
  • Using Paste Special
  • Using Date Functions
  • Using Bizarre Date Functions
Advanced Lookup Function
  • Advanced VLOOKUP Function
  • Index Match and Various Techniques
  • Transpose
  • Using the Offset Function
  • Indirect
  • Flash Fill
  • Remove Duplicates
Summarizing Data Using Pivot Tables
  • Creating Pivot table & Analyzing data
  • Doing calculation & making pivot dynamic
  • Calculating variances with pivot
  • Grouping data in pivot tables
  • Formatting a pivot table
  • Selecting elements of a pivot table
  • Using grand totals and subtotals
  • Changing a pivot table’s calculations
Macros
  • Recording Macros for Automating tasks
  • Creating Button to run a Macro
  • Macro with Keyboard & its benefit
  • Deleting Macro
  • Editing macros code
  • Creating global macros
Security in Excel
  • Preventing Sheet from Deletion
  • Cell / Row / Column Level Security
  • Preventing your data from Copying
  • Preventing data selection
What will you get
  • Quality training is delivered by Microsoft Certified Trainer from the industry.
  • Participants get the easy to read and understand exercises specially designed for this course to take back for practice and future reference.
  • All formulas and functions from these files could be directly used at workplace.
  • Ability to ask questions on the spot and maximize your learning.
  • Solve your real time work problems and learn from one of the best GCC Trainer
Hands–On Training
Throughout this course, exercises provide you with experience applying Excel features, formulas and formatting. Hands-on exercises include:

  • Navigating the Excel interface for efficiency and speed
  • Formatting existing data for greater visual impact
  • Designing formulas to manipulate, summarize and refine raw data
  • Troubleshooting and tracing formula errors
  • Charting your data for clearer presentation
  • Linking worksheets with references
Course Facilitator
Ramzan Rajani
Microsoft Certified Trainer
Microsoft Office Specialist
ITIL FoundationMr. Ramzan Rajani carries more than 8 years of experience in the field of IT Training & Project Management. After getting a Diploma in Information Technology, he did his MBA with Dual specialization in IT and Project Management. He has experience of designing, managing & implementing large databases bearing very good understanding and extensive experience in Advance Excel, VBA – Macros, advance PowerPoint, Excel Dashboard, Access & MSP (Microsoft Project 2010). Many participants from large number of companies in GCC region have attended his programs as public and inhouse sessions. Some of these companies include: The Executive Council of Dubai, Ferrari World, General Civil Aviation Authority, Etisalat, National Bank of Fujairah, Roche Diagnostics, Abu Dhabi Finance, Thuraya, DEWA, Emirates Post, Dubai World, Majid Al Futtaim Group, RAK Cement, Tamkeen, Tawam Hospital, Imdaad Group, Wild Wadi, Al Etihad Credit Bureau, IFC (WorldBank Group), Emirates NBD, Sharjah Islamic Bank, RedBull, CareStream Health, Rotana, Funcity, Johnson & Johnson, Mastercard, Internet City, Manipal University , Dulsco, AstraZeneca (Pharma)…etc.

Gallery

Testimonials