PC Applications Courses Greater Manchester

...Using your workbooks to practise. Duration: 1 day Group: Microsoft Contents Prerequisites Confidence in using Excel, and have knowledge to our Intermediate level...

...and locating bookmarks •Creating master document cross-references •Editing and deleting bookmarks •Compiling indexes and tables of contents •Creating and...

...To understand and competently use the various elements of Outlook. Consider how they work together and in isolation as a communication and organisation...

...formulas • Using SUM function Charts • Using AVERAGE, MIN, MAX and COUNT • Creating a simple chart using Chart Wizard • Copying formulas and functions...

...tool. Packing it all up. PowerPoint on a laptop, via email or for staff training. Seek and ye shall find. We like questions and we answer honestly...

...and rows •Applying conditional number formatting...

...how would I do this? How do I check the capacity of my resources? How would I calculate the project cost? Can I track whether my project is ahead or behind schedule?...

...•Checking for errors •Applying data validation to cells with input text and error messages Report Manager •Using Report Manager •Managing views and reports...

...Improving your document efficiently. Moving and navigating. Thesaurus, research and spelling. Introducing rapid keyboard shortcuts. (You'll Love this...

...attended our Excel Advanced course or be able to demonstrate equivalent knowledge. Microsoft Excel VBA •Introduction to Excel VBA •Recording and running...

...With Style(s). Introducing rapid keyboard shortcuts. (You'll like this one) Hyperlinking. Bookmarks and servers at work. Tops and bottoms. Watermarking...

...text in columns •Creating and editing charts to give visual impact to data tables •Creating and editing organisation charts •Applying design templates... Learn about: PowerPoint 2007...

...Does this sound like you? I need to send out a number of letters, quickly - how does Mail Merge work? How do I send out slightly different letters to Mail Merge recipients?...

...Planning Techniques •Networks; Gantt Charts •Critical path analysis Scheduling with Dependencies •Entering dependencies •Critical path review •Recurring...

...copy and import/export modules Starting the Visual Basic Editor Using the Project Explorer Using the Properties Window Creating, Importing and Exporting... Learn about: Excel VBA, Microsoft Excel, MS Excel...

...additional formulae Create a Pivot Charts Changing a Pivot Table and more features of PIvot Table to show you how you can get the best out of Pivot Tables... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Table Calculations Filtering with Slicers PivotTable Filters and Slicers Filtering PivotTables and PivotCharts Creating Hierarchies Excel techniques... Learn about: Data Collection, Dashboards and servicing reports, Data Analytics...

...loop while, until Loop for ... next Instructions loop break (exit) Array processing Quoted string Combining quoted strings (concatenation) Conversion to other types... Learn about: Visual Basic, Visual Basic training, MS Excel...

.....Then.Elseif.Else.Endif Case Do...Loop , While For... Next Exit Arrays and Loops Strings Visual Basic VBA and Sheet Data Exchange (Cells, Range Methods)... Learn about: Visual Basic, Microsoft Excel, MS Excel...

...Analytical options Goal Seek Solver The Analysis ToolPack Scenarios Macros and custom functions Running and recording a macro Working with VBA code Creating... Learn about: Microsoft Excel, Financial Training, MS Excel...