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

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

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