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 6 of 13« First«...567...10...»Last »
Making data consumable by those who need to use it can sometimes take the form of charts. But, how many workbooks and worksheets do you need to open and scan to find them? A chart dashboard can be the solution.
Q. I want to use Pivot Tables in my Excel dashboard, but I don’t want the viewer to easily change anything except the Report Filter selection. How do I do that?
Q. How can I avoid changing the data source each time my source data grows?
These tips address runaway worksheets, pesky green triangles and cell navigation slogs.
Q. I have workbooks with a lot of worksheets. I don’t need the horizontal scroll bar. I’d rather see more worksheets. Can I get rid of it?
How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?
Say you’ve created this great interactive tool in Excel. The problem is it still looks too much like a spreadsheet. There are a few things you can do to make it look less grid-like.
Say you’re filtering a list of your 55,000 employees, each with their own employee number. You need the records that have either of two criteria in one column and either of three criteria in another column. You want to filter for more than two “and” criteria. When Filter doesn’t give you exactly what you need, there are a few options to try.
Pop open the Format Cells dialog box with all the familiar tabs by using Ctrl+1 ... Change the font to Strikethrough with the Ctrl+5 shortcut ... Hide a column without selecting it by hitting Ctrl+0.
You’ve made that giant leap to using Pivot Tables in Excel. Congratulations! Now it’s time to gnash some numbers.