Excel for Engineering Professionals

Focused View

Jan Karel Pieterse

3:25:50

48 View

01 - Introduction

01 - Engineering and Excel.mp4

00:52

02 - 1. Spreadsheet Design Best Practices

01 - Knowing when (and when not) to use Excel.mp4

04:24

02 - Designing a workbook.mp4

07:09

03 - Documenting your work.mp4

06:23

04 - Formula habits.mp4

06:09

05 - Working with engineering units.mp4

05:28

06 - Improving data quality with data validation.mp4

06:58

07 - Working with tables.mp4

05:42

03 - 2. Essential Excel Functions

01 - Date and time functions.mp4

03:28

02 - Range names.mp4

07:33

03 - XLOOKUP and other lookup functions.mp4

06:45

04 - Statistical functions AVERAGE, STDEV, MIN, and MAX.mp4

06:46

05 - String functions.mp4

07:02

06 - Working with dynamic arrays.mp4

06:23

04 - 3. Solving Complex Problems

01 - Using Excel for process simulations.mp4

01:41

02 - Goal seek.mp4

03:55

03 - Excel Solver.mp4

04:40

05 - 4. Working with Charts

01 - Which chart type to use.mp4

03:30

02 - Dos and donts.mp4

03:57

03 - Working with charts Preparing your data.mp4

05:32

04 - Working with charts Staging area.mp4

03:56

05 - Trends in charts Trendlines.mp4

07:46

06 - 5. Importing Data

01 - Importing text files with Power Query.mp4

09:12

02 - Importing sets of files.mp4

05:28

03 - Importing the most recent file in a folder.mp4

02:54

07 - 6. Data Analysis

01 - When (and when not) to use PivotTables.mp4

03:12

02 - Regression analysis Analysis Toolpak add-in.mp4

05:07

03 - Regression analysis Helpful functions.mp4

06:35

08 - 7. VBA Basics

01 - Variables explained.mp4

08:02

02 - Working with workbooks, worksheets, and cells.mp4

11:56

03 - Working with arrays.mp4

05:17

04 - Conditions If, Then, and Select Case.mp4

04:16

05 - Loops For...Next and Do...Loop.mp4

06:46

06 - Events Automatically run VBA code.mp4

04:55

09 - 8. User-Defined Functions (VBA)

01 - How to write a proper user-defined function (UDF).mp4

06:42

02 - Understanding LAMBDA functions.mp4

03:35

03 - Creating a LAMBDA function.mp4

04:53

10 - Conclusion

01 - What have you learned.mp4

01:01

Description

While Microsoft Excel can be a powerful tool for engineers, most engineers barely scratch the surface with its full functionality. In this course, designed for advanced Excel users, Microsoft MVP Jan Karel Pieterse gives you an overview of some of the most robust features in Excel that can help you complete many common tasks as a mechanical, chemical, or structural engineer. Get a primer on what tasks are best suited for Excel in relation to other functions and tools as well as the most useful functions for engineering projects, from ranges and lookups to strings, arrays, and more. Get ready to use Excel to solve complex problems, work with charts, and import and analyze data sets. By the end of this course, you’ll be ready to start leveraging workbooks, sheets, cells, arrays, conditions, loops, and events for VBA programming.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Jan Karel Pieterse

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.