MENU

Fun & Interesting

10 Excel Tricks to Improve Performance - Workbook Included

TeachExcel 20,847 lượt xem 7 years ago
Video Not Working? Fix It Now

Excel File: https://www.teachexcel.com/excel-tutorial/2049/10-excel-tricks-for-formulas?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

10 Tricks in Excel to make using formulas and functions much much easier.

This includes:
Quickly entering absolute and relative cell references.
Quickly entering arguments for formulas.
Previewing formulas before entering them.
Evaluating formulas to figure out what they do.
Viewing all formulas on a worksheet.
Quickly seeing which cells and ranges are used in formulas and functions.
Copy/Pasting Values in order to free values output by formulas.
Selecting all cells in a worksheet that meet a certain criteria.
Searching for functions in Excel and easily entering new ones.
Speeding up slow worksheets due to high volumes of formulas and functions.

Make sure to leave any questions and thoughts in the comment section below the video!

TeachExcel.com

Comment