Training on Data analysis using Microsoft Excel 3rd - 7th August 2020

INTRODUCTION

Excel has powerful tools that enable busy users to set up systems that simplify data analysis and interpretation. Effectively using Excel allows users to devote their time more profitably to making decisions about and acting on results, with more effective outcomes. Participants actively learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants also receive a manual describing all the techniques learned.

DURATION

5 days

COURSE OBJECTIVES

  • Protect a workbook and save with a backup
  • Understand and use advanced functions
  • Consolidate data, link and export data
  • Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
  • Create and modify Pivot Tables and Pivot Charts
  • Create and modify Microsoft Excel Macros

KEY TAKEAWAYS

  • Attaching a Password
  • Modifying a Password
  • Protecting Cells
  • Formulas and Functions
  • Financial Functions
  • Logical Functions
  • The AND Function
  • The OR Function
  • Nesting Functions
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Data Validation
  • Data Consolidation
  • Importing Data
  • Importing CSV Files
  • Text Import Wizard
    **Pivot Table Reports
  • Pivot Table Layout
  • Rearranging Data
  • Filtering a Report
  • Adding Fields
  • Field Settings
  • Refreshing Data
  • Creating a Pivot Chart
  • Creating Pivot Chart Reports from Scratch
  • Adding Fields to a Pivot Char

HOW TO REGISTER ONLINE
To register online to book your spot, click on this link Online Registration Form

CUSTOMIZED TRAINING

This training can also be customized for your institution upon request. You can have it delivered your preferred location.

For further inquiries, please contact us on the details below:
Tel: +254 (0) 739167709.
Email: [email protected]