This course introduces Excel features that save you time. It is designed primarily for those who spend many hours formatting and updating data in spreadsheets.
This course is aimed at a person who is proficient in the fundamentals of using Excel. It will suit users who now wish to use Excel functions and commands to promote a more efficient use of time spent formatting and updating data.
Course content:
- Create and copy calculations using absolute and relative addressing, e.g. $A$4 vsA4
- Manipulate the view to easily work with multiple worksheets and large tables of data
- Set the print options to print titles on each page and Headers and Footers
- Sort and Filter large lists of data
- Link, move and copy information between worksheets and workbooks
- Save time and reduce errors using simple Functions
- Control results using Goal Seek
- Format and protect workbooks so you can confidently share with other users
- Create and use macros to cut down on processing time