• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

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 3 of 712345...Last »
Q. What is a circular cell reference and how can I prevent them?
Data doesn’t always show up in your spreadsheet the way you need it. Here are four common data anomalies and suggestions on how to deal with them.
Q. I keep getting endless pound signs (#) in my cells. What am I doing wrong?
There may be a few reasons for this. One frequently occurring reason is formulas, which result in blank cell values ...
Q: 2010/2013 new add-in: What is PowerPivot?
Track changes in Excel like the same operation you’re familiar with in Word. On the Review tab, Changes group, click Track Changes and choose Highlight Changes...
Create a new work sheet to the right of the active work sheet with Shift+F11 ... Enlarge your screen real estate quickly by collapsing the ribbon to only tabs by selecting Ctrl+F1 ... Locate or quickly clear all cells with comments using Ctrl+Shift+O.
Q. Can I change the default for the way Excel charts are pasted in PowerPoint slides?
Improve your Microsoft Excel skills and build better spreadsheets with these tips from OfficeTeam.
While the new Excel has some high-powered features for expert data crunchers, there are plenty of cool tools for everyone.
Slicers and Sparklines offer you new ways to filter reports and embed small graphs into your data.
Did you know that you can sort from left to right, and not just top to bottom?
Have you ever created your own nightmare by linking work sheets? Your workbook has nowhere to grow. Error messages pop up unexpectedly. And troubleshooting becomes an exercise in terror. Try these techniques to create links between work sheets easily and keep your workbook nimble.
Q. ZIP codes with leading zeroes don’t come over correctly in a mail merge. Formatted using the Special format, ZIP Code doesn’t work. What can I do to fix this?
For character length limits, such as the 140 limit in Twitter, try using the LEN function to ensure your post will be suitable for the target ...
Q. How can I easily make all my columns the same size without disturbing hidden columns?
Counting down to a deadline? Use the TODAY() function to automatically tell you how many days until your goal date.
Q. I want to look up from one column where the data is combined (ABC-123) to another which is separate (A1 =ABC col B1=123). Can I do this with a VLookUp?
Q. I keep getting #### signs in Excel, no matter how wide I make the column. What is happening?
Do they know what to answer? This is common when you send workbooks to third parties with formulas linking to other workbooks.
Page 3 of 712345...Last »