the Somali Assistive Technology Institute

Introduction to the Excel Training Workbook

Welcome to this comprehensive Excel training workbook. This course has been carefully designed to help learners develop strong, practical skills in Microsoft Excel—from the most essential tools to advanced data analysis techniques. Whether you are completely new to Excel or looking to expand your existing knowledge, this workbook will guide you step-by-step in a clear, structured, and accessible way.

Microsoft Excel is one of the most widely used applications in the world for managing data, performing calculations, organizing information, and making informed decisions. By learning Excel, you gain valuable skills that are useful in education, business, accounting, finance, administration, research, and everyday problem-solving.

This workbook takes a progressive approach: you will start with the basics and gradually build toward professional-level skills. Each lesson includes explanations, examples, exercises, and review questions designed for real learning in a classroom environment.

What You Will Learn in This Course

Throughout this Excel course, the student will learn:

• How to confidently navigate Excel and work with worksheets and workbooks
  • How to enter, edit, and format data accurately
  • How to use formulas and functions, including SUM, IF, VLOOKUP, and advanced functions
  • How to sort, filter, and organize data effectively
  • How to create, format, and customize charts and visualizations
  • How to use PivotTables to summarize and analyse large data sets
  • How to apply data validation, conditional formatting, and automation tools
  • How to work with advanced Excel features such as Power Query, data models, dynamic arrays, and complex formulas
  • How to manage multiple workbooks, protect sheets, and prepare professional documents

By the end of the course, the learner will be able to use Excel confidently and independently in academic, professional, and personal settings.

About the Somali Assistive Technology Institute

This workbook has been prepared, produced, and published by the Somali Assistive Technology Institute (SATI).
SATI is dedicated to providing high-quality training materials, accessible digital resources, and technology-focused education for learners of all abilities.

Our mission is to empower students—especially blind and visually impaired learners—by ensuring that all resources are designed with accessibility, clarity, and usability at the core.

This Excel workbook is part of SATI’s continuing effort to expand educational opportunities and support learners across communities.

Copyright Notice

© Somali Assistive Technology Institute (SATI) – All Rights Reserved.

This workbook is protected under international copyright laws.
No part of this material may be copied, reproduced, shared, distributed, uploaded, or stored in any form—digital or physical—without written permission from the Somali Assistive Technology Institute.

Unauthorized copying or distribution is strictly prohibited and illegal.
Violators may face legal action under copyright law.

This workbook is licensed solely for use by the registered student or training institution that received it.