Excel interface
• Excel interface look
• 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
• Design workbooks
• Status bar
Workbook and worksheet
• Create a workbook
• Close Excel
• 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
• Worksheets Create and rename worksheets
• Create and rename worksheets
• Move the worksheet inside the workbook
The basics of entering data into a worksheet
• Enter data in the cell
• 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 (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 outline
• Change the appearance of the layout (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
• There is no subtraction function
• Multiplication function
• There is no division 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.