Ace it Training Advanced Excel Ace it Training

Introduction 

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

Crash

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 
  • SUMIF, AVERAGEIF, COUNTIF & INDIRECT Functions  
  • SUMIFS, AVERAGEIFS & COUNTIFS & OFFSET Functions 

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 
    Macros

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

    Career path / Jobs and salary

    This course was designed for the intermediate student wants to gain advanced skills to work in a business environment or for personal use. This course goes in-depth to teach advanced techniques to broaden all students' knowledge.

    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

    Enquire about this course

    You may add more courses here,
    your list will be saved.

    Rate our content