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!


Featured Excel Content

Excel Tip
Wildcards are characters that allow you to make more robust functions, searches, and filters in Excel. You put wildcards in functions, usually in the criteria argument, and this allows you to find partial matches for words, numbers, and characters. Wildcards are used to make more sophisticated partial matches. Sections: Wildcards Question Mark Exa ...
Added: Oct 20, 2016
Excel Tip
How to make complex formulas for conditional formatting rules in Excel. This will serve as a guide to help you build the formulas that you need for conditional formatting custom rules. Sections: Make a Formula for Conditional Formatting Making Complex Formulas Notes Make a Formula for Conditional Formatting Every formula that you use for conditiona ...
Added: Oct 19, 2016
Excel Tip
How to nest IF statements inside of each other in Excel so that you can make more complex decision structures. This allows you to make a check like this: test if something is true and do x if it is true or, if it is not true, perform another check to see if something else is true and return y if it is and z if it is not. This sounds confusing thou ...
Added: Oct 18, 2016
Excel Tip
How to pass arguments and values to macros called from worksheets, buttons, and anything else from the Excel interface. This is different than passing a value from one macro to another. Sections: Create the Macro to Accept the Value Pass a Text Value to the Macro Pass a Numeric Value to the Macro Pass Multiple Values to the Macro Pass the Value of ...
Added: Oct 17, 2016
Excel Tip
This guide will show you 4 different ways to make your macros run faster and more efficiently in Excel. There are 4 main things that you can do to each macro in order to have it run faster. Sections: ScreenUpdating Calculation Events Alerts All Together Notes ScreenUpdating This is the number one way to speed up a macro. ScreenUpdating controls if ...
Added: Oct 14, 2016
Excel Tip
How to stop formulas and functions from updating in Excel when running a macro. This can save you a lot of time if you have a large or complex spreadsheet that relies on lots of formulas or cross-spreadsheet functions. Sections: Code Example Notes Code Disable Calculations Prevent Excel from updating formulas and functions automatically. This shoul ...
Added: Oct 13, 2016
Excel Tip
Create a macro that will run without triggering events, such as the Change event, or Activate event, or BeforeSave event. This allows the macro to run without causing any event-driven macros to run. Section: Code Example Notes Code Turn Events Off This prevents the event-driven macros from running. Application.EnableEvents = False Turn Alerts On T ...
Added: Oct 12, 2016
Excel Tip
Change an incorrectly formatted/input date into the proper date format for Excel. This tutorial is specific to when someone inputs a "short" date format incorrectly. Here are examples of incorrect short date formats: 20/1/2016 Day comes before month so Excel doesn't recognize it. (U.S. format) 1/20/2016 Cell is formatted as text so Excel doesn't re ...
Added: Oct 11, 2016
Excel Tip
How to stop an Excel alert window or message box from appearing while running a macro. This is particularly useful when running a macro that needs to close a workbook and you don't want the "Save" dialogue box to appear. Sections: Code Example Close Workbook Notes Code Turn Alerts Off Application.DisplayAlerts = False Turn Alerts On Application.Dis ...
Added: Oct 10, 2016
Excel Tip
Use a formula or formatting to display the current day of the week in Excel. Sections: Formula to Show Current Day of Week Formatting to Show Current Day of Week Notes Formula to Show Current Day of Week This formula will update every day to show the current day of the week. =TEXT(TODAY(),"dddd") Result: The TODAY() function returns the current day ...
Added: Oct 7, 2016
Subscribe for Free Excel tips & more!