Microsoft Excel is a very powerful tool that can be even more powerful and faster by using Excel shortcuts. Using Excel keyboard shortcuts allows you to edit Excel worksheets quickly, faster than just using a mouse.
Automatically updating one Excel sheet from another is a good way to reference data in Excel so there is only one location to update.
The Excel UPPER function changes a text string to and all upper case text string. The characters do not change, only the case.
The Excel LOWER function changes a text string to and all lower case text string. The characters do not change, only the case.
Learn how to count a word in Excel in a few simple steps. Excel is a great tool for working with all types of data, including text.
The Excel HOUR function returns the hour of the day, a number from 0 (12:00 AM) to 23 (11:00 PM). The HOUR function is an Excel date and time function.
Freeze Panes in Excel is a feature that can help manage a large table of data. Freeze Panes in Excel holds rows, columns, or both in place.
Pivot Tables are one of the most powerful tools in Excel. This guide will show to how to create a Pivot Table in a few simple steps.
Drop down lists are a great addition to spreadsheets when you need to limit user input to a defined set of values. This guide will show you how to create a drop down list in Excel in a few easy steps.
Learn how to extract last name in Excel in a few simple steps. A formula or text to columns can be used to extract last names in Excel.
The Excel OR function tests whether any arguments are TRUE, and returns TRUE if at least one argument is TRUE. If all arguments are FALSE the OR function will return FALSE.