13
VBA Macro to Delete Rows Based on Cell Values
Bottom Line: Learn how to use VBA macros to delete rows based on cell values or conditions. Includes video tutorial and sample code.
Skill Level: Intermediate
Continue reading
37
How to Use VBA Macros to Copy Data to Another Workbook
Bottom Line: Learn how to use VBA macros to copy & paste data from one Excel workbook to another, including adding data to the bottom of an existing range or replacing data.
Skill Level: Intermediate
Continue reading 25
Tips for Split Screen in Windows & Mac
Bottom line: Learn how to enable split screen view in Windows & Mac. I share time saving tips and keyboard shortcuts for working in multiple windows.
Skill level: Beginner
Continue reading 12
How to Apply Conditional Formatting to Pivot Tables
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
4
How to Change the Page Zoom and Text Size in Power BI Desktop
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
23
When to Use Pie Charts – Best Practices
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
28
Column Chart That Displays Percentage Change or Variance
Bottom line: Learn how to create a column chart that displays the percentage change or variance between the columns.
Skill level: Intermediate
13
7 Shortcuts for Working with Worksheet Tabs in Excel
Bottom line: Learn time saving tips and shortcuts for selecting and copying worksheet tabs. Includes a few simple VBA macros.
Skill level: Beginner
Create Keyboard Shortcuts to Select the First or Last Sheet in Excel
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
9
How to Copy or Import VBA Code to Another Workbook
Bottom Line: Learn how to insert VBA code into your worksheets using four different techniques.
Skill Level: Beginner