‘Which cells are impacting this one?’ A quick visual tool To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Pat Schober April 25, 2016
‘Consolidate’ in Excel for a big-picture look at expenses To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans December 22, 2017
‘How can I stop Excel from deleting my leading zeros?’ To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans August 11, 2017
‘How many days until that payment’s due?’ Tracking dates 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, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans February 13, 2017
‘What does that formula mean?’ Here’s how to break it down To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans April 30, 2018
‘What’s this formula for?’ Add comments to keep it all straight To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans September 18, 2017
‘Where are the formulas?’ This will bring ’em out of hiding To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans June 11, 2018
2 autofill tricks to organize dates and deadlines quicker To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans October 8, 2018
2 savvy semicolon shortcuts for A/P To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans December 17, 2018
2 shortcuts to add and remove cell borders To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans April 22, 2019
2 ways to display cell comments on printouts To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans September 24, 2018
2 ways to quickly copy and paste your row heights To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Pat Schober January 9, 2017
3 different ways to password protect data 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, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans January 21, 2019
3 quick ways to spice up your Excel charts To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans October 16, 2017
4 formatting shortcuts to speed up your spreadsheet work To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans April 23, 2018
6 savvy shortcuts to format your data To access this content, you must purchase Insider Membership – Membership, Annually, Premium, Web-free-trial-cc, Insider Membership, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-2, Insider Membership – Membership, Annually, Premium, Cca-print-pub-sub-tier-1 or Insider Membership – Membership, Annually, Free, Tm-free-trial-no-cc. Click to continue » by Alyssa Evans January 8, 2018