Skip links

Microsoft Excel for Business Professional

8 - 10 July 2024

Course Description

This training is designed to equip you with the essential Microsoft Excel skills needed to thrive in
a business environment. By the end of this course, you will be able to confidently navigate the
Excel interface, analyze data, automate tasks, and present your findings effectively

Target Audience:

Business professionals of all levels who want to improve their Excel proficiency.

Course Duration: 3 Days

What is the content of 3 Day Training?

The cost will be submitted through quotation

 

Day 1

Module 1:Introduction to Excel

  • Getting familiar with the Excel interface
    o Entering and formatting data
    o Navigation techniques
    o Working with workbooks and worksheets

Module 2: Essential Formulas and Functions

 

o Understanding formulas and cell references
o Performing basic calculations (addition, subtraction, multiplication, division)
o Commonly used functions (SUM, AVERAGE, COUNT, VLOOKUP)
o Logical functions (IF, AND, OR)

 
11 june 2024
12 june 2024

Day 2

Module 3: Data Analysis and PivotTables

o Sorting and filtering data
o Creating charts and graphs to visualize data
o Introduction to PivotTables for data summarization and analysis
o Using PivotTables to create dynamic reports

Module 4: Advanced Techniques and Automation

Data validation and error checking
o Creating and using templates

Module 5: What-If Analysis

Introduction to What-If Analysis and its benefits in business decision-making.

• Scenario Manager: Learn how to create different scenarios with varying input values and
analyze their outcomes.
• Goal Seek: Explore how to set a desired outcome and identify the input value needed to
achieve it.

 

Day 3

module 6 :Excel Programming:

▪ Introduction to VBA (Visual Basic for Applications) - the programming
language for Excel.
▪ Recording macros to automate repetitive tasks.
▪ Using VBA code to manipulate data, format cells, and create custom
functions.

o Sharing and collaboration tools in Excel

 

Module 7: Presenting Your Work

  • Formatting your spreadsheet for professional presentations
    o Creating clear and concise charts and graphs
    o Exporting your data to other applications
13 june 2024

How do I register?

  1. Call 063 4222191 || 065 7555549 to register
  2. You can register online through www.hasiconsulting.com
  3. You can also register by coming to HASI Consulting Office at
    1st Street, Burj Omaar Building, 3nd Floor, Room 301 & 302, Hargeisa., Hargeisa, Somalia
This website uses cookies to improve your web experience.