Excel Training

Our Microsoft Excel training helps you learn Microsoft Excel and the many Microsoft Excel tips available.

With our Microsoft Excel help, you’ll unlock the power of this resource, and learn excel from the bottom up. Benefit from the Excel tips provided by Business Management Daily’s team of experts.

Page 1 of 1212310...Last »
You can filter for all #N/A results, but can you also highlight them with conditional formatting? You have to use the ISNA function, which tests a cell for that result.
Q. Is it really worth going to Excel 2013?
Q. Is there an easier way to create a formula across work sheets than clicking on each cell you want to add to the formula?
VLookUp is a powerful and useful function in Excel. It allows you to look up a value in a list and return any column from the look-up column, left. But what if your look-up column isn’t the first one?
The ability to crunch large datasets and squeeze meaningful decision support data out of it is in demand. Microsoft, in Excel 2010, included the ability to install a free add-in called PowerPivot. PowerPivot provided the sought-after ability to analyze multiple-related datasets in the same Pivot Table.
The way you set up a workbook today could either save you hours or cost you hours and hours of frustration later.
Insert the default chart on the same worksheet as the data you’ve selected ... Stop squinting at those little filter arrows ... Close Excel the easy way.
If your fiscal year isn’t January through December, you may run into issues with date functionality in Excel.
Naming ranges in Excel can make anything from formulas to dashboards easier to build and data easier to find.
Under the heading of “Great Functions I Never Knew,” is the AGGREGATE function.
Page 1 of 1212310...Last »