Microsoft Excel Advanced iTraining Expert
Price: AED 1,755
  • Location: Kuala Lumpur
  • Duration: 2 Days

    Course details

    2 days Course Outline
    Module 1: Advanced functions and formulas
    • Logical functions
    • Conditional functions
    • Financial functions
    • Text functions
    • Date and time functions
    • Array formulas
    • Calculation options
     
    Module 2: Lookups and data tables
    • Using lookup functions
    • Creating data tables
     
    Module 3: Advanced data management
    • Validating cell entries
    • Advanced filtering
     
    Module 4: Advanced charting
    • Chart formatting options
    • Combination charts
    • Graphical objects
     
    Module 5: Pivot Tables and Pivot Charts
    • Working with PivotTables
    • Modifying Pivot Table data
    • Formatting PivotTables
    • Using Pivot Charts
    • PowerPivot
     
    Module 6: Streamling Workflow: Macros
    • Create a Macro
    • Edit a Macro
    • Apply Conditional Formatting
    • Add Data Validation Criteria
    • Update a Workbook's Properties
    • Modify Excel's Default Settings
     
    Module 7: Collaborating with Others
    • Protect Files
    • Share a Workbook
    • Set Revision Tracking
    • Review Tracked Revisions
    • Merge Workbooks
     
    Module 8: Auditing Worksheets
    • Trace Cells
    • Troubleshoot Errors in Formulas
    • Troubleshoot Invalid Data and Formulas
    • Watch and Evaluate Formulas
    • Create a Data List Outline
     
    Module 9: Analyzing Data
    • Create a Trendline
    • Create Scenarios
    • Perform What-If Analysis
    • Perform Statistical Analysis with the Analysis ToolPak
    • Create Sparklines
     
    Module 10: Working with Multiple Workbooks
    • Consolidate Data
    • Link Cells in Different Workbooks
    • Edit Links  
     
    Module 11: Importing and Exporting Data
    • Export Excel Data
    • Import a Delimited Text File Updated on 11 May, 2020

    Job roles this course is suitable for:

    Executive Assistant , Finance Officer , Data bank support

    About iTraining Expert

    is the corporate training events arm of ITE INTERNATIONAL LTD with extensive training experience from both the government and corporate sector covering Malaysia, Singapore, Australia, China, Vietnam and Indonesia. We've been running the training business since 1999.

    We've been running the human development and corporate training business since 1999. This year, we celebrate our 16th years in contributing to the advancement of Human Capital, Skills and Knowledge to enable Productivity, Efficiency and Effectiveness at Work and in Life. 

    Our Services:

    • Corporate In house Training  and Public Program Training  - world wide
    • Conference & Seminars
    • Management & Leadership Development
    • Coaching and Assessments
    See all iTraining Expert courses
    Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or