Provide the necessary knowledge and skills to deal with numbers, formulas, functions and graphs, using Microsoft Excel, so that you can take advantage of the capabilities and features of the program in the performing your daily work and tasks.

Course Objectives:

At the end of this course, the participants should be able to

• Learn about the Excel interface and be able to use it
• Master the skill of designing and using workbooks and worksheets
• Working with tables and charts
• Master the skill of handling data using forms
• Designing formulas and using functions
• Print worksheets and workbooks

Target Audience:

Individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.

• Basics of Excel
• Data Entry into Excel sheets
• Using Formulas in Excel
• Editing in Excel

Course Methodology:

This training course will be held in a computer lab where every participant will have his own computer to be able to learn and implement the different skills, where the trainer will perform the skill and the participants will follow by performing the same skill in their computers.

Excel interface

• Excel interface look
• Create something
• Search for recent files
• keep in touch
• Discover contextual tools
• Manage data using Excel tables
• Share work with others
• Insert functions and create formulas
• Find anything you want
• Find related information

Learn about the user interface and command bar
File tab

• Quick Access Toolbar
• The tape
• The worksheet area
• Status bar

Workbook and worksheet

• Create a workbook
• Close the Excel program
• Close an Excel workbook
• Save an Excel workbook

Design of workbooks

• Show and hide columns and rows
• Hide columns
• Show hidden columns
• Freeze columns and rows
• Unfreeze
• Working papers
• Create and rename worksheets
• Move the worksheet inside the workbook

The basics of entering data into a worksheet

• Movement and movement between worksheet cells
• Cycle through worksheets in the same workbook
• Enter data for the cell
• Enter text or number in a cell
• Enter a fixed-decimal number
• Enter a date or time in a cell
• Enter the same data in multiple cells simultaneously
• Enter the same data on multiple worksheets simultaneously
• Better show your work (coordinate worksheet)
• Align data within a cell
• Merge cells, rotate and wrap text
• Change the height and width of the cell
• Number format
• Format number as text
• Wrap text in a cell
• Enable text wrapping automatically

Tables

• Create and format tables
• Sort table data
• Steps to sort the table
• Filter data
• Data filtering method
• Custom filter application
• Filter data using PBX

Charts

• Create a Chart
• Delete the chart
• Add a title and layout for the chart
• Change the layout of the outline
• Change the appearance of the layout (style)
• Add striking layout to your outline
• Reuse charts by creating charts templates

Add, edit, find and delete rows using a data model

• Learn about data models
• Add a form button to the bar
• Use a data template
• Add a new row of data
• Search for a class by navigating
• Search for a row by entering search criteria
• Change the data in a row
• Delete a row
• Close a data form

Formulas and functions in Excel

• Basic Mathematics in Excel
• Plural
• Subtraction
• Multiplication and division
• Using Functions
• Plural function
• Multiplication function
• Sequence of arithmetic operations (priorities of arithmetic operations)
• An overview of advanced formulas

Print in excel

• To print your business on excel
• Select your printer type
• Select what you want to print
• Choose the page orientation
• Select the paper size
• How many copies do you want to print
• Adjust page margins