Advanced excel courses

... a conditional filter with AutoFilter Using the Top 10 AutoFilter Removing all AutoFilters ADVANCED FILTERS Using Advanced Filters Removing all Advanced Filters...

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

...Course Outcome: Participants will be able to use Excel to present information in different applications. They will be able to work more extensively with formula and charts...

...Suitable for: Our 1 day Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel... Learn about: Microsoft Office...

...To introduce more advanced Excel features...

...You’ve completed the beginner course in VBA, or have some experience. Now challenge yourself with the next step. Advanced VBA is a learner-friendly course that takes you through more powerful features, expanding the possibilities of what you can make VBA do for you... Learn about: Excel Events, Excel Interface, VBA Language...

...Course review: Will cover: 1. Basic Excel Opitions 2. Groupings 3. Pivot tables 4. Pivot table charts 5. Hyperlinks 6. V lookups/ H lookups 7.Excel...

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

...In this webinar speaker David will explain you how to create dynamic financial statements for any month of the year on a single worksheet, He also demonstrates effective ways you can export data from your accounting package, thereby allowing you to create a "set-and-forget" link to your Excel data... Learn about: MS Excel, Financial Training...

...We will be in touch with you knowing your requirement and will design a course outlines after understanding your needs... Learn about: Financial Modelling, Financial Training, MS Excel...

...Microsoft Project is a useful project planning package designed to assist you in creating, maintaining and tracking your plans. This advanced Microsoft Project course offers an in-depth explanation of this extensively used project management package. This Microsoft Project training course by Uplatz... Learn about: Resource Leveling, Microsoft Project, Project portfolio management...

...There are 4 advanced ECDL modules: Word Processing, Spreadsheet, Database and Presentations. Each module is independent of the other modules and there is a separate certificate for each module. I tis assumed that the students who study these modules will already have acquired the skills...

...Become fully proficient with Microsoft VBA Programming. Individuals will be able to make use of the most powerful features of Microsoft Excel available through programming VBA code. Some of topics covered include macros, writing/editing code, variables, objects, properties and methods, control... Learn about: Excel Variables, MS Excel, Excel Objects...

..., 2010 or 2013 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course. Maximum class size for Microsoft Excel courses is 8 delegates, which ensures... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...The course will be split into a mix of revising some intermediate/advanced excel skills that data analysts would need to demonstrate, before applying... Learn about: MS Excel...

...Using an intuitive blend of instructor-led videos, hands-on exercises and interactive quizzes the Microsoft Excel 2010 Online Training course is delivered online via the learning platform. This self-study approach means that students can work at thei... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

... sorting, filtering, visual analysis, Data Tables, data connections, the Data Model, PivotTables, Power Query and PowerPivot. *Some of the tools and features are only available in Microsoft Excel 2013 Professional and Pro Plus and include add-ins. This course is not suitable for anyone using Microsoft... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...This Microsoft Excel 2010/2013 Introduction course is suitable for complete beginners to Microsoft Excel. Excel is a spreadsheet application that can also be described as a two-dimensional database (in other words it’s not relational like Access). On a basic level it can be used to store... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Using a mixture of expert instruction, hands-on exercises and interactive quizzes the Microsoft Excel 2010 Online Training course is delivered online via the learning platform. This self-study approach allows students to work at their own pace, as an... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...