excel trotters

+254 738 00 22 22

 excel trotters

training@exceltrotters.com

Duration: 2Days

Charges: $440.00

This course will enable you to inspect, clean, transform, and model data with the goal of discovering useful information, suggesting conclusions, and supporting decision

  • Get to grips with using Excel in you Sales and Marketing departments.
  • Compare price lists to historical or competitive sources on a product by product basis
  • Include % movement calculations comparing to budget and last year in you sales data
  • Establish what increase in volume will justify what level of price decrease;
  • Highlight your average and below average products or sales people with a click of a button; and
  • Easily look up client’s information from different databases to remove duplicate content.

Course Outline

Day 1

  • How errors happen in models and how to avoid them
  • Essential Excel Knowledge
  • Following formulas
  • IF function
  • Absolute and Relative referencing ($ signs)
  • Short Cuts, Tips and Tricks
  • Importing data into a model
  • Data Cleanup using the Data Autofilter, Advanced Filter and Duplicate remover
  • GOTO Special tool for working with cells
  • Using the text to column tool
  • Working with imported text data
  • CLEAN, CONCATENATE, DOLLAR, EXACT, FIND/SEARCH, LEFT/RIGHT/MID, LEN, LOWER/UPPER/ PROPER, REPLACE, T, TEXT, TRIM, VALUE
  • Handling Dates in your models
  •         EOMONTH, DATE, DATEVALUE, DAY, EDATE, MONTH, NETWORKING DAYS, WEEKDAY, WORKDAY, YEAR

Day 2

  • Manipulating the data
    • SUMIF, COUNTIF, SUMIFS, COUNTIFS, VLOOKUP
  • High level overview of what can be done with Pivot Tables
  • Reporting results
    • Linking spreadsheets to Word and Powerpoint
    • Conditional Formatting
    • Sparklines
    • High Level Graphing

 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