A working knowledge of this application is important for most employees operating in a business Environment. Microsoft Excel is one of the most used applications, across a wide variety of sectors. Having staff that are effective, proficient and efficient in their work will support the smooth running of your business and will support your staff to become more productive.

Course Overview
You’ve been asked to enter data in Excel, but you’ve never worked with Excel. Where do you begin? Or perhaps you have worked in Excel a few times, but you still wonder how to carry out some of the basic functions — creating, saving or printing a workbook, how to enter different kinds of data, how to edit data, creating a basic formula, or how to add, edit or delete a cell, columns or row. This is the place to learn the skills you need to work in Excel, quickly.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential.

Course Content
By the end of this course delegates will know:

• The procedure for creating Excel workbooks
• Methods of editing contents within a cell or workbook
• Best practice in formatting processes
• How to create a basic formula
• How to print your spreadsheets
• The steps to create, open and save a workbook
• Use of the screen layout
• The procedure to create relative and absolute reference within a formula
• Methods to format and fill cells
• Freezing and hiding columns
• Applying conditional formatting
• Methods of editing page size and printing workbook

The post Introduction to Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

Course Overview
You’ve been using simply and competently Excel for a while now and feel you would like to really start to get to grip with the major concepts in terms of managing data lists and understanding complex formulas for problem solving.
Here is your chance to learn how to sort and filter data lists whether they be parts, customer or any set of business data. You may also rise to the challenge of learning about IF statements and producing key KPI measures using charting techniques. Perhaps you have only used formulas on one sheet before now you will learn about multi worksheet and workbook linking. All in all, a great course to give you valuable business skills in this popular package.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A good knowledge of Excel or attendance on the introductory course.

Course Objectives
By the end of this course delegates will know:

• How to create charts and format them
• How to sort lists and create custom sorted lists
• How to apply the Sub total command to a sorted list
• What auto, custom and advanced filtering are all about
• How to use the IF complex formula to resolve various business problems
• To lock cells and apply sheet protection
• To consolidate data across workbooks and worksheets by commands and formulas
• How to use sheet grouping

The post Intermediate Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

We aim to make even the cleverest functions of a complicated nature relatively easy to understand and use. Many people would like to get to grips with pivot tables and macros and we show you how it’s not rocket science, but simply a great tool perhaps never explained in layman’s terms before. A course for you if you believe you are at Intermediate levels already.

Who is the course for?
Users with a good understanding of Microsoft Excel who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you would like to fill in any gaps in your knowledge.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A very good working knowledge of Excel or attendance on the Intermediate course.

Course Content
By the end of this course delegates will know:

• How to create complex charts and format them
• How to generate date, text and logical functions to resolve problems
• What advanced filtering is all about and how to determine unique records in a list
• How to use the IF statement and VLOOKUP formula to resolve various business problems
• How to create a Pivot Table and Chart to simplify complex data sets
• That macro development is not complicated!

The post Advanced Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

Course Overview
You’ve been using simply and competently Excel for a while now and feel you would like to really start to get to grip with the major concepts in terms of managing data lists and understanding complex formulas for problem solving.
Here is your chance to learn how to sort and filter data lists whether they be parts, customer or any set of business data. You may also rise to the challenge of learning about IF statements and producing key KPI measures using charting techniques. Perhaps you have only used formulas on one sheet before now you will learn about multi worksheet and workbook linking. All in all, a great course to give you valuable business skills in this popular package.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A good knowledge of Excel or attendance on the introductory course.

Course Objectives
By the end of this course delegates will know:
• How to create charts and format them
• How to sort lists and create custom sorted lists
• How to apply the Sub total command to a sorted list
• What auto, custom and advanced filtering are all about
• How to use the IF complex formula to resolve various business problems
• To lock cells and apply sheet protection
• To consolidate data across workbooks and worksheets by commands and formulas
• How to use sheet grouping

The post Intermediate Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

A working knowledge of this application is important for most employees operating in a business Environment. Microsoft Excel is one of the most used applications, across a wide variety of sectors. Having staff that are effective, proficient and efficient in their work will support the smooth running of your business and will support your staff to become more productive.

Course Overview
You’ve been asked to enter data in Excel, but you’ve never worked with Excel. Where do you begin? Or perhaps you have worked in Excel a few times, but you still wonder how to carry out some of the basic functions — creating, saving or printing a workbook, how to enter different kinds of data, how to edit data, creating a basic formula, or how to add, edit or delete a cell, columns or row. This is the place to learn the skills you need to work in Excel, quickly.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential.

Course Content
By the end of this course delegates will know:

