PC Applications inhouse

...also get to know the features present in the latest release of Microsoft Office 2007: In this course, you will work with the new and increased features in Office... Learn about: Microsoft Office...

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

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

...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: Microsoft Word, Team Training, Ms Word...

...Suitable for people who already know the basics of Excel. Course review: In this course, you will use Microsoft Office Excel to streamline and enhance...

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

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

...and workgroup collaboration. This course is suitable only for those with considerable prior experience and covers: importing & exporting... Learn about: Database training, XML training, Excel Advanced in-house training...

...to letters that others have typed. Word for Professionals – 2 hours Time: 9.30 – 11.30 Objective: The ability to efficiently amend documents without unintentional...

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

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

...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 training, Excel Pivot Tables in-house training...

...the more advanced features of this software to create slides with greater impact. This course is suitable for existing users who want to use the more advanced...

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

...Title Slide, Bulleted List, Two Column Text Changing the slide layout Creating Blank Slides Adding Freeform Text Save a Presentation Formatting a Presentation...

...Course Outline Developing applications Types of applications, Types of end-user, Analysing end-user needs, Planning an application, Planning the user interface... Learn about: MS Excel, Excel in-house training, Excel 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...

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

...freehand Creating regular shapes Formatting Shapes including 3D, Shadows and Fill Effects Creating Auto Shapes Copying and Moving Working with Guides Aligning...

...Basics Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your... Learn about: Basic IT, Visual Basic training, Excel on-site training...