By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable.
The first lesson covers logging into Office 365 and Excel Online as well as how to navigate in the app. Students learn how to open, save, share and print workbooks and how to use some help tools.
Working with Data
The basics of Excel formulas and functions and the introduction of some tools and techniques to use when working with formulas. We cover how to modify rows/columns and how to sort & filter data.
Formatting a Worksheet
Students learn how to format text and cells, align cell contents, use find and select tools.
Adding Pictures and Shapes
Students learn how to insert and modify pictures and shapes.
Students will learn how to insert charts and perform some basic tasks with them.
Students learn about comments and managing multiple worksheets.
Fees and dates are negotiable for on-site courses, public course dates and fees can be provided on request.
What it covers:
- Getting Started
- Working with Data
- Formatting a Worksheet
- Adding Pictures & Shapes
- Managing Multiple Worksheets