Excel macros courses

... in Excel... Learn about: Advanced Formulas, Pivot Reporting, Tables & Formatting...

...In this Excel 2016 for PC – Charting online training series, you’ll learn how to harness Microsoft® Excel® 2016’s charting capabilities so you can effectively compare data and communicate your information.... Learn about: PC training, Excel Productivity, Tables & Formatting...

...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: MS Excel, Simulations & Solver, VBA & Macro...

...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: Pivot Reporting, Conditional Formatting, Data tables...

... worksheet data, perform advanced data operations, data considerations, filters and advanced Pivot Table techniques, macros, and much more... Learn about: Data validation, Data Operations, Analyse Data...

... charts and graphs, showcasing basic and complex trends, and learning the difference between data, relationships and charts. The Microsoft Excel 2010 Advanced course will give insight into Excel tools whether it is about setting up live charts, learning how to use Pivot Charts and Tables and how to... Learn about: Logical and Statistical Functions, Advanced Data Management, Lookups and Data Tables...

...This Advanced Microsoft Excel 2013 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

.... Level II Manipulating data Working with charts Working with pivot table ’What if’ analysis Level III Macros Printing Excel files Managing Excel files... Learn about: MS Excel, Outlining data, Excel Formula...

... is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature. Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money... Learn about: Object-oriented programming, Visual Basic training, Microsoft Excel...

... and macros, and understand how to streamline your next data analysis project. Our courses couldn’t be more convenient, the course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate... Learn about: MS Excel, Executive Assistant, Microsoft excel training...

..."This excellent Excel 2010: Advanced course will get you up to speed with Excel 2010, whether you’re an intermediate user, or you just need to get to know the advanced features of Excel 2010, there is something for you to learn. The course will teach you to take core skills to the next level... Learn about: PA professionals, MS Excel, Business Ownership...

...This course aims to give delegates an in-depth knowledge of Excel 2003 features... Learn about: MS Excel, Lookup functions, Microsoft excel training...

... 5.2 - Form Controls Section 6: Streamlining workflow Unit 6.1 - Modal, Dialogs, and Macros Unit 6.2 - Web App Basics Unit 6.3 - Exporting Unit... Learn about: Microsoft Access, Access Options, Key Tips...

...This introductory Excel VBA Training Course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment. Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its... Learn about: Adding comments, Visual Basic, Targetting cells...

...In this Excel 2013 – Protecting Your Spreadsheets online course, you’ll learn how to protect your Excel cells, worksheets, and workbooks in Microsoft® Excel® 2013.... Learn about: VBA & Macros, Pivot tables, MS Excel...

...This Excel 2016 for PC – Pivot Tables online training series explores Excel® 2016 Pivot Tables – dynamic worksheets that can be reorganized by the user, with data generated from a database or a table.... Learn about: MS Excel, Advanced Charting, Tables & Formatting...

...This Excel 2016 for PC – Evaluating Data online training series focuses on how to create data validation rules when entering data into your sheet and also to create conditional formatting to help visually analyze data that has already been inputted into the sheet... Learn about: Data validation, Pivot Reporting, MS Excel...

...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: Pivot Reporting, MS Excel, Tables & Formatting...

...This course aims to give delegates an in-depth knowledge of Excel 2007 features... Learn about: Microsoft Excel, Microsoft excel training, Goal seek...

...Dive deeper into Microsoft access with our Advanced Microsoft Access course. With our advanced course you’ll learn how to automate tasks to save you time, how to apply advanced techniques such as macros and VBAs and overall Access best practice... Learn about: Microsoft Access, Web Apps, Splitting a Database...