Excel macros courses

...Academy instructors have undertaken the MOS programme, have several years teaching experience and have achieved MOS Master Instructor Certification.To become a Microsoft Office Specialist (MOS) in Microsoft Excel Expert 2003 an individual has to demonstrate proficient use of the application during...

...Suitable for: This course is for experienced users of Microsoft Excel who need to automate repetitive tasks and write their own Macros or formulas. You must be an experienced user of Excel to attend this course...

...create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables. manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates...

...Training Course Outline: Creating Record Macros Recording a Macro Running a Macro Running a Macro from the Macros Dialog Box Creating a Short-cut...

...; structure data efficiently in order to create Dashboards; use advanced charting techniques to visualise data and create interactive dashboards; understand the use of basic macros/VBA for automation. Target Audience Designed for users who need to interpret and communicate large quantities of information... Learn about: Microsoft Excel, Microsoft Office, MS Excel...

...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: Microsoft Excel, MS Excel, Microsoft excel training...

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

... Macros...

...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: Visual Basic, Microsoft Office, Microsoft Excel...

...The ECDL Advanced Excel course allows you to continue to progress further and test your computing skills at a higher level. The ECDL Advanced certificate is a valuable addition to any business with skilled, qualified staff. The ECDL Advanced Excel Course helps further develop your skills...

... out relevant information from large data sets? This is what our Excel BI Reporting and Charting course is designed to help you with: to show you a range of techniques that will assist you to get at the information you are interested in, quickly. We start by looking at how to get data into Excel from a number... Learn about: Business Intelligence, MS Excel, Microsoft excel training...

...On completion of this course delegates will be able to: Automate workbooks with recorded macros. View and edit VBA code using the Visual Basic Editor. Create shortcuts to run macros. Create VBA code/macros from scratch. Create decision making code. Create Loops. Understand and Use data variables...

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

..., lists of data, forms, charts, pivot tables and macros... Learn about: Data Entry Forms, IT Auditing, Database functions...

... How To:Leverage features of Microsoft Excel to facilitate business decisionsDevelop intelligent worksheets to quickly identify KPIsPerform "what-if" analyses for developing budget and project plansSummarise and analyse large amounts of data using PivotTables and Excel featuresAutomate Excel... Learn about: Microsoft excel training, Financial Training, Microsoft Excel...

... with our VBA course to automate tasks in Microsoft Excel that are performed frequently... Learn about: PC training, Design techniques, Microsoft Excel...

... and be able to create a simple Macro. Suitable for: Designed for existing users of Excel who wish to progress their Excel skills and benefit from it's powerful data analysis tools... Learn about: Excel 2010, Excel 2013, Excel 2016...

... out relevant information from large data sets? This is what our Excel BI Reporting and Charting course is designed to help you with: to show you a range of techniques that will assist you to get at the information you are interested in, quickly. We start by looking at how to get data into Excel from a number... Learn about: Microsoft Excel, Microsoft excel training, Business Intelligence...

...Are you tired of struggling with Microsoft Excel? Do you want to use Excel with ease to solve complex problems, automate spreadsheets, and master graphs for presentations instead of pulling your hair out? We can help! Once you’ve got the Excel covered, take your skills to the next level... Learn about: IT Project Management, PC training, Microsoft excel training...