Dr. Jim Marquardson's Excel and Access Resources
- 01-Cells_and_Sheets.xlsx
- 01-Copying_and_Pasting.xlsx
- 01-Simple_Multiplication_Formula.xlsx
- 01-Sorting_and_Filtering-Students.xlsx
- 01-Sorting_and_Filtering-Cars.xlsx
- 01-Sorting_and_Filtering-Companies.xlsx
- 02-Marquette_Weather_Formulas.xlsx
- 02-Morgage_Calculator.xlsx
- 02-PV_Loan_Amount_Versus_Total_Paid.xlsx
- 02-Relative_versus_Absolute_References.xlsx
- 02-Retirement_Planning.xlsx
- 03-City_Population_VLOOKUP.xlsx
- 03-Gradesheet_VLOOKUP.xlsx
- 03-Nested_If-Venn_Diagram_of_Emotions.xlsx
- 03-Product_Quantity_Discount_HLOOKUP.xlsx
- 03-Rainy_Days_in_Marquette_COUNTIF_SUMIF_AVERAGEIF.xlsx
- 03-Sales_Staff_Booleans.xlsx
- 04-Crimes_by_Date_and_Time.xlsx
- 04-Project_Planning_Date_and_Time.xlsx
- 04-Text_Acceptance_Letters.xlsx
- 04-Text_Wrangling_on_the_Ranch.xlsx
- 05 - Charting - Spurious Correlations.url
- 05-Bubble_Charts-Ice_Cream_Sales.xlsx
- 05-Column_Charts-GOOG_stock_price.xlsx
- 05-Line_Charts-Marquette_Weather_1990-2017.xlsx
- 05-Pie-in-Pie-Enthusiam_for_New_Year's_Resolutions.xlsx
- 05-Pie_Charts-US_Federal_Budget.xlsx
- 05-Stacked_Column_Charts-US_Census.xlsx
- 05-Treemap_Chart-Spend_by_City.xlsx
- 06-Best_Mortgage-Data_Table.xlsx
- 06-Best_Mortgage-Goal_Seek.xlsx
- 06-Best_Mortgage-Scenarios.xlsx
- 06-Crossfit_Gym_Profitability.xlsx
- 06-Investments-Data_Table.xlsx
- 06-Investments-Goal_Seek.xlsx
- 06-Investments-Scenarios.xlsx
- 07-Circular_References-Commission.xlsx
- 07-Circular_References-Final_Pay.xlsx
- 07-Dashboard-Named_Ranges.xlsx
- 07-Dashboard-Reference_Worksheets.xlsx
- 07-Restaurant_Combos-Reference_Worksheets.xlsx
- 07-Seahawks_Statistics-Reference_Worksheets.xlsx
- 07-Text_to_Columns-Dashes.xlsx
- 07-Text_to_Columns-Fixed_Width.txt
- 07-Text_to_Columns-Fixed_Width.xlsx
- 07-Text_to_Columns-Pipe_Delimeted.txt
- 07-Text_to_Columns-Pipe_Delimeted.xlsx
- 08-Drugs_and_Heart_Rate.xlsx
- 08-Model_Error_vs_Standard_Deviation-Ice_Cream.xlsx
- 08-Spurious_Correlation-Spelling_and_Spiders.xlsx
- 08-Statistics-Anscombe's_Quartet.xlsx
- 08-Statistics-Butter_and_Life_Satisfaction.xlsx
- 08-Statistics-Couple_Ages.xlsx
- 08-Statistics-Exam_Scores.xlsx
- 08-Statistics-Height-Standard_Deviations.xlsx
- 08-Statistics-Weak_and_Strong_Relationships.xlsx
- 09-Conditional_Formatting-Car_Survey.xlsx
- 09-PivotTables-GOV_Web_Analytics.xlsx
- 09-PivotTables-Lumber_Company_Transactions.xlsx
- 09-Sparklines-Column-Revenue_by_Department.xlsx
- 09-Sparklines-Line-Blood_Pressure.xlsx
- 09-Sparklines-Win_Loss-Gambling.xlsx
- 10-Solver-Highest_Elevation.xlsx
- 10-Solver-Maximum_Point-Evolutionary_Method.xlsx
- 10-Solver-Project_Selection-Evolutionary_Method.xlsx
- 11-Excel_versus_Access.xlsx
- 11-TODO List-1-Requirements.docx
- 11-TODO_List-2-Spreadsheet.xlsx
- 11-TODO_List-3-Database.accdb