Excel Tips and Tricks – Basics, Data, Formatting, and Wrangling
As stated on the previous page, MS Excel offers more potential than you can imagine. Bright Hub contains more than 277 Excel tips and tricks written by Bill Jelen. These articles form part of his book “Learn Excel with Mr. Excel." We have laid out these articles in four parts for easier understanding: Excel Basics; Dealing with Data; Dealing with Formatting; and Wrangling.
If you are new to MS Excel, you might want to look at the Basics of Excel. The article compilation also aims to empower intermediate and expert users with tips and tricks to understand the MS Excel environment so that they can save time. It includes articles on shortcuts to Excel commands; how to open a particular workbook each time you start MS Excel; using macros to automate your tasks and many more. The Excel Environment not only helps you explore Excel completely, it also helps you save time by working faster. Please note that some of these articles refer to menus of Excel 2003 or previous versions. However, except for the articles dealing with Excel menus (such as opening full menus each time); others are valid for Excel 2007 and Excel 2010 as well.
The section, “Calculating with Excel," contains approximately 91 Excel tips and tricks that help with calculations. It also covers topics such as Playing Dice Games with Excel; Play Craps with Excel; Create Random Numbers; Calculate Loan Payments; How to Figure out Lottery Probability and more. Check out the complete list and access the articles at Calculating with Excel.
The third section offers tips and tricks for wrangling data in Excel. This section contains articles covering topics as simple as How to Sort your Data to Understanding Pivot Tables. It also includes articles on topics such as My Manager wants Subtotals above Data; General Protection Faults; Adding Blank Line after Every Subtotal; and more. To access the table of contents and the articles, please read Wrangling Data.
The final section of the collection on Excel tips and tricks covers formatting. Some of the topics under this section were mentioned in the previous page. Check out the entire list of topics and links to articles at Formatting Tips from Mr. Excel.
The four sections contain 277 Excel tips and tricks for you to master MS Excel and make the most out of it. Please let us know if you benefited with this tutorial using our comments section.