These are the words Microsoft Corporate Vice President James Phillips used when describing one of the most innovative and impressive Microsoft products released in years – Power BI. What is Microsoft Power BI? I hear you ask. Well, in a nutshell, it’s an extremely powerful, yet easy to use tool that simplifies data analysis and […]
Tag Archives: Excel
20 Principles for Good Spreadsheet Practices
I recently received a link to an article from a fellow Excel fan in the UK that detailed 20 principles for good spreadsheet practices. I read through the article and I have to say they’ve done an excellent job of listing them. I am constantly asked to repair or redesign spreadsheets that adhere to few […]
Creating Pivot Tables In Excel
If you asked ten regular Excel users what the most complicated part of Excel was, nine would probably say PivotTables! It was always a source of frustration that Microsoft hid this amazingly powerful tool behind user front-ends that were unintuitive to say the least. They made a straightforward tool appear complex when it really wasn’t. […]
A Look Under The Hood of Microsoft Office 2013
Here at Dragon Corporate Training, we are working with more and more clients who are either upgrading to Microsoft Office 2013, or planning to do so soon. We met with a major municipality here in BC last week who are making the jump from Office 2007 to Office 2013 and they have been pleasantly surprised […]