Course Info
EXCEL WORKSHOP
This workshop will help you understand and give you confidence in your knowledge of Excel.
- Learn how to utilise Excel's tools to format text, apply borders and shading, set cells to automatically add decimal points, currency symbols and date formats.
- Learn how to properly set up a spreadsheet, utilise filters to view specific sections of data, search the entire database for a specific entry and gain a basic foundation in database.
- Learn how to perform mathematical calculations using Excel's formulas and learn how to automatically update dates and figuses to an existing spreadsheet.
- Learn how to create 3D charts to display financial data and how to reference data from a separate spreadsheet page.