We have condensed the essence of  Excel Syntax , Shortcuts &  formula solutions  for common Excel  situations  down into  a one page  ” high resolution”  “fully expandable” image.  So now all the solutions  are at your fingertips when you need them.


Solutions to Problems like:

  • Formula for creating a running total.
  • Formula to highlight values in range 1 but not in range 2 using Conditional Formatting.
  • Formula to give a unique identifier to similar records in list.
  • Important syntax like creating a Absolute Table column reference.
  • Top 25 Keyboard shortcuts in Excel
  • Formula to calculate and apply a % Increase.
  • Formula  to calculate percentage change.
  • Proper syntax for using dates in a conditional Functions
  • Why are certain errors happening and how to fix them
  • How to  use the XLOOKUP to return multiple columns or rows:
  • How to use XLOOKUP to get last occurrence of a value
  • Adding values that fall between two dates.
  • A Lookup formula that allows for new rows and columns to be added.
  • ..and hundred more solutions  like the above.

Ideal for saving to your Laptop, Table or Smart Phone for Quick Reference when you need them or just print it out.

To save image, right click on the image  above and choose ‘save link as’

To download  a print friendly version in PDF Format :   Download  Here

Share this Image On Your Site