Microsoft Excel for Construction Management
Microsoft Excel for Construction Management, available at $94.99, has an average rating of 4.4, with 135 lectures, 3 quizzes, based on 598 reviews, and has 7656 subscribers.
You will learn about 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. This course is ideal for individuals who are Individuals in construction who are beginners to Excel who have never used it before. or Intermediate Excel users who are looking to brush up their skills specific to construction. or Anyone in construction who has sat behind a computer. It is particularly useful for Individuals in construction who are beginners to Excel who have never used it before. or Intermediate Excel users who are looking to brush up their skills specific to construction. or Anyone in construction who has sat behind a computer.
Enroll now: Microsoft Excel for Construction Management
Summary
Title: Microsoft Excel for Construction Management
Price: $94.99
Average Rating: 4.4
Number of Lectures: 135
Number of Quizzes: 3
Number of Published Lectures: 135
Number of Published Quizzes: 3
Number of Curriculum Items: 138
Number of Published Curriculum Objects: 138
Original Price: £149.99
Quality Status: approved
Status: Live
What You Will Learn
- 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.
Who Should Attend
- Individuals in construction who are beginners to Excel who have never used it before.
- Intermediate Excel users who are looking to brush up their skills specific to construction.
- Anyone in construction who has sat behind a computer.
Target Audiences
- Individuals in construction who are beginners to Excel who have never used it before.
- Intermediate Excel users who are looking to brush up their skills specific to construction.
- Anyone in construction who has sat behind a computer.
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 formulasin 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 Tablesand Data Validation.
-
Manage Textdata 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 VLOOKUPand 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!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: Udemy Platform
Lecture 3: Walk though VLOOKUP formula
Lecture 4: Have you left Feedback?
Chapter 2: Overview of the Excel Programme
Lecture 1: Introduction: Overview of the Excel Programme
Lecture 2: Workbooks and Sheets
Lecture 3: Cells and Ranges
Lecture 4: The Ribbon
Lecture 5: Excel Options
Lecture 6: Moving Around
Chapter 3: Quick Keys
Lecture 1: Introduction to Quick Keys
Lecture 2: Common Quick Keys
Lecture 3: Function Keys
Lecture 4: Formatting and Other
Chapter 4: Introduction to Formulas
Lecture 1: Introduction: Formulas
Lecture 2: Entering Formulas
Lecture 3: Characters Used in Formulas
Lecture 4: SUM and COUNT
Lecture 5: IF Functions
Lecture 6: AND, OR
Lecture 7: SUMIF and SUMIFS
Lecture 8: COUNTA, COUNTBLANCK, COUNTIF, COUNTIFS
Lecture 9: AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS
Lecture 10: MIN, MINA, MINIFS, MAX, MAXA, MAXIFS
Lecture 11: LARGE, SMALL
Lecture 12: SUBTOTAL
Lecture 13: IFERROR
Lecture 14: ROUND, ROUNDUP, ROUNDDOWN, MROUND
Lecture 15: Introduction to Formulas Exercise Overview
Lecture 16: Introduction to Formulas Exercise Solution
Chapter 5: Formatting
Lecture 1: Introduction: Formatting
Lecture 2: Fonts, Colours, Fills
Lecture 3: Boarders
Lecture 4: Manipulation Columns and Rows
Lecture 5: Format Painter
Lecture 6: Conditional Formatting
Lecture 7: Illustrations
Lecture 8: Text Boxes and Word Art
Lecture 9: Links
Lecture 10: Notes and Comments
Lecture 11: Paste Special
Lecture 12: Protection
Lecture 13: Formatting Exercise Overview
Lecture 14: Formatting Exercise Solution
Chapter 6: Data Categories
Lecture 1: Data Categories: Introduction
Lecture 2: General, Number, Text and Others
Lecture 3: Date and Time
Lecture 4: Currency and Accounting
Lecture 5: Data Categories Exercise Overview
Lecture 6: Data Categories Exercise Solutions
Chapter 7: Viewing and Printing Spread Sheets
Lecture 1: View and Printing Sheets: Introduction
Lecture 2: Views
Lecture 3: Printing – Page Setup
Lecture 4: Printing – Scaling and Sheet Options
Lecture 5: Viewing and Printing Sheets: Summary
Chapter 8: Organising Data
Lecture 1: Introduction: Organising Data
Lecture 2: Sorting
Lecture 3: Auto Filter
Lecture 4: Advanced Filter
Lecture 5: Grouping
Lecture 6: Data Validation
Lecture 7: Text to Columns
Lecture 8: Find and Select tools
Lecture 9: Tables
Lecture 10: Tables Formulas
Lecture 11: Organising Data Exercise Overview
Lecture 12: Organising Data Exercise Solutions
Chapter 9: Math Functions
Lecture 1: Math Functions: Introduction
Lecture 2: PI
Lecture 3: Deg, Radions
Lecture 4: SIG, COS, TAN
Lecture 5: SQRT, SQRTPI
Lecture 6: POWER
Lecture 7: CONVERT
Chapter 10: Text Functions
Lecture 1: Introduction: Text Functions
Lecture 2: CONCAT and &
Lecture 3: LEFT, RIGHT, MID
Lecture 4: LEN
Lecture 5: SUBSITUTE
Lecture 6: UPPER and LOWER
Lecture 7: SEARCH and FIND
Lecture 8: Text Functions Exercise Overview
Lecture 9: Text Functions Exercise Solutions
Chapter 11: Date and Time Functions
Lecture 1: Date and Time Functions: Introduction
Lecture 2: TODAY(), NOW()
Lecture 3: YEAR-MONTH-DAY-HOUR-MINUTE-SECOND Functions
Instructors
-
James Gedney-Higham
Teaching Construction into the 21st Century
Rating Distribution
- 1 stars: 5 votes
- 2 stars: 11 votes
- 3 stars: 86 votes
- 4 stars: 211 votes
- 5 stars: 285 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024