Save yourself from retyping text again when you need to change between lowercase, UPPERCASE and Title Case, select a word, line or a whole paragraph and press SHiFT+F3. Did it work? Reply with your favourite Word and Outlook tips. Share this tip on your favourite...
Microsoft
Use a shortcut to scroll through Excel sheets
Sometimes, you need a good keyboard shortcut for Excel spreadsheets. When you are looking for values across multiple sheets in Excel, for instance. Use this precious shortcut instead of clicking through endless sheets with your mouse.
Learn to Automate Excel with Macros and VBA
Visual Basic for Application (VBA) is the programming language which powers Excel macros and many other Microsoft Office applications, like Word, Outlook and PowerPoint. The benefits of learning VBA are many: You will be able to automate repetitive tasks. You will...
The Excel error that changed history (and why you don’t want to be the person who done it)
Carmen Reinhart and Kenneth Rogoff made a big mistake in Excel. The two Harvard economists miscalculated that countries with public debt of 90 percent of GDP or more tend to experience a slower growth at a (negative) rate of -0.1% when actual data suggests the...
Microsoft Office 2013 – Yay or Nay?
Are you switching to Microsoft Office 2013 or thinking about switching? Here is a brief overview of the best/worst of Office 2013 based solely on my own experience. We do not offer an in-depth view of all that's new and different, just some of the top features worth...
Updated Post: Budget 2013 Universal Social Charge (US) Calculator (Excel)
Get the new calculator from this updated post #Budget2013 @OfficeCorner
Automate any spreadsheet: Excel Macros and VBA course. Dublin and nationwide.
Announcing this new course: Holy Macros! Unleash the Power of Excel with VBA (Course) Course Objectives At the end of this Excel Macros & VBA course, you will be able to: Record, edit and troubleshoot macros understand the Excel Object Model, write...
Reading List for Getting Better at VBA and Macros in Excel
After you discover the power of automating Excel, you will want to learn more about what VBA can do. So here is my selection of recommended reading and tutorials. Tutorials to deepen your knowledge of Excel VBA: http://excelvbatutor.com/vba_tutorial.html A great...
Date functions in Excel: last Monday, next Sunday, this month, this year
Understand how Excel treats dates and you will be able to create useful calculations and filters
Draw your own clipart from scratch
Learn how to use the PowerPoint shapes and drawing tools to create your own shapes, from simple to elaborate. You never need to pay for your cliparts again if you have the patience to draw your own. In this video, Diane Elkins demonstrates how to use the Freeform tool...
All about Microsoft