Excel Resources

Guide on how to Recover Document in Excel. Here, we discuss how to enable AutoSave option and recover documents in Excel, which we did not save previously.

Guide to the Maximum Number of Rows in Excel. Here we discuss how to find the last row and restrict user action to specific rows in Excel.

Guide to Recover Unsaved Excel Files. Here, we discuss how to enable auto recover options, recover unsaved Excel files & workbooks, with examples.

Guide to Format Cell in Excel. Here we discuss top 6 tips to format cells in excel – Date, Time, Date/Time Together, format painter, etc with examples.

Guide to Z Test in Excel. Here we will learn how to perform Z test in excel using its formula along with examples and with downloadable template

Guide to Leading Zeros in Excel. Here we discuss how to add Leading Zeros in Excel using Text & Concatenate Function with examples.

Guide to Advanced Excel Formulas. Here, we discuss formulas, VLOOKUP, OFFSET, TRIM, CONCATENATE, INDEX, examples, downloadable excel template.

Guide to Insert Comments in Excel. Here we insert/delete, hide/show, edit comment for cells, shortcut, Examples, downloadable excel template.

Guide to Excel Extensions. Here we will discuss the top file formats including XLSX, XLSM, XLSB, XLS & XLAM, its key features and applications.

Guide to scroll bars in excel. Here we discuss how to create scroll bars in excel along with example and downloadable excel templates.