Dan Bartlett Engineering LLC
home / publications / excel
Downloads
8 Things You (and Everyone in Your Office) Should Be Able to Do with Microsoft Excel®
By Daniel Bartlett, P.E.
Print and Kindle Versions Available Now on Amazon!
Downloads of Excel Files (.XLSX files for Excel 2007, 2010, 2013, and 2016)
Section 0: Introduction
Section 1: Formatting
Section 2: IF() Function
Section 3: Parsing Text
Section 3 .CSV file (data to import into the Excel file)
Section 4: Advanced Formulas
Section 5: Finance I -- Loans
Section 6: Finance II -- Investments
Section 7: Finance III -- Evaluating Opportunities
Section 8: Pivot Tables
Downloads of Excel Files (.XLS files for Excel 2003 and Earlier)
Section 0: Introduction
Section 1: Formatting
Section 2: IF() Function
Section 3: Parsing Text
Section 3 .CSV file (data to import into the Excel file)
Section 4: Advanced Formulas
Section 5: Finance I -- Loans
Section 6: Finance II -- Investments
Section 7: Finance III -- Evaluating Opportunities
Section 8: Pivot Tables
By Daniel Bartlett, P.E.
Print and Kindle Versions Available Now on Amazon!
Downloads of Excel Files (.XLSX files for Excel 2007, 2010, 2013, and 2016)
Section 0: Introduction
Section 1: Formatting
Section 2: IF() Function
Section 3: Parsing Text
Section 3 .CSV file (data to import into the Excel file)
Section 4: Advanced Formulas
Section 5: Finance I -- Loans
Section 6: Finance II -- Investments
Section 7: Finance III -- Evaluating Opportunities
Section 8: Pivot Tables
Downloads of Excel Files (.XLS files for Excel 2003 and Earlier)
Section 0: Introduction
Section 1: Formatting
Section 2: IF() Function
Section 3: Parsing Text
Section 3 .CSV file (data to import into the Excel file)
Section 4: Advanced Formulas
Section 5: Finance I -- Loans
Section 6: Finance II -- Investments
Section 7: Finance III -- Evaluating Opportunities
Section 8: Pivot Tables
Excel Files Discussed on YouTube Videos
Reducing Fractions in Microsoft Excel: https://youtu.be/XXjEse9oUR4
Reducing Fractions (7/8/16)
Reducing Fractions in Microsoft Excel: https://youtu.be/XXjEse9oUR4
Reducing Fractions (7/8/16)
