Welcome to the resource site for ENGR-125 at Henry Ford College. This course covers Excel, MATLAB, and Python.
Lesson 1: Basics of Excel, Formulas, and Charts
Part 1: Move around, Excel Tabs, Formatting, Number Format …
Download Excel File Gasoline US properties.xlsx
Part 2: Excel formulas, sum, average, count, for filtered data
Download Excel File “2008 Traffic Data – Bridge.xlsx”
Part 3: Excel “IF” Formula – Create Catergories from Numerical Data – Weekend and Mon-Fri Categories
Download Excel File “2008 Traffic Data – Bridge.xlsx”
Part 4: Excel “IF” Formula – Formula to get Season from Month
Download Excel File “2008 Traffic Data – Bridge.xlsx”
Part 5: How to create charts in Excel, Line Charts, Pie Chart
Download Excel file “Annual Average Weather.xlsx”
Lesson 2: Summarizing Data in Excel with Pivot Table
Part 1: Summarizing Data in Excel with Pivot Table
Download Excel file “Traffic+Air Pollution Data with Headers.xlsx”
Part 2: Analyze data using Pivot Table and Create a PowerPoint Presentation
Download Excel file “Traffic+Air Pollution Data with Headers.xlsx”
Lesson 3: