Select Page

Resources & Blog: Tutorials. Excel

Best Uses for Excel: How to Make the Most of Your Spreadsheets

Best Uses for Excel: How to Make the Most of Your Spreadsheets Learning the best uses of Excel to help you become more productive Microsoft Excel is a valuable computer spreadsheet program used for everything from personal budgets to company data management and accounting. The best uses for Excel include everything from templates to formulas, to tables and everything in between to make your data easier to manage, leverage, and utilize. Microsoft Excel is the industry leader for spreadsheet and business productivity. Excel provides a wide range of data...

read more

When is the right time to learn Visual Basic for Applications?

When is the right time to learn Visual Basic for Applications? Decide when to use the built-in Visual Basic for Applications tools or take your projects to the next level If you’ve ever tried to tackle a Microsoft Office Visual Basic for Applications (VBA) project yourself, then you know how daunting that can be.  While there are built-in Office tools to help you create macros and perform advanced data analysis, at some point you may realize that the default tools are not good enough.  By learning Visual Basic for Applications on your own, you can...

read more

From Excel Tables to PivotTables

From Excel Tables to PivotTables The evolution of Tables to PivotTables You (and, more importantly, your boss) love what you’ve created thus far in Excel.  You’ve spent hours entering your data into your worksheets, organizing the data using best practices, and creating advanced formulas to calculate what you need to see.  So, what have you learned about your data? At this point, it’s time to get involved with more Excel tools for data analysis.  As you get more creative with data analysis, you can extract useful information...

read more