0(0)

Spreadsheets (MS-Excel) Expert

Description

Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.

The knowledge of analysis of numerical data is an important activity in a broad range of job roles and organizations. Today, Accountants, Project managers, Sales executives, Engineers and many more rely on spreadsheets to carry out crucial calculations.

This course, therefore, sets the basic to advanced skills and knowledge required to use this powerful program effectively.

What Will I Learn?

  • Enter data into cells and use good practice in creating lists.
  • Select, sort and copy, move and delete data.
  • Edit rows and columns in worksheet.
  • Format numbers and text content.
  • Create/choose suitable charts to communicate information meaningfully.
  • Learn on page settings
  • Use available help resources, shortcuts and go to help tools to enhance productivity.
  • Create mathematical and logical formulas using standard spreadsheet functions.
  • Use good practice in formula creation and recognize error values in formulas.
  • Use Excel productively
  • Out of the box functionality usage to help you in reporting, project management,
  • Gain insights from vast array of data with ease
  • Analyze data like a professional
  • Write Awesome Formulas
  • Flexible 24/7 access

Topics for this course

1.0. Using Application

2.0. Cells

3.0 Managing Worksheets

4.0. Formulas and Functions

5.0. Formatting

6.0. Charts

7.0. Prepare Outputs

About the instructors

0 (0 ratings)

10 Courses

57 students

Spreadsheets
KSh1,500.00

Material Includes

  • Easy to understand content
  • Step wise learning module
Pathfinder Logo

Our Vision

Become a leading ICT Centre powering Creativity, Innovation and Entrepreneurship.