Microsoft Excel for Construction Management from Udemy

Learn Microsoft Excel and begin your journey to mastering undoubtedly the most used computer software in construction.

This the only course on Udemy (and possibly the internet) teaching Excel for construction management. If you are new to Microsoft Excel or simply want to brush up on your skills this course is for you.

See what students say about this course

“I use excel all the time but have limited knowledge about formulas and how to use all the functions, have learned some very helpful tips so far.”

“Great course and well explained”

“I will really recommend this course to anybody new to the construction industry, its introduction to Excel was what i needed to begin with,i am glad i took the course”

When you join today you will get access to over 120 lectures and downloadable spreadsheets designed specifically for the construction industry, this course will teach you Microsoft Excel directly applicable in your daily work, in whatever part of construction management you work in.

1. From Zero To Hero: You start off with the basics and building up your skills, by the end of the course you will be able to; apply Excel's advanced tools such as Pivot Tables, utilise advanced formulas such as VLOOKUP and INDEX/MATCH, and deploy Excel's wide range of visuals including charts.

2. Get Hands-On: This course focuses on you getting hands-on with Excel and enhancing what you learn through exercises and Quiz's.

3. Designed for the Construction Industry: Learning Excel on spreadsheets specifically designed for this course to represent the Excel spreadsheets that you will use day to day in your role.

4. Support for Every Step: Learning is a journey and with this course, we will be with you every step of the way through Udemy's Q&A platform.

In this course, we cover a wide range of topics, including:

Learning how to use the Excel programme efficiently.
Maximise your productivity with Quick Keys.
Learn how to create and enter formulas in Excel with detailed walk through's.
Enhance your spreadsheets by learning Excels Formatting Tools, including Conditional Formatting.
Optimise your spreadsheets for Printing.
Organise your data with Excel comprehensive suite of commands, such as Tables and Data Validation.
Manage Text data using Functions.
Amaze your boss and colleagues by deploying Advanced Date and Time Functions.
Take advantage of Excel's most sort after functions such as the VLOOKUP and XLOOKUP.
Analyse your data using Pivot Tables and all of Excel's available data analytic commands.
Reinforce your Excel spreadsheet by utilising Excel's wide range of Visuals and Charts.

When you purchasing this course you will get lifetime access to over 120 lectures and downloadable spreadsheets.

All backed by Udemy's 30 day money back guarantee, so there is no risk but a lot to gain by purchasing this unique course become a member today.

What's inside

Learning objectives

Learn to use excel professionally in construction.
Format your spreadsheets for a professional look.
Build a deep understanding of excel formulas.

Be able to deploy excels data analysis tools.
Quickly organise your data in excel.
Design charts to make the most impact.

Learn to use excel professionally in construction.
Format your spreadsheets for a professional look.
Build a deep understanding of excel formulas.
Be able to deploy excels data analysis tools.
Quickly organise your data in excel.
Design charts to make the most impact.

Syllabus

Introduction to the Course

Introduction to the course, please don't skip!

Udemy Platform

Walk though VLOOKUP formula

A quiz covering the topics within this section

A Quiz on the quick keys we have learnt in this section of the course

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Introduces learners to Microsoft Excel and its foundational concepts, which is standard in the construction industry

Designed specifically for individuals in construction management seeking to advance their Excel proficiency

Provides hands-on exercises and interactive content, fostering practical application and skill development

Covers a comprehensive range of Excel topics, including advanced functions, data analysis, and visualization

Offers lifetime access to course materials, providing continuous learning opportunities

Taught by instructors with expertise in Excel and construction management, ensuring relevant and industry-aligned content

Reviews summary

Practical excel for construction management

According to learners, this course offers practical Excel skills specifically tailored for the construction industry. Students appreciate its well-explained content, finding it valuable for those new to Excel or seeking to brush up on existing skills. The curriculum emphasizes hands-on application, covering essential functions like formulas and data organization directly applicable to daily work in construction management. Its focus on industry-specific spreadsheets makes the learning highly relevant for professionals.

Ideal for new users or skill refreshers.

"...its introduction to Excel was what i needed to begin with,i am glad i took the course"

"As someone new to Excel, I found this course perfect for getting started with the basics."

"It was an excellent way to brush up on my Excel skills and learn new functions."

Course content is well-structured and easy to follow.

"Great course and well explained"

"The explanations were very clear, making it easy to understand even complex topics."

"I appreciated the detailed walk-throughs which made learning the formulas straightforward."

Enhances real-world Excel application.

"I use excel all the time but have limited knowledge about formulas and how to use all the functions, have learned some very helpful tips so far."

"I found the hands-on exercises and quizzes helped me enhance my Excel skills for real-world application."

"The course helped me master advanced tools like Pivot Tables and VLOOKUP for my tasks."

Excel skills tailored for construction industry.

"I will really recommend this course to anybody new to the construction industry..."

"This course taught me how to apply Excel directly in my daily construction management work."

"The spreadsheets were specifically designed for construction, which made the learning highly relevant."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel for Construction Management with these activities:

Review Excel basics before starting the course

Show steps

Refresh your memory on the basics of Excel before diving into the course content.

Browse courses on Microsoft Excel

Show steps

Review the Excel documentation or watch a quick tutorial.
Complete a few practice exercises to test your understanding.

Organize your Excel notes and resources

