Search TeachExcel

New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content


Excel Tip
How to change the order of the tabs in your spreadsheet. This is rather easy to do and makes your spreadsheets much easier to follow and understand.  There are two ways to change tab order in Excel, and both are explained below. Method 1 - Change Order of Tabs This is the easiest method when you have only a few tabs in the workbook. Left-click and ...
 
Excel Tip
How to automatically calculate someone's age using Excel.  This method is simple and will update every year so that you never have to manually adjust an age in Excel. This is great when you are working with employee or customer data. I'll show you two methods to do this; which one you use depends on the setup of your data. Sections: Calculate Some ...
 
Excel Tip
How to find a date that is so many days before or after a specified date, excluding weekends and any holidays. This allows you to get an accurate estimate of when work will be completed, a package delivered, invoicing, and more. To achieve this, we use the WORKDAY() function in Excel. Syntax =WORKDAY(start_date, days, [holidays]) Argument Descripti ...
 
Excel Tip
Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allows you to use your dates to perform more complicated calculations, such as working hours and compensation, scheduling, shipping, and many other types of calculations where it is important to know on what day of the week a date falls. For this, we use the WEEKDAY( ...
 
Excel Tip
How to calculate the total number of working days between two dates in Excel.  This allows you to exclude all weekends, holidays, and any other dates that you specify. This is an invaluable method to use when calculating payment schedules, shipping dates, and much more in Excel. To do this we will use the NETWORKDAYS() function. Syntax =NETWORKDAYS ...
 
Excel Tip
This allows you to make sure that there are no hidden spaces at the start or end of the text in a cell and also that there are no extra ones in the middle of the text.  In regards to extra spaces in the middle of text, it will convert all double or triple or more spaces into a single space. Though this may seem trivial, spaces around your text can ...
 
Excel Tip
How to get the last day of the month, including the date and day of week, for any date in Excel.  This method allows you to use any date and get the last day of the month for the month of that date or a future month or a month in the past.  This is very helpful when dealing with scheduling and time related scenarios in Excel. We will use the EOMONT ...
 
Excel Tip
How to print all worksheets at once from Excel. This saves you the time of having to go to each sheet individually to print. Hit Ctrl + P to get to the print screen. Click where it says Print Active Sheets and select the option Print Entire Workbook. That's it! It's as simple as that. Notes There are a lot of different printing options for Excel.  ...
 
Excel Tip
How to stop Excel from automatically changing numbers into anything other than what you typed, such as changing a fraction into a date when you enter it into a cell. Apostrophe Method Using the apostrophe is the preferred way to keep numbers looking the same after you enter them, at least as far as I am concerned.  This way, if someone changes the ...
 
Excel Tip
How to print the current date and or time on an Excel spreadsheet. This is a simple technique that allows you to display the date and or time in the footer or header of the spreadsheet without it being visible when working in Excel. Steps to Print the Date/Time in Excel Go to the View tab and click the Page Layout button. Now, you will see the spre ...
 
Excel Forum