Loading Events

« All Events

  • This event has passed.

Advanced Excel

February 23 @ 9:00 am - February 24 @ 5:00 pm

Event Navigation

Excel Advance final

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks. Students should have already completed Excel 2010 Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.

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


    February 23 @ 9:00 am
    February 24 @ 5:00 pm
    Request Callback
    Call me!