Excel Formulas and Functions
Master the functions and fundamental tools in MS Excel to enhance your efficiency in cleaning and preparing your data for analysis.
Download BrochureNext course date 17 Feb, 2025
Duration 2d in-person or 10.5h online
Class size Up to 25 learners
Who’s it for Everyone
Course overview
|
Excel Formulas and Functions is a tool-based technical workshop designed to equip participants with essential spreadsheet formatting, formula creation, and data analysis skills, enhancing their efficiency and accuracy in data-driven tasks. This workshop covers key functions, including date, math, lookup, text, and logical functions, along with a review of PivotTables, enabling learners to manage and analyze datasets proficiently. Participants will gain practical skills through discussion and simulations to efficiently summarize, analyze, and visualize data, enhancing their proficiency in Excel for effective data-driven decision-making. |
Spreadsheet FormattingMastering spreadsheet formatting ensures that data is presented clearly and professionally, which is vital for effective organizational communication and decision-making. Proper formatting improves readability, enhances the visual appeal of spreadsheets, and effectively highlights key information. Formula Building and StreamliningBuilding formulas empowers users to streamline calculations and data processing tasks, improving efficiency and reducing errors. Knowing how to copy and paste formulas correctly saves time and ensures data analysis and reporting consistency. Participants will also learn to use various library functions (date, math, and statistical) to efficiently handle diverse data analysis tasks. Foundations of PivotTablesParticipants will learn to create and utilize PivotTables, enabling them to summarize and analyze datasets efficiently. This segment covers organizing data, setting up PivotTables, using PivotCharts for dynamic visual representation, and advanced filtering techniques with Slicers and Timelines to enhance data analysis capabilities. |
Businesses that have taken StoryIQ Excel courses
How this workshop can help
We upskill people in the core data and communication skills required to make an impact in organizations, transforming professionals into influential contributors.
What they’re saying
"Exceptional content and instructor; immediately applicable to my role."
"Great learning experience! There’s always something new you’d get from these workshops. Very helpful for those dealing with large sets of data and doing presentations for various reasons. Engaging trainer providing not just a straightforward lecture but ways how to make data friendly and fun to deal with."
"The training and trainers was very organized. Everything was complete from the course content to the course materials. The learning experience was rich."
"Great training! Very informative and can really help with work."
Course delivery options
In-Person Team Training
Gather a group of between 10-25 learners for a private in-person class led by StoryIQ Master Facilitator. Delivered at a venue of your choosing, our private classes are customizable to your team’s needs.
Get startedCourse duration
- 2 days in-person
Course options
Post-training consultation sessions
After completing the course, participants will apply what they have learned to their own data problem as a post-training activity. A StoryIQ Instructor will then meet with small groups of 3-5 participants to evaluate progress and provide feedback.
Department-wide or organization-wide rollout
We provide special additional support for leaders and L&D professionals who are responsible for fostering data analytics skills more widely throughout their organization. Talk to us about your specific needs.
In-Person Public Training
Join a group of up to 25 learners in a public in-person class led by StoryIQ Master Facilitator. Learn alongside attendees from various industries, in a class described by learners as ‘instantly applicable’.
View upcoming eventsCourse duration
- 2 days in-person
Virtual Team Training
Gather a group of between 10 – 25 learners for a private online class led by StoryIQ Master Facilitator. Delivered live via Zoom or similar platforms, our private virtual classes are customizable to your team’s needs.
Get startedCourse duration
- 3.5-hour virtual sessions held over three days
Course options
Post-training consultation sessions
After completing the course, participants will apply what they have learned to their own data problem as a post-training activity. A StoryIQ Instructor will then meet with small groups of 3-5 participants to evaluate progress and provide feedback.
Department-wide or organization-wide rollout
We provide special additional support for leaders and L&D professionals who are responsible for fostering data analytics skills more widely throughout their organization. Talk to us about your specific needs.
Virtual Public Training
Join a group of up to 25 learners in a public in-person class led by StoryIQ Master Facilitator. Learn alongside attendees from various industries, in a class described by learners as ‘instantly applicable’.
View upcoming eventsDuration
- 3.5-hour virtual sessions held over three days
