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
• Work with tables and charts
• Master the skill of handling data using forms
• Designing formulas and using functions
• Print worksheets and workbooks

Excel interface

• Excel interface in a glance
• Create something
• Search for recent files
• keep connected
• 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 ribbon
• The worksheet area
• Status bar

Workbook and worksheet

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

Design workbooks

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

The basics of entering data into a worksheet

• Move between worksheet cells
• Cycle through worksheets in the same workbook
• Enter data in 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 (format worksheet)
• Align data within a cell
• Merge cells, rotate and wrap text
• Change the height and width of the cell
• Number format
• Format numbers 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
• Custom filter form
• Filter data using slicer

Charts

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

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

• Learn about data forms
• Add a form button to the bar
• Use a data template
• Add a new row of data
• Search for a row 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
• Addition
• Subtraction
• Multiplication and division
• Using Functions
• Addition function
• Multiplication function
• Sequence of arithmetic operations (priorities of arithmetic operations)
• An overview of advanced formulas

Printing 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

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

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.

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