Welcome to My Blog
Here is where I share Tips, Tricks, Strategies, and Techniques to help you use your Microsoft Office applications to their fullest functionality.To Copy a Formula Down in Excel, Double-Click the Fill Handle
Working with large spreadsheets in Excel can be challenging, especially if you have hundreds or thousands of rows of data. Then if you need to add formulas to each of these rows, managing this task can be even more tedious. Discover the quickest and most effective method to add formulas to each row of data
[...]
In what Order, does Excel Calculate a Formula?
When you create a formula that contains several operators, Microsoft Excel performs the calculation in a specific order. This order is called Operator Precedence. Discover the Order of Operator Precedence and how to setup your formulas so that Excel performs the calculations correctly [...]
Keyboard Shortcuts to Save you Time Moving around Excel
At times, an Excel spreadsheet may be so large that it is difficult to navigate. And using the mouse for navigation may increase the time it takes to complete even the most basic tasks in Excel.
Discover keyboard shortcuts to move easily around Excel [...]
Flip or Transpose Your Excel Data
Do you want to Change your Excel Data from Rows to Columns, or vice versa?
Don't re-type your data, flip or transpose your data.
e.g. To change the Days of the Week to display horizontally instead of vertically. Discover what the steps are here [...]
