Excel macros & vba courses

...To gain a better understanding of Microsoft Excel. To save time by using shortcuts? Suitable for: All Excel users as the content can be customised to your needs. You can use the module list in the course description as a menu...

...If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create...

...Microsoft® Office Excel® 2011 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. Learn the basics of using Excel in this thorough introductory-level tutorial training series, Excel 2011- Intro... Learn about: Formulas And Functions, MS Excel, Data tables...

...Suitable for Advanced Excel users. If you regularly have to carry out procedures for your company or job. Learn how procedures can be automated using Macros and enhanced with... Learn about: Microsoft Excel, VAT management, Visual Basic training...

...At work, are you required to use the Microsoft Office 2016 suite, including Word, Excel, PowerPoint, Access, and Outlook? If so, then why not master both the basic and advanced features of these in order to fully benefit your career. Whether you’re a Microsoft Office 2016 beginner or otherwise... Learn about: Ms PowerPoint, Microsoft Office, Ms Office...

...If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create...

...Microsoft® Excel® boasts a robust collection of statistical functions. This Excel 2016 for PC – Statistical Analysis online training series will demonstrate some of these functions from the simple to the complex, as well as how to perform more complex analysis by activating Excel’s Data Analysis... Learn about: Tables & Formatting, Data analysis, Pivot tables...

... across applications and manage files and folders using VBA. Learning Objectives Delegates will learn how to Understand MS Office Object Hierarchies and the Object BrowserWork within an MS Office ApplicationUse User Defined Types, Classes and ArraysFile and Folder Management using VBAInteraction between... Learn about: Microsoft Office, Office IT, Ms Office...

... and editing macros, and utilising advanced formulas, as well as broader business administration and IT skills... Learn about: Microsoft Excel, Microsoft excel training, Excel Interface...

... In A Workgroup · Sharing Your Projects · Using Routing Slips · Receiving A Routed Project Project VBA · Using Existing Macros · Examining The Macro Code...

... course is for Microsoft Office Excel 2016 for Windows... Learn about: Tables & Formatting, Conditional Formatting, Data tables...

... across applications and manage files and folders using VBA. Learning Objectives Delegates will learn how to Understand MS Office Object Hierarchies and the Object BrowserWork within an MS Office ApplicationUse User Defined Types, Classes and ArraysFile and Folder Management using VBAInteraction between... Learn about: Office IT, Ms Office, Microsoft Office...

... with some knowledge of Excel, who are comfortable with its basic functionality but also who know there is a lot more that could be done with this powerful tool...

... In A Workgroup · Sharing Your Projects · Using Routing Slips · Receiving A Routed Project Project VBA · Using Existing Macros · Examining The Macro Code...

...In this Excel 2016 for PC – Frequently Used Formulas & Functions training, we’ll cover how to set up formulas to ensure you’re using all the features Microsoft® Excel® 2016 has to offer.... Learn about: VBA & Macros, Advanced Charting, Conditional Formatting...

... differences between versions. Note that this course will normally be delivered on PCs with Office 2016 installed. Learning Objectives Record and edit a MacroUse different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or ButtonsUse... Learn about: Office IT, Visual Basic training, Ms Office...

... trying to figure them out Increase interactivity by automating your spreadsheets with macros and VBA Solve complex problems with superpower functions... Learn about: Ms Office, Microsoft excel training, Microsoft Office...

... of microsoft excel. Suitable for: no previous programming skills are necessary, although a good working knowledge of excel is an advantage including using some functions...

...In this Excel 2011 – Advanced training course, you’ll learn complex techniques such as how to link and consolidate data within a single workbook or between multiple workbooks, use Goal Seek and Scenarios, protect your data, and share Excel data with Microsoft Word. By the time you’ve completed... Learn about: Pivot Reporting, Tables & Formatting, Simulations & Solver...