Show steps

Improve your learning experience by organizing your notes, handouts, and other materials.

Browse courses on Microsoft Excel

Show steps

Create a folder on your computer for Excel materials.
Save all your notes, handouts, and practice exercises in the folder.
Organize the files into subfolders by topic or date.

Review your notes from a previous Excel course

Show steps

Refresh your knowledge of Excel concepts by reviewing your notes from a previous course.

Browse courses on Microsoft Excel

Show steps

Find your notes from a previous Excel course.
Review the notes and make sure you understand the concepts.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Read and Review Microsoft Excel for Dummies

Show steps

Improve your understanding of the basics of Microsoft Excel by reading a book written for absolute beginners.

Show steps

Purchase or borrow a copy of Microsoft Excel for Dummies.
Read the book from cover to cover, taking notes as you go.
Complete the exercises at the end of each chapter.

Watch Excel tutorials on YouTube

Show steps

Enhance your Excel skills by watching video tutorials that cover specific topics and techniques.

Browse courses on Microsoft Excel

Show steps

Search for Excel tutorials on YouTube.
Watch tutorials that cover topics you are interested in or need help with.
Take notes and try to replicate the steps shown in the tutorials.

Complete Excel practice exercises

Show steps

Reinforce your understanding of Excel formulas, functions, and features by completing practice exercises.

Browse courses on Microsoft Excel

Show steps

Find a website or textbook with Excel practice exercises.
Complete at least 10 exercises each day.
Check your answers and review the explanations.

Create a spreadsheet to track your finances

Show steps

Apply your Excel skills to create a practical tool that helps you manage your personal finances.

Browse courses on Microsoft Excel

Show steps

Decide what categories you want to track, such as income, expenses, and savings.
Create a new Excel spreadsheet and set up your categories as column headings.
Enter your financial data into the spreadsheet and use formulas to calculate totals and subtotals.

Career center

Learners who complete Microsoft Excel for Construction Management will develop knowledge and skills that may be useful to these careers:

Construction Manager

A Construction Manager is a professional who oversees the planning, design, and construction of projects, so that they are completed on time, within budget, and to the required quality. This course will help you to further develop the Excel skills necessary to manage construction projects more efficiently, such as the formulas necessary to create accurate budgets.

See salaries and explore the career path for Construction Manager

Architect

An Architect plans, designs, and oversees the construction of buildings. This course will help you develop the skills needed to use Excel for tasks relevant to architecture, such as creating construction cost estimates and project schedules. Having a strong grasp of Excel will allow you to work more efficiently and may lead to career advancement.

See salaries and explore the career path for Architect

Civil Engineer

A Civil Engineer designs, builds, and maintains infrastructure projects, such as roads, bridges, and water systems. This course will help you to further develop the Excel skills you need to succeed in this role, such as using formulas to calculate the cost of materials and labor for a project.

See salaries and explore the career path for Civil Engineer

Structural Engineer

A Structural Engineer designs and analyzes the structural elements of buildings and other structures, to ensure that they are safe and stable. This course will help you develop the Excel skills necessary to perform these tasks, such as using formulas to calculate the load-bearing capacity of a structure.

See salaries and explore the career path for Structural Engineer

Project Manager

A Project Manager plans, executes, and closes projects, ensuring that they are completed on time, within budget, and to the required quality. This course will help you to develop the Excel skills needed to succeed in this role, such as using formulas to create project budgets and schedules.

See salaries and explore the career path for Project Manager

Estimator

An Estimator calculates the cost of construction projects. This course will help you to develop the Excel skills needed to succeed in this role, such as using formulas to create accurate cost estimates.

See salaries and explore the career path for Estimator

Construction Superintendent

A Construction Superintendent oversees the day-to-day operations of a construction site. This course will help you to develop the Excel skills needed to succeed in this role, such as using formulas to track project progress and manage inventory.

See salaries and explore the career path for Construction Superintendent

Construction Inspector

A Construction Inspector ensures that construction projects meet building codes and safety regulations. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create inspection reports.

See salaries and explore the career path for Construction Inspector

Quantity Surveyor

A Quantity Surveyor calculates the cost of construction projects and prepares bidding documents. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create accurate cost estimates.

See salaries and explore the career path for Quantity Surveyor

Construction Scheduler

A Construction Scheduler plans and coordinates the activities of a construction project. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create project schedules.

See salaries and explore the career path for Construction Scheduler

Construction Safety Manager

A Construction Safety Manager develops and implements safety programs for construction projects. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to track safety data.

See salaries and explore the career path for Construction Safety Manager

Construction Lawyer

A Construction Lawyer advises clients on legal issues related to construction projects. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to create legal documents.

See salaries and explore the career path for Construction Lawyer

Construction Arbitrator

A Construction Arbitrator resolves disputes between parties involved in construction projects. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to analyze data and prepare reports.

See salaries and explore the career path for Construction Arbitrator

Construction Mediator

A Construction Mediator helps parties involved in construction projects to resolve disputes. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to analyze data and prepare reports.

See salaries and explore the career path for Construction Mediator

Construction Claims Consultant

A Construction Claims Consultant helps clients prepare and file construction claims. This course may be useful in developing the Excel skills needed to succeed in this role, such as using formulas to analyze data and prepare reports.

See salaries and explore the career path for Construction Claims Consultant