Training Course on Microsoft Excel Skills for Business Analysis and Reporting

Microsoft Excel has powerful business analysis capabilities and dynamic reporting features that provide managers and business owners with the information and insights instantly. This course will equip the participants with skills for analyzing and retrieving data from Excel, deal with budgets, P&L, sales or other administrative data and need to display the information using interactive Excel charts and reports. Participants will also be equipped with methods of using data for important business decision-making and planning.
5 days
By the end of this course, participants will be able to know:
• Gain enhanced spreadsheets data skills: creating templates, charts, graphics and formulas for business and operational work.
• How to calculate with advanced functions & formulas, create interactive charts using Excel
• How to analyze data using Pivot Charts. insert graphic objects and quickly transform business data into informative reports using PivotTables
• How to use business dashboards to compare multiple business elements in one screen
• How to generate management and weekly reports quickly and accurately
Module 1
Introduction to Microsoft Excel

  1. Introduction, Outline & Objectives
  2. Functions and Formulae
  3. Entering and Copying Formulae
  4. Creating Formulas using Names
  5. Managing Names using, Name Manager
  6. Searching for Functions
  7. Naming Ranges
  8. Creating Named Ranges
  9. Using Names in Movement
  10. Inserting Names in Formulae
  11. Formatting
  12. Number Formatting
  13. Cell Styles
  14. Copying and Clearing formatting
    Module 2
    Calculating with Formulas and Functions
  15. Use Date and Time Functions
  16. Use Statistical Functions
  17. Use Database Functions
  18. Use Lookup Functions
  19. Use Logical Functions
    Module 3
    Visualizing Data with Charts
  20. Use Recommended Charts Tool
  21. Create Chart with Quick Analysis
  22. Align Chart Axis Labels
  23. Display Value Axis in Millions
  24. Create Chart with Multi Line Labels
  25. Create Combo Chart
  26. Create Chart Template for Sharing
  27. Build Dynamic Chart with Table
    Module 3:
    Analyzing Data with Table
  28. Create Table with Quick Analysis
  29. Remove Duplicate Records
  30. Add Total Row to Table
  31. Insert Calculated Columns
  32. Filter Table Data with Custom Filter
  33. Use Slicer to Filter Data
  34. Apply Conditional Formatting
  35. Sort and Filter Data by Color
  36. Create In-Cell Chart with Sparklines
    Analyzing Data with PivotTables
  37. Overview of PivotTable & PivotChart
  38. Create PivotTable from Table
  39. Change Report Layouts
  40. Show and Hide Report Totals
  41. Create Custom Calculations
  42. Filter Pivot Data with Slicer and Timeline
  43. Group Fields in a PivotTable
  44. Create Calculated Fields in PivotTable
    Module 5
    Importing External Data Sources
  45. Import Data from Text Files
  46. Create PivotTable from Microsoft Access
  47. Create PivotChart from Microsoft Access
  48. Manage Data Connections
    Creating Dashboard Report
  49. Overview of Dashboard
  50. Create PivotTable and PivotChart
  51. Hide Field Buttons from PivotChart
  52. Use Slicer to Connect PivotTables
  53. Build a Slicer Dashboard Report
    Other Tips and Tools
  54. Flash Fill
  55. Quick Analysis
  56. Slicer to Filter Excel Table
  57. Timeline to Filter PivotTable
  58. Connecting Multiple PivotTables
  59. Sparklines
    Participants should be proficient in English.
    The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.
    All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

COURSE Training Center: Datastat Training Center, Nairobi, Kenya
Start Date: 6/24/2019
End Date: 6/28/2019
Fee: Ksh 80000, $900

EMAIL: [email protected]
TELEPHONE : +254724527104