Advanced MS Excel

By attending this course, you will learn how to apply data analysis techniques to improve your operational and project based work. You will be able to review a range of tools and choose the right ones for the particular application and produce analyses and diagrams that make your reports and business cases easier to read and more effective.
Microsoft Excel is one of the most widely used applications in business. It’s the backbone for almost all companies.

New batch is going to starts on 23th-24th, Feb 2018

Course Schedule:

Total 16 Classes

Time: 2 Days
This course covers how to work more efficiently with work books and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data

  • Conditional Formatting
  • Sorting Data
  • Filtering Data
  • Filling Data
  • Pivot Tables
  • Dynamic table (New feature)
  • Charting Techniques
  • Creating Charts
  • Advance Validation
  • Text options
  • Macros
  • File / Data Security
  • Formulas
  • Formula Referencing
  • Logical Functions
  • Lookup Functions
  • Use the fill operations available to fill a data series
  • Understand and use formula cell referencing to createmore complex formulas
  • Use a range of logical functions
  • Apply conditional formatting to ranges in a worksheet
  • Create and use labels in a workbook
  • Work with various elements of a worksheet
  • Use a range of techniques to work with worksheets
  • Use a range of find and replace techniques
  • Apply a variety of page setup techniques
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Create effective charts in Microsoft Excel
  • Use a range of techniques to enhance charts
  • Apply formatting techniques to text on charts

    MICROSOFT Certified Trainer
    +27 years of experience in the field of
    IT Training and Project Management.
    Has trained more than 5000+ employees from Executive to Senior Management in different companies across UAE, Qatar, Egypt and Saudi Arabia

    Request Callback
    Call me!