View all the stats behind that Excel workbook To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Pat Schober February 1, 2016
Visualize data trends with the ‘Quick Analysis’ feature To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick June 4, 2018
Wait! Before you clear that cell, do this To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Pat Schober September 4, 2015
Want better search results? Use Excel’s wildcard characters To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick March 26, 2018
Want check marks in Excel? Easiest ways to get ’em To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Pat Schober April 10, 2017
Want to change a cell while printing? Use this trick To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick March 20, 2017
Want to draw and highlight in Excel? Here’s how To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Pat Schober May 22, 2017
Want to ensure Excel data stays current? Here’s how To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick August 1, 2016
Want to hide a few rows or columns? Here are 2 options To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick July 2, 2018
Want to safeguard cells with formulas? Here’s how To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick May 13, 2019
Want to work on two parts of the same workbook? Here’s how To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick January 22, 2018
What makes up that formula? These arrows will show you To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick May 28, 2018
What’s the difference between Excel’s VLOOKUP and XLOOKUP functions? To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Brian Bingaman October 17, 2022
What’s the purpose of ‘Wrap Text’ and ‘Merge & Center’ in Excel? To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Brian Bingaman August 9, 2023
When printing spreadsheets, add the header to every page To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick November 6, 2017
Which cells contain formulas? This shortcut finds them in a snap To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cfo-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Pedrick March 27, 2017