Loader

TRAINING

Enroll Now microsoft-advance-training

Online Training

Corporate Training

Classroom

MICROSOFT ADVANCED EXCEL – COURSE CONTENT Training

1. Advanced Functions

  1. IF Function & Nested IF Statements
  2. And & Or Functions
  3. Lookup Functions (Horizontal And Vertical Lookup)
  4. Index Function
  5. Array Function
  6. Subtotals
  7. Conditional Formatting

2. Pivot Tables

  1. Create Pivot Table
  2. Work With Row / Column Fields
  3. Data Fields
  4. Customize Table Display

3. Organising Workbooks

  1. Creating Templates
  2. Styles
  3. Protect Ranges & Worksheets

4. Data

  1. Enter & Records Using The Input Form
  2. Sort Data Into Lists
  3. Filter Data – Auto Filter, Advanced Filter
  4. Database Functions
  5. Validation Rules

5. Goal Seeking

  1. Solver
  2. Goal Seeking With Charts
  3. What-If

6. Scenarios

  1. Create Scenarios
  2. Create Summary Report
  3. Merge Scenarios
  4. Protect Scenarios

7. Macros

  1. Create Macros – Record & Modify- the VBA Code Generals
  2. Relative Referencing
  3. Assign To Toolbars / Keyboard

8. Outlines

  1. Group Row / Column Data To Create Outline Levels Based On Worksheet Formulae
  2. Display Summary Rows and Summary Styles

9. Custom Views

  1. Create, Modify
  2. Include Hidden Rows, Columns, Filter Settings

10. Report Manager

  1. Create, Modify
  2. Add Sections
  3. Specify Page Numbering

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services