Course Details
Course Outline
1 - Working with Multiple Worksheets and Workbooks
Working with Named RangesLink Cells Across Worksheets and Workbooks Use 3D References to Calculate Across WorksheetsConsolidate Data
2 - Use Formula Auditing and Error Checking
Reveal FormulasTrace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas
3 - Reviewing and Protecting Workbooks
Control Data Entry via Data ValidationProtect Workbook AccessProtect Worksheets and Cell Content Add and Edit CommentsPrepare a Workbook for Distribution Modify Excel's Default Settings
4 - Using Macros to Automate Workbook Functionality
Create Macros via Recording Run Macros via Buttons and ShortcutsAssign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code
5 - Forecasting and Analysis Data
Use Conditional Formatting to Highlight, Sort and Filter Key DataAdvanced Conditional Formatting using FormulasCreate Sparklines to Visualise DataAdd Trendlines to Charts to Visualise and Forecast TrendsUse Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate OutcomesForecast Data Trends Using Solver
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.