Excel-Tip-Of-The-Month is a newsletter distributed to more than 50,000 subscribers.

Dr. Isaac Gottlieb, a professor at the Fox School of Business at Temple University, is the author of Next Generation Excel: Modeling In Excel For Analysts and MBAs (For MS Windows and Mac OS) and a Microsoft MVP (Most Valuable Professional) 2014- 2016. He teaches over 3,200 students a year in his undergraduate Excel for Business Applications course and many of the graduate students attend his Excel workshops.

To subscribe, email isaacg@temple.edu

April 2018

Download Excel File

  • I love FLASH FILL
  • Status Bar
  • Tell me what you want to do
  • Autofill Date Menu
  • Data Table Example – Multiplication Table Example

March 2018

Download Excel File

  • The OR function
  • The AND function
  • TRUE and FALSE
  • The NOT Function
  • IF Function
  • IFS Function

February 2018

Download Excel File

  • Add Leading Zeros
  • CHAR Function
  • Parsing names with a formula
  • Using the Solver Part III
  • 3D SUM. Going the third dimension

January 2018

Download Excel File

  • New Bar Chart Idea
  • Hide the Gridlines
  • Using the Solver Part II
  • CTRL + Clock easy to remember shortcuts
  • Print Titles