• The procedure for creating Excel workbooks
• Methods of editing contents within a cell or workbook
• Best practice in formatting processes
• How to create a basic formula
• How to print your spreadsheets
• The steps to create, open and save a workbook
• Use of the screen layout
• The procedure to create relative and absolute reference within a formula
• Methods to format and fill cells
• Freezing and hiding columns
• Applying conditional formatting
• Methods of editing page size and printing workbook

The post Introduction to Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

Course Overview
You’ve been using simply and competently Excel for a while now and feel you would like to really start to get to grip with the major concepts in terms of managing data lists and understanding complex formulas for problem solving.
Here is your chance to learn how to sort and filter data lists whether they be parts, customer or any set of business data. You may also rise to the challenge of learning about IF statements and producing key KPI measures using charting techniques. Perhaps you have only used formulas on one sheet before now you will learn about multi worksheet and workbook linking. All in all, a great course to give you valuable business skills in this popular package.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A good knowledge of Excel or attendance on the introductory course.

Course Objectives
By the end of this course delegates will know:
• How to create charts and format them
• How to sort lists and create custom sorted lists
• How to apply the Sub total command to a sorted list
• What auto, custom and advanced filtering are all about
• How to use the IF complex formula to resolve various business problems
• To lock cells and apply sheet protection
• To consolidate data across workbooks and worksheets by commands and formulas
• How to use sheet grouping

The post Intermediate Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

This will include Excel sophisticated exercises of a lengthy nature to stretch your Excel imagination and skills!

Who is this course for?
This should only be attended by a trainee who has been on a Chamber Advanced Excel course and wants to improve further their skills in the workplace.

• Logistics planner
• Office specialist
• Accountant or finance specialist
• IT person
• Involved with regular Excel work

Course Overview
This highly interactive course will take the format of:
• Looking at problems and solutions using nested statements
• Developing Pivot Tables and Charts
• Writing macros and editing them
• Understanding scenario and Indexes
• Understanding conditional formatting with formulas

Course Agenda
• Open workbook and Consolidations, ISERROR, VLOOKUP, IFERROR
• Pivot Tables, Charts, Sorting, Slicing
• Macros and Editing Macros
• Nested Statements using VLOOKUP
• Nested INDEX MATCH function and VLOOKUP with Indirect Functions
• Scenario manager and Data Tables
• Conditional formatting

The post Excel Masterclass appeared first on Herefordshire & Worcestershire Chamber of Commerce.

We aim to make even the cleverest functions of a complicated nature relatively easy to understand and use. Many people would like to get to grips with pivot tables and macros and we show you how it’s not rocket science, but simply a great tool perhaps never explained in layman’s terms before. A course for you if you believe you are at Intermediate levels already.

Who is the course for?
Users with a good understanding of Microsoft Excel who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you would like to fill in any gaps in your knowledge.

Prerequisites
Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A very good working knowledge of Excel or attendance on the Intermediate course.

Course Content
By the end of this course delegates will know:

• How to create complex charts and format them
• How to generate date, text and logical functions to resolve problems
• What advanced filtering is all about and how to determine unique records in a list
• How to use the IF statement and VLOOKUP formula to resolve various business problems
• How to create a Pivot Table and Chart to simplify complex data sets
• That macro development is not complicated!

The post Advanced Microsoft Excel appeared first on Herefordshire & Worcestershire Chamber of Commerce.

This course is suitable for users new to Microsoft Teams or existing users looking at ways to utilise the platform to streamline processes will benefit from attending this introductory course.

Course Overview
This How to use Microsoft Teams Effectively training course has been developed specifically with the needs of today’s workforce in mind. It looks at the basics of getting started on Microsoft Teams, and how you and your workforce can utilise this platform to successfully collaborate on team projects, share files, prioritise workloads and create tasks all in one place.

• Back to Basics – learn how to set up a new team, schedule a meeting, make calls, and use the chat function
• Utilise your activity feed – Learn how to utilise your activity feed to keep you on track and organized
• What is a Channel? Understand what channels are and how your team can use this toll to collaborate effectively
• Create Posts, Messages and Files – stay connected with your team by posting in relevant channels, messaging team, as well as sharing and saving files
• Manage your meeting – Enhance and customise your meeting experience with various collaboration tips
• Useful apps and tools – Identify how to search for different apps and tools. This training session will also cover how to use the Planner App and how it can be used in your Channels to organise and schedule workloads and tasks
• Schedule using Shifts – create, edit and manage team schedules with the management tool, Shifts

Delegates are required to bring their own laptops and have access to their Microsoft account log in details.

The post How to use Microsoft Teams Effectively appeared first on Herefordshire & Worcestershire Chamber of Commerce.