Work smarter, not harder! Excel Tip – How many times have you created a spreadsheet and then realized after the fact that you should have used the current column headings as row headings and vice versa? I think it has probably happened…
Work smarter, not harder! Excel Tip – Scrolling through a large spreadsheet can be overwhelming. If you’ve ever gotten lost because you don’t know which column or row you are looking at, you know what I’m talking about. Luckily, there is…
Work smarter, not harder! Microsoft Excel– As an Excel user, do you want a quick way to change a relative cell reference to an absolute or mixed cell reference? Instead of manually adding dollar signs ($$) to a formula to…
Work smarter, not harder! Excel Tip – AutoSum Multiple Rows and Columns Many Excel users are familiar with the AutoSum feature but may not realize the power behind the button! Use this tip to sum multiple rows and columns with a…
Work smarter, not harder! Excel tip – filter records for unique values and copy to a different worksheet. Use this tip when you have a list of records containing duplicates and want to copy the unique records to another worksheet in the…