Home »ADVANCED EXCEL
COURSE : CERTIFIED ADVANCED EXCEL 
Course Overview

This advanced Microsoft Excel training course will teach you to use the advanced features ofExcel in any version to their full extent. By the end of this course, you will be able to reporton data in a list using PivotTables, edit and analyze complex data using advanced featuressuch as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet,work with controls and record macros.
This course will extend your knowledge into some of the more specialized and advancedcapabilities of Excel by automating some common tasks, applying advanced analysis techniquesto more complex data sets, collaborating on worksheets with others, and sharingExcel data with other applications.

Training DurationTotal Training Hours : 20Hours 
Training Duration : 2 Week
Total Training Days : 5 Working Days
Training SchedulesWeekdays (Sunday to Thursday)
Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)
Food & refreshments Included

WeekEnds (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included
Certifications:1) Certificate from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE

OPTIONAL
2) Certificate from American Institute of Professional Studies (AIPS) from USA (After 15 Days of course Completion which will couriered to the attendees office address)
TestsYes
Learning AidsYes
Course MaterialHard & Soft Copies of Study Material
Language of InstructionEnglish
Instructor HelplineYes 
1. Email
2. Social Media (For Emergency requirements)
Registration Requirements1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
Mode of Payment:Cash / Cheque / Credit Card / Bank Transfer.
Eligibility Criteria
(Who should attend this training)
  • Before attending this course, students must have:Excel Intermediate or equivalent experience.
  • Create, edit and format spreadsheets Navigate within worksheets and books
  • Work with absolute references
  • Create Tables within Excel
  • Sort and filter data
Course Benefits
  • Create macros to automate common tasks
  • Use form controls Collaborate with others by merging and tracking workbooks
  • Use advanced techniques to analyse data
  • Create and manipulate PivotTables and PivotCharts
  • Import and export data Create Power Views
  • Learn to use the advanced features of Excel to their full extent.
  • Protect your data from deletions or changes
Course Contents / Outline
  • Getting started
  • Entering and Editing Data
  • Modifying a Worksheet        
  • Formatting              
  • Charts                   
  • Graphics
  • Functions 
  • Common Functions
    • Sum Function
    • Average Function
    • Max Function
    • Min FunctioN
    • Count Function
    • The Counta Function
    • The Countblank Function
  • Time & Date Functions
  • Mathematical Functions
  • Logical Functions
    • If Function
    • And Function
    • Or Function
  • Mathematical Functions
    • Sumif Function
    • Average if function
  • Statistical Functions
    • Count Function
    •  Counta Function
    • Countif Function
    • Countblank Function
    • Rank Function
  • Text Functions
    • Left Function
    • Right Function
    • Mid Function
    • Trim Function
    • Concatenate Function
  • Financial Functions
    • Fv Function
    • Pv Function
    • Npv Function
    • Rate Function
    • Pmt Function
  • Hyperlinks
  • Linking & Embedding 
  • Managing Workbooks and Worksheets     
  • Advanced Formatting              
  • Outlining and Subtotals                        
  • Cell and Range Names                       
  • Data Structure and Tables                 
  • Web and Sharing Features                 
  • Documenting and Auditing                 
  • Application Settings and Templates
  • Advanced Functions and Formulas      
  • Lookups and Data Tables
  • Using lookup functions
  • Creating data tables                        
  • Advanced Data Management
  • Validating cell entries
  • Advanced filtering                      
  • Advanced Charting 
  • Chart formatting options
  • Combination charts
  • Graphical objects                       
  • PivotTables and PivotCharts 
    • Working with PivotTables
    • Modifying PivotTable data
    • Formatting PivotTables 
    • Using PivotCharts
    • PowerPivot                         
  • Exporting and Importing data                        
  • Analytical Tools
  • Goal Seek
  • Scenarios
  • Auditing
  • Macros
  • Passwords & Security Issues
  • Priniting
© Laurels Training Institute 2017. All Rights Reserved.