Excel

Sep 10th 2015
Excel

Five Frequent Frustrations in Microsoft Excel

Feb 27th 2018
0
Spreadsheets and graphs on a desk

How to Set Cloud-Based Reports to Open in Excel

Jan 30th 2018
0
Spreadsheets and graphs on a desk
Clearing the Decks

How to Use Excel to File Form 1040 for 2017 Taxes

Oct 31st 2017
1
Spreadsheets and graphs on a desk

Vanishing Excel Features and How to Handle Them

Jun 30th 2017
0
Spreadsheets and graphs on a desk

2 Ways to Disable Excel’s Pivot Table Drill-Down

Jun 23rd 2017
1
Spreadsheets and graphs on a desk

How to Deal With Excel’s New Persistent Clipboard

Trending

Oct 20th 2017
0
Spreadsheets and graphs on a desk

How to 'Heat Map' Columns of Numbers in Excel

Popular resources

Sep 21st 2017
1

Excel Tip: How to Copy 'Visible' Cells Only

Here's a convenient Excel tip that I hope you can use! Often at work I would find myself filtering a spreadsheet to show only the specific...
Sep 5th 2017
1

How Excel Pivot Tables Can Assign Random Numbers

Periodically you may have a need to assign random numbers to an employee list, such as for raffle drawings or drug testing. In this article...
Aug 2nd 2017
0

Troubleshooting When VLOOKUP Function Returns #N/A

Look-up functions such as VLOOKUP can be a godsend in Excel by improving spreadsheet integrity and efficiency. I’ve written about the...
Jul 26th 2017
1

Dealing With Office 365’s Frequent Builds and Bugs

Historically, major changes to Microsoft Excel would arrive every three years or so, but since then everyone using it would say Excel 2007...
May 30th 2017
1
Spreadsheets and graphs on a desk

Filtering Grand Totals in Excel Pivot Tables

May 23rd 2017
0
Spreadsheets and graphs on a desk

How to Recover Damaged Excel Workbooks

Apr 5th 2017
2
Spreadsheets and graphs on a desk

Displaying Decimal Places in Excel: Part 3

Mar 13th 2017
0
Spreadsheets and graphs on a desk

How to Reset an Excel Spreadsheet for Data Entry

Mar 2nd 2017
2
Spreadsheets and graphs on a desk

Key Shortcuts to Use Within Excel Worksheets

Feb 10th 2017
0
Spreadsheets and graphs on a desk

3 Approaches for Counting Data Instances in Excel

Feb 1st 2017
1
Spreadsheets and graphs on a desk

Dealing with Grand Totals in Excel Pivot Tables

Jan 13th 2017
2
Spreadsheets and graphs on a desk
Prepping for Busy Season

How to Use Excel 2016 to File Form 1040

Jan 3rd 2017
0
Spreadsheets and graphs on a desk

Slipstreamed Excel 2016 Features Pose Challenges

Nov 9th 2016
1
Spreadsheets and graphs on a desk

How to Skirt the 255 Character Limit Within Excel

Oct 31st 2016
0
Spreadsheets and graphs on a desk

Copying and Pasting Column Widths in Excel

Sep 23rd 2016
0
Spreadsheets and graphs on a desk

An Easier Way to Open CSV Files in Excel