1. Excel Intermediate Part 1
Building a Budget
Take your Excel skills to the next level with this practical, construction-focused intermediate course. Designed for professionals who already understand the basics, this session focuses on customizing Excel for your workflow, working with tables, and applying key tools that improve accuracy and efficiency. Participants will learn how to use powerful features such as Flash Fill, Absolute and Relative References, and smart formatting to build clear, reliable budgets.
By the end of the course, you’ll have created a fully functional budget worksheet while learning the time-saving techniques and formatting principles that help ensure consistency and clarity in every project report.
-
Customize Excel options and views
-
Set up Set up the Quick Access Toolbar
-
Using the new Focus Cell feature
-
Using the new navigation features
-
Building basic functions
-
Tables
-
Create and manipulate tables
-
Adding, Sorting, Shifting Columns and Rows
-
Using Autofill and understanding options
-
Using Flashfill
-
Filter and sort data
-
Building a Budget
-
Understanding key principles in set up
-
Applying Flash fill
-
Building basic functions
-
Understanding Absolute and relative References
-
Formatting
-
Applying formats and colors
-
Selecting tips
-
Secrets of the Go To Command
Course duration:4 hours.