1.2 Excel Int. Tables, Charts, Functions
Introducing Advanced Functions
Building on your budgeting skills, this course introduces advanced Excel functions and visualization tools that bring data to life. Participants will learn how to create dynamic charts, use slicers for interactive analysis, and apply multiple arguments in functions for deeper insights. With a focus on practical construction and engineering applications, this class also covers check boxes, nested functions, and conditional formatting—allowing you to make smarter, more flexible spreadsheets.
By mastering these tools, you’ll develop greater confidence in analyzing data, producing visuals, and presenting professional reports that stand out in both clarity and impact.
· Expanding the budget
· Creating and customizing charts
· Create a table
o Table functions
o Filtering tables
o Using slicers
o Adding and customizing the total row
o Apply Named ranges to a table
· Building functions with multiple arguments
· Working with Check Boxes
o Apply to conditional formatting
o Apply to conditional functions
· Learning how to nest functions within functions
Course duration:4 hours.