The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible. What are […]

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level […]

During this introductory course on Pivot Tables, we’ll teach you the basics for working with them – in both Microsoft Excel 2010 and Excel 2013. We’ll start with some basic concepts and terminology. Then we’ll provide an easy to follow example using some fairly straightforward data and develop a pivot table and a pivot chart. […]