Data Analytics & Business Intelligence

Data Analysis with Microsoft Excel

Learn how to organise, analyse and present business data in Excel using practical formulas, tables, PivotTables and charts.

OnlineOn-SiteAt our Venue 3 days

Course Description

What You'll Learn

  • Prepare and structure data correctly for analysis in Excel.
  • Use formulas and functions to calculate and analyse business information.
  • Summarise large datasets using PivotTables.
  • Apply filtering, sorting and conditional analysis to answer business questions.
  • Create clear charts and reports from analysed data.
  • Reduce common spreadsheet errors through better data and formula practices.

Who this course is for

  • Managers
  • Finance & Accounting Professionals
  • Data & Analytics Professionals
  • Administration & Support Professionals

Course Outline

  • Structuring spreadsheet data correctly
  • Working with Excel tables
  • Sorting and filtering records
  • Finding and correcting inconsistent data
  • Handling blanks, duplicates and common data-quality problems
  • Choose How You Want to Train

    Choose the delivery format that works best for your team. Pricing varies by format, and you can select your preferred training dates and location when making your booking.

    Online

    Live, instructor-led virtual training delivered over Meet, Zoom or Teams.

    On-Site

    Trainer travels to your premises, wherever you are.

    At our Venue

    Training delivered at our one of our venues, closest to your location.

    Flexible scheduling

    You choose your preferred training dates when booking. For in-person training, you can also specify where you would like the training delivered, whether at your premises or at an arranged venue.

    Your Trainer

    Matched to your training needs

    Your trainer is selected after booking based on the course requirements, your industry, team profile, location, and learning objectives.

    CertBridge Global works with vetted trainers and subject-matter experts, allowing us to match each engagement with a facilitator whose experience is relevant to the training being delivered.

    Your assigned trainer will be confirmed as part of the training arrangements.

    Certificate of Participation

    Recognition for completing your training

    Participants who attend the training receive a CertBridge Global Certificate of Participation, recognising their involvement in the programme and the learning undertaken.

    From KES 22,000
    per participant
    Book Now