Excel Decoding Complexity: Intermediate Formulas & Functions – 1 Day
Description
Unveil the power of Excel with our “Excel Decoding Complexity: Intermediate Formulas & Functions – One Day Accelerator”. Tailored for the corporate workforce, this course harnesses Excel’s robust capabilities to provide you with critical skills for effective data management and problem-solving.
Key Benefits:
Improved Problem-Solving: Master Excel’s advanced formulas and functions to navigate data complexities and enhance your problem-solving abilities in your current and future roles.
Efficient Data Management: Learn and apply absolute cell referencing, facilitating precise data management and accuracy.
Simplified Workflows: Discover how to name cell ranges and utilize these names in formulas, simplifying your Excel workflows and increasing efficiency.
Effective Error Handling: Gain skills in navigating through Excel errors, saving time on troubleshooting and boosting productivity.
Advanced-Data Linking: Develop expertise in linking cells across worksheets and workbooks using formulas, enhancing your data organization and management across multiple data sources.
Enhanced Presentation Skills: Upgrade the look of your worksheets with customized number formats and conditional formatting, making your data not only accurate but also visually compelling.
This accelerated course offers an immersive experience to master Excel’s intermediate formulas and functions in just a day. Embrace the opportunity to handle data-related challenges with increased effectiveness, becoming a vital asset in the data-driven corporate landscape.
Course Information
Pre-requisites
To gain the most from this course, you need to have successfully completed the Excel Essentials course or have equivalent skills and knowledge.
Aim
This course aims to provide you with the skills and knowledge necessary to manage data and solve problems using functions and formulas.
Learning Outcomes
At the completion of this course, you should have the
skills and knowledge to:
- Understand Absolute cell referencing
- Analyse data using formulas and functions
- Simplify formulas by naming cell ranges and using the names in formulas
- Work with text date and time functions
- Navigate through errors
- Link cells across worksheets and workbooks using formulas
- Enhance the look of worksheets by using customized number formats and conditional formatting
Face-to-Face Available for Canberra or Webinar.
Price: $410
Available Dates:
21st May 2024
11th June 2024
15th July 2024
25th July 2024
6th August 2024
When registering for this course you are agreeing to the following cancellation/reschedule policy.
Cancellation/Reschedule Policy
To re-schedule or cancel a booking, please notify Wizard with 5 full working days’ notice, prior to the commencement of the course.
*Cancellation is required in writing*
– Should we receive less than 5 full working days notice, the full course costs will be charged.
– We are happy to accept a substitution prior to the commencement of the course.
– Substitutions must have application knowledge at the appropriate level.
– If unable to attend due to sickness, a free se-sit will be offered if a medical certificate can be provided.
Additional Details
Registration email/URL - techadmin@wct.com.au