This course aims to extend the users knowledge with more tools and commands. By the end of the course, users will be able use features including Goal Seek, Data Tables, Scenario Manager and Macros.
Course content includes:
Quick refresh on commonly used formulas in Excel.
• VLOOKUP formula
• IF Logical Tests
• SUMIF formula
• COUNTIF formula
Consolidation
How to consolidate your excel data from multiple locations.
• Bringing together data from multiple sources
• Viewing multiple worksheets
• Viewing multiple workbooks
Text Manipulation
Analysing data from different sources.
• Use basic text formulas
• Format data using Text to Columns
• Connect to an extrernal Data Source using OBDC Connectors
What if Analysis
Forecasting return figures for business.
• Goal Seek
• Data Tables
• Scenario Manager
Forms
How to use the form controls to make filling in spreadsheets quicker and easier for your users.
• Command Buttons
• Check Boxes
• Scroll Boxes
• Dropdown lists
• Data Validation
Macros
Introduces the user to the basics of macros.
• Creating macros
• Editing macros
• Running Macros
• Macro Security
• Assign a macro to a command button
Customising Excel
• Customising excels default settings Modify existing toolbars
• Create custom toolbars
• Create and edit menu bars
Format/Delivery: Online at own pace
Cost: £40