Description
In this course, you will learn :
- Excel worksheets and workbooks can be created, configured, and saved.
- Worksheets and workbooks can be navigated and formatted.
- Customize worksheet and workbook options and views.
- Set up Excel worksheets and workbooks for printing (e.g. page setup).
- Insert and format data into cells and ranges, as well as create and modify tables.
- Cells, ranges, and tables can be highlighted, filtered, sorted, and grouped.
- Excel charts can be created and formatted in a variety of ways.
- Insert and format objects, including image editing.
- Create formulas in Excel, including conditional logic and text modification.
Syllabus :
- An introduction to Excel
- Create worksheets and workbooks
- Configure worksheets and workbooks to save
- Basic formulas
- Navigate through Excel worksheets and workbooks
- Format worksheets and workbooks
- Customise options and views for worksheets and workbooks
- Configure Excel worksheets and workbooks to print
- Utilise cell ranges and references in formulas and functions
- Insert data in cells and ranges
- Format cells and ranges
- Highlight and filter cells and ranges in Excel
- Summarise data with Excel functions
- Create a table
- Modify a table
- Filtering, Sorting and Grouping
- Utilise conditional logic in functions
- Create a chart in Excel
- Format a chart in Excel
- Insert and format an object
- create and modify images by using the Image Editor
- Format and modify text with functions