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
-