Excel Descriptive Statistics

This Excel tutorial explains how to interpret the summary table generated from Excel Descriptive Statistics. Excel Descriptive Statistics One of the options under DATA > Data Analysis is Descriptive Statistics, which generates a statistics summary of a variable. It is very useful because it saves you a lot of time from entering a lot of formulas in order to get some basic analysis. Before using Excel Descriptive Statistics feature, you should first install Analysis Toolpak Add-Ins. As...
More

Enable and Disable Protected View in Excel

This Excel tutorial explains how to enable and disable Protected View in Excel and other Office applications. Protected View in Excel Protected View feature is used to protect your computer from virus when you try to open Excel workbook from the Internet or other unsafe locations, or open attachment in Outlook email. The protection is achieved by disabling some features and making the Workbook read only. Protected View is a feature that you can enable or disable in Option. When the Protecte...
More

Excel find the last row using Worksheet formula

This Excel tutorial explains how to find last row using Excel worksheet formula. Excel find the last row Finding the last row in Excel is very important especially for creating dynamic data Range, which can be used for setting dynamic Print Area, dynamic Data Validation list, dynamic data source for Pivot Table, etc. When you google this topic, most article talks about how to find the last row using VBA but not the non-VBA solution. In my previous post I have also detailed different way...
More

Excel set default font

This Excel tutorial demonstrates how to set default font type in Excel. Excel set default font This is a quick tutorial to show you where to set default font type in Excel. You probably need to know this after you upgrade to a new version of Excel. I will demonstrate how to do so in Excel 2013, click here for 2010 version. Click on FILE tab Click on Options on the left menu   Under the General page, you will find the default font and font size. Select the font you w...
More

Excel dynamic Data Validation list

This Excel tutorial explains how to create dynamic Data Validation list that automatically adjusts the data Range. You may also want to read: Excel Dynamic Print Area Excel dynamic data range Excel graph dynamic data range Create Excel Data Validation list Excel Data Validation list restricts users to select values from a drop down box. When the input is different from the predefined list, an error message will pop up. Before we create a dynamic Data Validation list, let's brief...
More

Excel Share Workbook

This Excel tutorial explains how to use Share Workbook function to allow multiple users to open the workbook at the same time. Excel Share Workbook Share Workbook function allows multiple users to open the workbook at the same time. Assume that we have a staff list workbook that is placed in the network share drive.   Click on REVIEW > Share Workbook   Check the box "Allow changes by more than one user at the same time. This also allows workbook merging" >...
More

Excel Compare Worksheets using Compare File

This Excel tutorial explains how to compare worksheets using Compare File function. You may also want to read: Excel VBA compare worksheets Excel Compare Worksheets using Compare File Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus (click here if you are using older version). After comparison is complete, two worksheets are compared side by si...
More

Excel protect workbook with password

This Excel tutorial explains how to protect workbook with password with VBA and without VBA. Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide worksheet with password. Hide the worksheet and add a password to unhide...
More

Excel add password to workbook

This Excel tutorial explains how to add password to workbook with VBA and without VBA. You may also want to read Add password to all Excel workbook in folder Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide w...
More

Excel add page number in footer

This Excel tutorial explains how to add page number in footer. E.g. add page number to all worksheets, add page numbers to specific worksheets. Excel add page number in footer to one worksheet Select the worksheet you want to add page number in footer Navigate to PAGE LAYOUT tab > Print Titles   Click on Header/Footer tab > select the desired Footer format > OK   To check the page number in print preview, Go to FILE > Print Make sure the Settings o...
More