Excel courses Southwark

...in Excel CTRL combination shortcut keys Function keys Other useful shortcut keys Importing Data Converting Files from Other Applications Copying Data...

...WRITING CODE What is a sub procedure What is a function Formatting Objects Cut / Copy / Paste Deleting rows / columns / ranges / cells Using Msgbox Using...

...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code. DESCRIPTION Anyone wishing to automate...

...Adding Buttons Customising the buttons Resetting all in-built toolbars Preventing any design changes to your toolbar Creating a Menu using VBA Creating...

...common worksheet operations, convert worksheets into forms and understand Excel VBA code. PREREQUISITES Must be confident or at least have had sufficient...

...Functions Correcting Formulas Using The Formula Error Checker Using The Formula Auditing Toolbar Using The Watch Window DATABASE AND LIST MANAGEMENT Using...

...DESCRIPTION This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets...

...Using the format painter PRINTING Using Page Setup Margins Headers And Footers Printing A Spreadsheet CHARTS Chart Wizard Chart Toolbar Working With Charts...

...Code to your Macro Adding Comments to VBA Code Declaring Variables Prompting for User Input Iteration over a Range Using IF Then Else Statements EXPERT...

...Pivot Fields PERFORMING CALCULATIONS WITHIN YOUR PIVOT TABLE Introducing Calculated Fields and Calculated Items Rules and Shortcomings of Pivot Table Calculations...

...A further look at the power of Pivot tables and Pivot Charts, introducing getting your data from multiple sources, and opening the door to OLAP Cubes!...

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

...Tag Options Editing Tools Using AutoCorrect Using Spell Check Using Find and Replace Adding Comments EDITING YOUR WORKBOOK Modifying Cells and Data Changing...

...Fields Working with Tables and Filters Using Excel as a Database ENHANCING YOUR WORKBOOK Customizing your Workbook Inserting a Symbol or Special Character...

...Using a One and Two Input Data Table Using Goal Seek Using Solver EXCEL AND THE INTERNET Excel and Hyperlinks Using Hyperlinks in Excel Saving Workbooks...

...Manager Adding a Scenario Showing a Scenario Deleting a Scenario Editing an existing Scenario Summarising Scenarios Solver Using Solver Installing Solver...

...Creating Subtotals Removing Subtotals Pivot Tables Understanding Pivot Tables Creating Pivot Tables Dropping data into Pivot Tables Modifying data...