Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.

Learning Objectives

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.  COURSE OUTLINE 1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data 2 - USE FORMULA AUDITING AND ERROR CHECKING Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas 3 - REVIEWING AND PROTECTING WORKBOOKS Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare 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 Shortcuts Assign 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 Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill