Excel & VBA

Excel Functions

• Excel functions by category

• A guide on INDEX MATCH, a better alternative to VLOOKUP

Graphing

• Charts in excel
• Axis formatting
• http://www.digitaltrends.com/computing/how-to-make-graph-in-excel/
• Use excel to create histogram
• Add a secondary axis in excel
• Highlighting data point in scatter and line charts
• Error bars

Pivot Tables

• Basic Guide
  

Optimization

• Excel Solver

Data Analysis in Excel

• Guide for Regressions, T-tests, ANOVA, etc. in Excel

 

VBA

• Full Excel VBA reference by Microsoft

• Walkenbach, John  Excel 2013 Power Programming with VBA

• Recording a macro
• Writing a macro
  • VBA Editing Window, Modules (HOW TO START)
  • Copy & Paste
  • Declaring Variables
  • Common Errors
  • Comparison to Recorded Macros
• Charts in VBA
• Creating your own functions in VBA

Commonly Asked Questions

• I can only return the first match with VLOOKUP. What do I do?

• Why isn’t my code running on my MAC computer?

There are many incompatibilities with MAC that Excel suffers, and certain functionalities might not exist. To solve this, use a campus PC or find an alternative available to MAC users.

• Ctrl A: Select all