Microsoft Excel VBA

Course Overview:This course is intended for people who would like to enhance their understanding and knowledge of Excel. It takes participants through the items listed in the course contents to a point where participants can use Microsoft Excel to increase efficiency in their everyday work.Pre-requirements:A good knowledge of Excel or have completed the Procad Training Course entitled Intermediate ExcelParticipants Study:Importing Data from External Sources Templates and Styles Analysing Data Pivot Tables Macros and Custom Controls Security and Proofing  Customising Excel Collboration and ConsolidationCourse Outline:Importing Data From External SourcesImporting FilesUsing the Text WizardUsing the Microsoft QueryWeb QueriesTemplates and StylesCreating and Applying TemplatesCreating, Applying, Editing and Deleting StylesAnalysing DataWhat-If AnalysisGoal SeekData TablesScenario ManagerSolverPivot TablesUnderstanding Pivot TablesCreating Pivot TablesModifying and Refeshing Pivot TablesGrouping Data within Pivot TablesMacros and Custom ControlUsing MacrosRecording a MacroAssigning a Macro to a shortcut keyRunning MacrosWorking with ButtonsCreating a New ButtonRenaming and Formatting a ButtonAssigning a Macro to a ButtonSecurity and ProofingWorking with Security FeaturesProtecting Excel FilesWorksheet ProtectionProtecting CellsDigital SignaturesData ValidationUsing Text to SpeechWorking with CommentsCustomising ExcelView OptionsCalculation OptionsEdit OptionsGeneral OptionsCustom ListsSave OptionsWorkspacesCollaboration and ConsolidationSharing WorkbooksComparing and Merging WorkbooksSending WorkbooksConsolidation