The Deal

• €16 for a Microsoft Excel Online Diploma Course (96% off)

Modules

• How to open and close Excel and a basic overview of Spreadsheet software
• What are workbooks and worksheets - how they work and what they assist with
• How to alter workbooks and make changes to the data held within them
• How to perform and generate different basic calculations upon data within Workbooks
• Changing the format of Worksheets by editing fonts, colours and other factors
• Printing worksheets and changing options to find the most efficient print formats
• How to manage a multitude of similar or related workbooks to make storing and saving more effective
• Using data stored in workbooks and worksheets to generate a wide array of charts to view data more efficiently
• A more complex look at the variety of available functions and formulae
• How to generate and run macros to make workflow more quickly and smoothly
• Using data from a variety of external sources and how to effectively import it into Excel
• How to generate tables and use the versatile range of options to filter and view the data
• Viewing data within a workbook more efficiently by changing the format and additional formatting options
• Adding external or internal content to enhance workbooks
• Using the thesaurus and research options to highlight and correctly collate external sources

• How to set validation to ensure that errors are not introduced into a workbook

• See full course details