- Charts in excel
- Axis formatting
- Use excel to create histogram
- Add a secondary axis in excel
- Highlighting data point in scatter and line charts
- Error bars
Data Analysis in Excel
- 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