excel trotters

+254 738 00 22 22

 excel trotters

training@exceltrotters.com

Duration: 2Days

Charges: $365.00

This is a two days Advanced MS Excel Training Course. The course is provided in-house. ExcelTrotters will provide a trainer and training material while the client will provide venue and meals for the delegates. This training require a minimum of 4 delegates.

The training covers the following areas and more -

  • Data management - sorting, filtering and shortcuts.
  • Data analysis - use of tables, pivot tables etc.
  • Advanced formulas for summation and analysis.
  • Data presentation using graphs and charts.
  • Reporting dashboards.

Course Outline

Day 1

  • Introduction to excel
    • Copying, Moving & Deleting
    • Selection Techniques
    • Ribbon Customization
    • Data validation
    • Useful shortcuts
  • Formatting
    • Alignment Formatting
    • Number Formatting
    • Data split through Flashfill
    • Text into columns
  • Conditional Formatting
    • Use & design
    • Reporting
    • Formulas
  • Tables
    • Formula Nomenclature - structured/ Unstructured references
    • Table design
    • Advantages of Tables
  • Pivot Tables
    • Creation & design
    • Data Source Management
    • Data Grouping - ranges
    • Cloning
    • Dynamic Ranges
    • Pivot Formatting
    • Reporting – count, %, unique values etc.
    • Calculated fields etc.

Day 2

  • Charts
    • Chart Types
    • Resizing a chart
    • Deleting a chart
    • Chart title or labels
    • Chart background color
  • Advanced Formulas for data analysis
  • Functions & Formulas
    • Creating formulas
    • Easy way to create formulas
    • Copying formulas
    • Operators
    • Formula error messages
  • Working with Dates & Time
    • Addition
    • Subtraction
  • Dashboards
  • Slicers
  • Data Analysis
    • Goal Seek

 Training Requirements

  • Microsoft Excel 2016 Professional Pro
  • Windows based Laptop – Minimum RAM (2GB)
  • Minimum 1GHz clock speed
  • Internet connection
  • Screen Resolution 1280x800

 Training Methodology

  • Every delegate will be required to have a laptop with Microsoft 2016 professional pro (Activated) installed. There are some training aspects not available in Excel 2010 and the lower versions.
  • The training is practical and everyone shall be expected to practically participate.
  • Soft and hard copy training materials shall be provided.

 Feedback & Who Should Attend

  • All persons using Excel spreadsheets
  • All persons involved in the construction and use of financial models, including budgets, projections, evaluations, cash flows, projects, etc.
  • Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an exercise will be discussed prior to tackling the exercise).

Contact info

excel trottersExcelTrotters Limited

excel trottersNairobi,Kenya

excel trottersMobile : +254 782 00 22 22

excel trottersPhone : +254 782 00 22 22

excel trottersEmail : training@exceltrotters.com