Excel Tutorials (Blog)

Keyboard Shortcuts, Tips & Shortcuts

5 Keyboard Shortcuts to Paste Values in Excel

February 14, 2019

94 comments

Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & Shortcuts

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

10 comments

Macros & VBA

How to Create Macro Buttons in Excel Worksheets

January 23, 2019

25 comments

Macros & VBA

VBA Macro to Delete Rows Based on Cell Values

January 17, 2019

60 comments

Macros & VBA

How to Use VBA Macros to Copy Data to Another Workbook

January 9, 2019

209 comments

Tips, Tips & Shortcuts

Tips for Split Screen in Windows & Mac

January 3, 2019

35 comments

Pivot Tables

How to Apply Conditional Formatting to Pivot Tables

December 12, 2018

25 comments

Power BI, Power Pivot/Query/BI

How to Change the Page Zoom and Text Size in Power BI Desktop

December 5, 2018

12 comments

Charts & Dashboards

Column Chart That Displays Percentage Change or Variance

November 1, 2018

51 comments