excel trotters

+254 738 00 22 22

 excel trotters

training@exceltrotters.com

 

Duration: 0.5Days

Charges: $150.00

This is a half day classroom training.

You will learn on how to present information through the various types of Excel charts and graphs.

This training is offered Nairobi Kenya.

Course Outline

  • Getting the Data right for Graphing
  • Understanding Excel graphs and incorporating them into your model
  • Adding another series to a graph
  • Creating a secondary axis in a chart
  • Changing default colouring to match corporate colours
  • Create a chart template for consistent use
  • Different Chart Types
    • Column Charts
    • Bar Charts
    • Pie Charts
    • Area Charts
    • Radar
    • Waterfall graphs
    • Combination Charts
  • Trendlines in models
  • Conditional Formatting Graphs
  • Creating flexible graphs
  • Slicers and Timelines

 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