PC Applications inhouse

...getting started with power query; query basics; combining data; transforming data columns; transforming rows of data; handling power query output... Learn about: MS Excel, Excel Power Query training, Excel Power Query in-house training...

...and audit spreadsheets in a short space of time. This course is suitable for existing users of Excel who want to gain further in-depth knowledge on...

...and amending named ranges Using named cells/ranges in formulae Named ranges as a navigation aid Conditional Functions Benefits and purpose If Statements Nested If...

...DESCRIPTION This course takes the beginner into more of the time saving features of Excel, exploring many different types of built in functions...

...Course Outline Excel object model About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events... Learn about: Excel on-site training, Basic IT, MS Excel...

...This course is suitable for new or intending users of MS Office who want to gain a good understanding of the software in a short space of time. MS Office Essentials Objective...

...IsNa Summarising Data with Pivot Tables Using the Pivot Table Wizard Changing the pivot table layout Formatting Grouping items Inserting calculated fields...

...PREREQUISITES You need to have some exposure to charts and formulae such as sum or average. IMPORTING DATA Importing Data From External Sources Importing...

...This course is designed for beginners and covers: about Office 365; getting started as the administrator; working with the outlook web app; sharing and collaboration... Learn about: Ms Word, Microsoft Excel, MS Excel...

...to get greater productivity from the software. This course is suitable for anyone who has been using Word for some time and who wishes to get greater productivity...

...a keyboard short cut Saving with the file Methods of Executing Menu Visual Basic Toolbar Keyboard Shortcut Custom Toolbar Button Custom Menu Item Button...

...TABLE FUNDAMENTALS What is a Pivot Table Why Should you use a Pivot Table When Should you use a Pivot Table The Anatomy of a Pivot Table Pivot Tables Behind...

...and workgroup collaboration. This course is suitable only for those with considerable prior experience and covers: importing & exporting... Learn about: Excel Advanced on-site training, MS Excel, Data analysis...

...This course is suitable for users with a basic understanding of Excel who want to consolidate and expand on their knowledge of the basic features in a short space of...

...Opening Files Printing Viewing Your Documents Normal View Web Layout Print Layout Print Preview Multiple Documents Efficient Navigation Using Scrollbars...

...PREREQUISITES You need to know how to create simple Pivot Tables, format them, and use calculations within them. CREATING A USING PIVOT CHARTS What is a Pivot Chart Really?...

...This one day course is designed for experienced Excel users who will be using pivot tables extensively in their work. Delegates will learn how to use... Learn about: MS Excel, Excel Pivot Tables in-house training, Excel Pivot Tables training...

...This course is suitable for existing users of Excel who want to gain further in-depth knowledge in a short space of time. Excel / Advanced Objective...

...column widths and row heights Inserting new columns and rows Distributing columns and rows evenly Merging and splitting cells Applying formatting Repeating...

...or at least have some programming experience so that you are aware of basic programming techniques. ENHANCING YOUR PIVOT TABLE REPORTS WITH MACROS...