Excel Bootcamp | Online | Sydney
About this workshop
This online excel bootcamp is an excel class designed to provide beginner participants with a general overview of Excel topics and a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and many topics covered, beginner excel users should expect to learn quickly and improve their skills. The online excel bootcamp is designed for participants looking for training to go from relatively little knowledge of Excel to achieve complex tasks and complex problems in just one day.
Agenda (Not necessarily taught in the order below):
- Terminology and Navigation
- Formatting
- Data Organisation
- Conditional Formatting
- Hiding and Grouping
- Formulas & Advanced Formulas
- Functions
- Basic Math Functions
- Conditional Math Functions
- Logical Functions
- Reference Functions
- Text Functions
- Filling
- Defined Name
- PivotTables
- Chart
- Trendline
- Secondary Axis
- Auditing tools
Takeaways
- Accelerate the internalisation of key time-saving keyboard shortcuts and formulas for navigation and efficiency.
- Work smarter and take advantage of the most useful helpful functions and features.
- Enhance the presentation of your detailed data by adding charts and formatting to your excel spreadsheet.
Prereqs & Preparation
A laptop loaded with Microsoft Excel, and a general familiarity with the excel class and program. You will also want to set up a Gmail account as we may jump in and out of a Google spreadsheet during the class.
Please Note
- This training is taken completely online using Zoom and Slack.
- You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection. .
- Download Zoom. Zoom is the video conferencing tool we will use. It works a lot like Google Hangouts or Skype. You will need to create an account in order to join the call.
- We will provide a link to the session via email 24 hours in advance - keep an eye on your inbox
