Excel macros & vba courses

... by automating many of the repetitive tasks that are part of spreadsheet development. In Excel...

... 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...

...You will learn: Advanced worksheet formatting and Excel shortcuts. Using named ranges in formulae. Formula Auditing - tracking changes. 'What if' forecasting using one and two variable data tables and scenarios. Formula building. LOOKUP functions. Automatic Outline. Restricting input using...

...Presented by Robert Norgon, this online training series explores Microsoft® Excel® 2013 Pivot Tables – dynamic worksheets that can be reorganized by the user, with data generated from a database or a table... Learn about: Simulations & Solver, Excel Functions, Conditional Formatting...

... interested in solving complex business problems. We’ve established ourselves as the Excel experts in the last 9 years, and you won’t find better, or more thorough content anywhere else... Learn about: Financial Training, MS Excel, PC training...

... such as emailing Excel content...

...Microsoft Excel 2013 Essentials shows you the fundamentals of entering data and creating spreadsheets, managing lists of data, creating formulas & functions, formatting worksheets for print and electronic delivery, charting, data analysis, collaborating with others, automating tasks, and more... Learn about: Advanced Formulas, Data tables, Data analysis...

... database using Microsoft Access, create compelling visualizations and reports of your data using Microsoft Power BI and automate data tasks with VBA, this four-course bundle is for... Learn about: Microsoft Powerpoint, MS Excel, Microsoft Access...

...Stand out from the crowd by creating perfect spreadsheets quickly and cleanly in Microsoft Excel 2007, the world’s most widely-used spreadsheet software. With lessons divided into basic, intermediate and advanced chapters, this online learning cour... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...You will then be qualified to progress to the VBA course for Excel. Candidates can be directed toward the European Computer Driving License Course... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...Microsoft Office Excel 2008 is a spreadsheet application that features calculation, graphing tools, pivot tables, and more. With this Excel 2008 – Advanced training course, you’ll learn about the more advanced features of this very popular and versatile office tool... Learn about: Data TablesData Tables, Pivot Reporting, Ms Office...

...On completion of this course the user will be able to design, write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions. Suitable for: This 2-day course is aimed at experienced Excel users, preferably with some awareness...

...Master Excel completely with this comprehensive course encompassing both Excel 2010 and Excel 2013. Learn how to capture, understand and present data with this powerful application and make full use of all of the tools and functions across both editi... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

... who want to exploit the more powerful features of Excel made avai...

... is for Microsoft Office Excel 2008 for... Learn about: Office IT, Tables & Formatting, Excel Formulas...

...Students will probably get the most out of this course if they want to learn the skills and concepts necessary to work with advanced features of Excel 2000. Students should have a basic knowledge of the concepts involved in using Excel 2000. For example, they should be familiar with data types...

... level so you can transform everyday spreadsheets into elegant and powerful business assets. In this Excel 2010: Advanced series, new and longtime Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing... Learn about: Microsoft Excel, IT Auditing, MS Excel...

... in Microsoft Excel...

...In this course you will learn about Data Mining using PIVOT Tables Converting Data into Tabular format, Web Data using Macro, sharing functions, recording Macro efficiency,VBA Charts... Learn about: Conditional Formatting, Data Mining, Simulations & Solver...