INTRODUCTION TO EXCEL

May 15, 2018
CREM Nigeria
0

Overview

Microsoft Excel 2013 is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating address books, mailing lists, grocery lists, tracking expenses, creating invoices and bills, doing financial accounting, balancing checkbooks, as well as any other purpose that requires a spreadsheet or table.

This training deals with the main features of Excel that are used by most people on day to day basis, including text functions, simple logical functions, creating Charts, Sorting and Filtering Lists, inserting diagrams and comments, and Importing and Exporting data.

KEY LEARNING OBJECTIVE

At the conclusion of this programme, participants will possess skills to:

Create a spreadsheet
Format cells, rows, columns, and entire worksheets so they fit and match your data
Enter data into a spreadsheet
Use formulas and functions for math, accounting, and totaling
Create formulas and functions
Create charts and diagrams for your data
Create data lists and forms
Create and use pivot tables and pivot charts
Work with Excel templates
Share and protect your worksheets and workbooks
Use What-If Analysis to determine possible outcomes

TARGET AUDIENCE

Middle Level Staff

COURSE CONTENT