16hrs – ICDL Perform Spreadsheet Functions (Excel Fundamentals)

Program Fundamentals                

• Understanding the Excel Screen
• Giving Commands & Command Shortcuts
• Create, Open, Save & Close Workbook

Getting Started with Worksheets           

• Types of Mouse Cursor
• Entering Labels and Values
• Selecting and Entering Data in Cell Range
• Entering Content Automatically

Editing a Worksheet

• Editing Cell Contents
• Copy and Moving Cells & Clipboard
• Checking Spelling
• Insert & Delete Cells, Rows & Columns
• Using Undo and Redo
• Finding and Replacing Content
• Adding Comments to Cells

 Formulas and Functions

• Overview of Formulas and Cell References
• Entering Formulas
• Formulas with Multiple Operators
• Inserting and Editing a Function
• Using Logical Functions
• Displaying and Printing Formulas
• Understanding Formula Errors

Formatting a Worksheet             

• Formatting Text & Values
• Adjusting Row Height and Column Width
• Working with Cell Alignment
• Adding Cell Borders & Background Colours
• Copying Formatting

Creating and Working with Charts

• Choosing and Selecting the Source Data
• Choosing the Right Chart & Elements
• Inserting, Moving and Resizing a Chart
• Editing, Adding, and Removing Chart Data
• Change Chart Data, Layout, Style & Labels
• Changing the Chart Gridlines
• Emphasizing Data
• Applying Different Chart Type
• Modifying Chart Background
• Formatting Chart Elements

 Managing Workbooks

• Using Workbook Views
• Select, Switch, Insert, Delete, Rename, Move & Copy Worksheets
• Splitting and Freezing a Window
• Creating Headers and Footers
• Hidie Rows, Columns, Worksheets & Windows
• Setting the Print Area
• Adjusting Page Margins and Orientation
• Adding Print Titles, Gridlines, Row & Column Headings
• Adjusting Paper Size & Print Scale
• Printing Worksheets and Workbooks

Working with Data Ranges         

• Sort by One & Multiple Columns
• Filtering Data

Customizing Excel          

• Customizing the Ribbon, Quick Access Toolbar and Excel’s Default Options

During the course of, ICDL Excel – Fundamentals, the learners get to make quick and accurate numerical calculations and help their data to look sharper and more professional.

This course is most suitable for Account Executive, Admin Executive, and HR personnel who deals with number reporting. It allows them to create managed worksheets, create charts, do calculations to manage reports such as inventory listing, payrolls, invoices, payment and product pricing.