Author Archives: Jon Acampora
Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me
Bottom Line: Learn how to apply conditional formatting to pivot tables so that the formats are dynamically reapplied as the pivot table is changed, filtered, or updated.
Skill Level: Intermediate
Bottom line: Is the font too small and difficult to read in your reports? In this post & video I share tips for changing the page zoom and text size in your Power BI charts & visuals.
Skill level: Beginner
Bottom Line: This post explains best practices for using pie charts in your reports and dashboards based on common data visualization principles. You will also learn techniques for picking the best slice of pizza/pie. 🙂
Skill level: Beginner
Bottom line: Learn how to create a column chart that displays the percentage change or variance between the columns.
Skill level: Intermediate
Bottom line: Learn time saving tips and shortcuts for selecting and copying worksheet tabs. Includes a few simple VBA macros.
Skill level: Beginner
Bottom line: Learn how to create a keyboard shortcut to select the first or last sheet in Excel. There is no dedicated shortcut for this, so this solution uses a macro.
Skill level: Intermediate
Bottom Line: Learn how to insert VBA code into your worksheets using four different techniques.
Skill Level: Beginner
Bottom Line: Learn about the new Dynamic Array functions and formulas that will eventually replace the Ctrl+Shift+Enter array formulas.
Skill Level: Beginner
Bottom Line: Learn to create a Table of Contents sheet that automatically updates whenever changes are made to sheets in an Excel workbook.
Skill Level: Intermediate
Bottom Line: Learn how to create simple macro buttons that users can click to instantly add or remove fields to Excel pivot tables.
Skill Level: Intermediate
