Events

Microsoft Excel: Introduction

Name: Microsoft Excel: Introduction
Start: 2024-12-02T09:30:00+00:00
End: 2024-12-02T16:30:00+00:00
Location: Rotherham

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

A 1 day Introduction Course, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day, users will be able to create, amend and manipulate their own spreadsheets.

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Phone

This field is for validation purposes and should be left unchanged.

This event has passed.

Event Series: Microsoft Excel: Introduction

Details

Date:: December 2
Time:: 9:30 AM- 4:30 PM
Series:: Microsoft Excel: Introduction
Event Categories:: Information Technology (IT) Training Courses, Training

Venue

: Rotherham

Organiser

: Chamber Skills Solutions
Phone: 01709 386200
Email: training@brchamber.co.uk

Other

Enquiry Only: Is Inquirable

Related Events

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Phone

This field is for validation purposes and should be left unchanged.

This event has passed.

Event Series: Microsoft Excel: Introduction

Details

Date:: December 16
Time:: 9:30 AM- 4:30 PM
Series:: Microsoft Excel: Introduction
Event Categories:: Information Technology (IT) Training Courses, Training

Venue

: Rotherham

Organiser

: Chamber Skills Solutions
Phone: 01709 386200
Email: training@brchamber.co.uk

Other

Enquiry Only: Is Inquirable

Related Events

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Phone

This field is for validation purposes and should be left unchanged.

This event has passed.

Event Series: Microsoft Excel: Introduction

Details

Date:: January 6, 2025
Time:: 9:30 AM- 4:30 PM
Series:: Microsoft Excel: Introduction
Event Categories:: Information Technology (IT) Training Courses, Training

Venue

: Rotherham

Organiser

: Chamber Skills Solutions
Phone: 01709 386200
Email: training@brchamber.co.uk

Other

Enquiry Only: Is Inquirable

Related Events

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Comments

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Phone

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Name

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Phone

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

This field is for validation purposes and should be left unchanged.

December 2 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

Course Basics

Introduces the user to the layout of Excel, identifying commonly used features and functions.

Menu bar
Ribbon
Status bar

Spreadsheet Management

Build confidence by performing simple tasks whilst navigating through Excel.

Creating new documents
Saving spreadsheets
Closing Excel

Data Management

Sorting and Filtering your data to get more accurate statistics from your spreadsheet.

Sorting Data
Subtotalling Data
Using Filters
Freezing Panes

Formatting Excel

Changing the look and feel of spreadsheets.

Selecting cells, columns and rows
Displaying data as currency (£)
Displaying figures as percentages (%)
Changing cell, text and border colour

Formulas and Functions

Creating and using simple formulae to return totals, averages, largest and smallest figures from a range of data.

Understanding simple formulas
Using AutoSum
Understanding Absolute Cell References
Using AutoFill tools

Formula Auditing

Understanding and fixing complex spreadsheets that other users may have set up

Trace Precedents
Trace Dependents
Evaluating formulas
Tracing errors
Using the Watch Window

Charts

How to use your data in various chart types.

Using the Chart Wizard
Select appropriate chart types
Specifying the data source
Customising your charts

Book this training course

Company Name

Name

Phone

Address

Date

No. of delegates

Delegates Name(s)

Purchase order no. (n/a)

Additional notes (optional)

Comments

This field is for validation purposes and should be left unchanged.

Cookie	Duration	Description
CONSENT	18 years	Used by Google for cookie consent settings.
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
tk_ai		Used by WooCommerce to to store a unique user ID.
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
wordpress_logged_in_[hash]		This cookie stores whether or not you are logged into the site.
wordpress_logged_in_[hash]		This cookie stores whether or not you are logged into the site.
wordpress_sec_		Provide protection against hackers, store account details.
wordpress_test_cookie		This cookie tests if cookies are enabled on your browser, so we can provide you with the appropriate user experience.
wordpress_test_cookie		Tests to see if cookies are enabled.
wp-settings-{time}-[UID]	1 year	This is used to customise the view of the website for logged in users.

Cookie	Duration	Description
DV	30 minutes	Used by Google to store user preferences and information of Google maps.
HSID	2 years	Security cookie to confirm visitor authenticity, prevent fraudulent use of login data and protect user data from unauthorized access.
popup_shown	1 week	Set when the user has been shown a popup to prevent the popup being shown repeatedly.
SEARCH_SAMESITE	6 months	This cookie is used to prevent the browser from sending this cookie along with cross-site requests. The main goal is mitigate the risk of cross-origin information leakage. It also provides some protection against cross-site request forgery attacks.
SID	2 years	Security cookie to confirm visitor authenticity, prevent fraudulent use of login data and protect visitor data from unauthorized access.

Cookie	Duration	Description
__utma	2 years	Used to distinguish users and sessions. The cookie is created when the javascript library executes and no existing __utma cookies exists. The cookie is updated every time data is sent to Google Analytics.
__utmb	30 minutes	Used to determine new sessions/visits. The cookie is created when the javascript library executes and no existing __utmb cookies exists. The cookie is updated every time data is sent to Google Analytics.
__utmc		Not used in ga.js. Set for interoperability with urchin.js. Historically, this cookie operated in conjunction with the __utmb cookie to determine whether the user was in a new session/visit.
__utmt	10 minutes	Used to throttle request rate.
__utmv	2 years	Used to store visitor-level custom variable data. This cookie is created when a developer uses the _setCustomVar method with a visitor level custom variable. This cookie was also used for the deprecated _setVar method. The cookie is updated every time data is sent to Google Analytics.
__utmz	6 months	Stores the traffic source or campaign that explains how the user reached your site. The cookie is created when the javascript library executes and is updated every time data is sent to Google Analytics.

Cookie	Duration	Description
1P_JAR	1 month	Set by Google. This group sets a unique ID to remember your preferences and other information such as website statistics and track conversion rates.
SAPISID	2 years	Google collects visitor information for videos hosted by YouTube.
SIDCC	1 year	Google collects visitor information for videos hosted by YouTube.

Cookie	Duration	Description
__Secure-1PAPISID	2 years	Used by for targeting purposes to build a profile of the website visitor's interests in order to show relevant & personalised Google advertising.
__Secure-1PSID	2 years	Used by for targeting purposes to build a profile of the website visitor's interests in order to show relevant & personalised Google advertising.
__Secure-3PAPISID	2 years	Used by for targeting purposes to build a profile of the website visitor's interests in order to show relevant & personalised Google advertising.
__Secure-3PSID	2 years	Used by for targeting purposes to build a profile of the website visitor's interests in order to show relevant & personalised Google advertising.
__Secure-3PSIDCC	1 year	Used by for targeting purposes to build a profile of the website visitor's interests in order to show relevant & personalised Google advertising.
APISID	2 years	Personalizes Google ads on websites based on recent searches and interactions.
SSID	2 years	This cookie is used by Google to display personalized advertisements on Google sites, based on recent searches and previous interactions