excel trotters

+254 738 00 22 22

 excel trotters

training@exceltrotters.com

Duration: 5Days

Charges: $1,100.00

This is a classroom training. This intensive course covers widely the following areas -

  • Data Management - organizing data into the right format.
  • Data Analysis - discovering useful information from the data.
  • Data Presentation - communicate information through graphical tools.

This training is offered Nairobi Kenya, Addis Ababa Ethiopia, Kampala Uganda, Kigali Rwanda, Dar Es Salaam Tanzania and Juba South Sudan.

Course Outline

Day 1

  • Setting up a worksheet
  • Printing - headers in page layout view
  • Views
  • Ribbon Layouts
  • Setting active cell direction of movement 
  • Setting number of available Recent Documents 
  • One click access to frequently used Workbooks or Folders
  • Customizing the Quick Access Toolbar
  • Customizing the Ribbon
  • Removing labels on icons after customizing the ribbon
  • Copying
  • Transposing
  • Number Formats
  • Transposing
  • Moving and inserting rows and columns
  • Splitting data - text to columns, flash fill
  • Joining data
  • Change cases
  • Replacing data
  • Removing trailing spaces
  • TEXT Function

Day 2

  • Cell Referencing
    • Absolute
    • Relative
    • Mixed
  • Formulas
    • MID/LEFT/RIGHT/FIND/TRIM
    • MAX/MIN
    • RAND/RANDBETWEEN
    • AVERAGE/IF
    • COUNT/COUNTA/COUNTBLANKS
    • COUNTA
    • TEXT/VALUE
    • DATEDIF
    • PROPER/LOWER/UPPER
    • CONCATENATE
    • SUM
    • NOT
    • IFERROR/IFNA
    • OR/AND/XOR
    • NOW/TODAY
    • IFS - SUM, AVERAGE, COUNT
    • HLOOKUP/VLOOKUP/LOOKUP
    • INDEX/MATCH
    • CHOOSE
    • SUBSTITUTE

Day 3

    • Excel Inbuilt comparative operators
      • Highlighting Cells
      • Top/Bottom Rules
      • Databars
      • Color Scales
      • Icon Sets
    • Logical conditional formatting
      • Highlight single cell
      • Highlight single cell using a different cell as criteria
      • Highlight the entire row
      • Highlight Cells based on a OR Function/MATCH Function
      • Highlight Cells based on AND Function
      • Colored Rows
      • Conditional Input
      • Clustering
      • Intersection
      • Gantt Chart
      • Handling Duplicates

Day 4

    • Tables
      • Convert Normal range into a Table
      • Renaming an Active Table
      • Resize Table
      • Renaming Multiple Tables
      • Removing Duplicates
      • Selecting data from a list
      • Filtering
      • Inserting Rows and Columns
      • Quick Analysis
      • Inserting Totals
      • Banded Rows or Columns
      • Dynamic charts-working with charts from table data
      • Converting a table to a normal range
      • Slicers
    • Pivot Tables
      • Summarize with a pivot table
      • Table Formulas
      • Goal Seek
      • Data Table
      • Creating a PivotTable
      • Group PivotTable Data
      • Make the data source dynamic
      • Frequency Distribution with COUNT
      • Creating Pivot Charts
      • Renaming field names in a PivotTable
      • Creating Pivot Table Slicers
      • Using Pivot Table Slicers
      • Refreshing PivotTable Data Source
      • Adding a Calculated Field
      • Modifying or deleting a calculated field
      • Formatting PivotTables
      • Managing PivotTable field lists and buttons
      • Selecting and Clearing a PivotTable
      • Maintaining PivotTable Layouts and Formats
      • Slicers

Day 5

  • Date Function
    • Using Date and Time functions
    • Understanding Time
    • Adding Time
    • Subtracting Time
    • Rounding, Subtracting or Adding Time
    • Dividing Time
    • Multiplying Time
    • Computing days with Dates and Time Functions
    • Splitting Dates using Text to Column method
    • Splitting Dates using Functions
    • Number-Text Entry and Conversion Issues
    • Converting number entered as text to values
    • Using the TEXT function to format data

 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