Advanced Excel Ace it Training
Price: AED 1,200

Course details


  • History and Introduction of spreadsheets 
  • Prevent data loss in the Event of System 


Didn't Save a Workbook? Don't Worry- Save a Workbook 

Basic Formula & Function

  • Advanced Excel Functions 
  • Applying Relative, Absolute & Mixed Referencing 
  • Defining Names & Using them in Functions 

Formatting Techniques

  • Advanced Formatting Tools 
  • Customized Number Formatting 
  • Working with Pictures, Objects and Smart Art 

Dates & Times

  • The Science of Dates in Excel & Date Functions 
  • Working of Time in Excel and Useful Time  Functions 
  • Prepare Daily and Monthly Schedules 

Efficient Handling of Data

  • Quick Data Selection Techniques 
  • Quick Data Entry Techniques 
  • Use of Special Paste 
  • Accelerating Copy Paste 
  • Managing a Large Quantity of Data 
  • Excel Advanced New Feature: 
  • Flash Fill & Quick Analysis 
  • Summarizing Data with Sorting and filtering 
  • Advanced Use of Find & Replace 

Analyzing Data with Conditional Formatting

  • Highlighting Values based on Criteria 
  • Applying & Managing Formatting Rules 
  • Using the Data Bars, Icon Sets & Color Scales 

Charts & Graphs

  • Creating a Chart in no Time! 
  • Most Commonly Used Charts 
  • DO's & Don'ts of Excel Chart Formatting 
  • Charts Formatting 
  • Advanced Charting Techniques 

Working with Tables

  • Exploring the Power of Excel Tables 
  • Creating Dynamic Ranges with Tables 

IF Function with AND & OR

  • Applying the Powerful IF Function 
  • Simple IF & Nested IF Function AND Function Combined with IF Function  OR Function Combined with IF Function 

Lookup Functions

  • VLOOKUP and HLOOKUP & its Limitations 
  • Alternate to VLOOKUP: Combining Index- match 

Pivot Tables

  • A Powerful Reporting Tool 
  • Analyzing Data with Pivot Tables 
  • Walking Through Report Builder Layout 
  • Managing & Presenting Pivot Tables Data 
  • Working with Pivot Charts 
  •    Excel Advanced New Feature: Slicers & Timeline 

Data Validation

  • Creating Drop down List 
  • Regulating and Managing the Entry of Data 
  • Custom Input Message and Error Alert 

What-If Analysis

    • Using the Brilliant Goal-Seek Feature 
    • Use of Data Tables to Display Probable Results 
    • Using Scenario Manager to Summarize Results 
    Auditing Spreadsheet

    • Identifying the Source Cell 
    • Tracking changes made to Data 

    Managing Worksheets

    • Consolidating Data 
    • Lining Worksheets & Workbooks 
    • Calculating Across Worksheets with "3-D Formula" 
    • Creating a Hyperlink 

    Printing & Security

    • Walking Through Advanced Printing 
    • Techniques 
    • Restricting Editing in Data 

    • What is a Macro? 
    • Recording & Running/Executing a Macro 
    • Assigning Macros to Objects 
    • Adding Interactive Form Controls to Worksheet

    Updated on 06 December, 2017

    About Ace it Training

    Ace it Training, Dubai, is a leader in providing IELTS Training,Certified Supply Chain and Logistics Professional,Certified Human Resource and Competency Professional,  and Spoken English Training. 

    Our goal is to continuously improve organizational skills in facilitating an efficient training environment by implementing well-thought-out strategies in the areas of management education. Ace it Training offers a range of highly regarded executive and corporate development programmes, including courses specially tailored for our corporate clients. Our courses range from basic Computer Applications to Logistics, Supply Chain Management, Customer Service, Marketing Skills, Accounting, Secretarial Skills, Languages and IELTS test preparations.

    See all Ace it Training courses
    Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?