Sorting and Filtering Data With Excel
There are many built-in Excel tools to help with data management and the sorting and filtering features are among the best. The filter tool gives…
excel tools
Essential Excel Functions: How to Use CONCATENATE
Excel possess many formulas and functions to help you perform essential tasks. The CONCATENATE function is one of most useful. It allows you to combine…
The Excel Fill Handle: How to Quickly Add Data
The Excel fill handle is one of the most convenient tools available to enter data quickly and easily. Using the fill handle, you can enter…
Removing Duplicates in Excel: Quick How-to Guide
This Excel tip from Learn Excel Now is on removing duplicates in Excel. The request is directly from a Learn Excel Now fan who asked…
Creating Excel Tables: Quick Tip to Get Up-to-Speed
Excel provides you with many preset formatting options that you simply need to click to activate. One of the most common and most useful is…
Setting Dates in Excel: Repeating, Consecutive & Custom
Ever been frustrated by repeatedly typing in dates in Excel? You know there is a way to make dates appear in order or repeat but…
Hyperlinking In Excel: To the Web or to Another Worksheet
You might already know how to hyperlink a cell to external sources, namely to the web. In case you don’t, here is a quick tutorial…
Quick and Easy Math Formulas in Excel: Get Started Now
One of the most common uses for Excel is computing large amounts of complex data. Knowing the best formulas to use allows you to crunch…
Wrapping Text in Excel: Formatting Foundations
Have you ever had so much data in one cell that that it spills over to the next cell or just disappears? And you don’t…
Excel Essentials: How to Remove Duplicates in Excel – Video
Clean, readable data makes Excel much easier to use. A common struggle is how to remove duplicates in Excel. Having too many duplicates causes inaccuracies…