Excel Intermediate (Session 3)

£30.00

A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. It takes a acute computer user to take advantage of everything Excel has to offer to provide the best results for their company.

Categories: , Tags: , ,

Description

NEED TO UNDERSTAND EXCEL?

Are you new to Excel or have very little or no knowledge of how to even begin? Do your staff struggle with spreadsheets, formulas and sorting data? Join us for session 3 of the Excel training Series Online Course.

SESSION 3 - DATA FILTERING, SORTING, SEARCHING, EDITING AND EXTRACTION

Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel training is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulas, filtering functionality, data searching and extraction tools.

The objective of SESSION 3 is to enable delegates to become comfortable with working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information.

Data Editing
Sorting
Filtering
Conditional formatting
Data validation
Subtotal formula
Find and replace
Data Searching
Searching within filter
Searching within sheet
VLookUps
CountIf formula
If statements
Basic Data Extraction
Flash fill
Text-to-Columns
Concatenate

Excel is a program within the Microsoft Office Suite. It contains a spreadsheet that can automatically input, calculate and analyze data, which makes it a valuable skill for the workplace. Employees can use Excel to accomplish an abundance of daily tasks.

Advanced knowledge of Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks. The way Excel is used depends on the needs and duties of specific departments or job roles.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

We want you to be satisfied, so all eligible courses purchased on Vogate can be refunded within 14 days. For whatever reason, if you are unhappy with a course, you can request a refund, provided the request meets the guidelines in our refund policy.

Certain restrictions may apply and some purchases may only be eligible for credit refunds. For more information regarding our refund policy, please see below.

How to submit a refund request

If you’re looking for instructions on how to submit a refund request, please visit our support and help section. 

Our 14-day policy

While our 14-day refund policy is to allow customers to learn risk free, we must also protect our vendors from fraud and provide them a reasonable payment schedule. Payments are sent to vendor after 30 days, so we will not process refund requests received after 14 days of purchase.

Additional reasons for denied refunds

We reserve the right, in our sole discretion, to limit or deny refund requests in cases where we believe there is refund abuse, including but not limited to the following:

  • A significant portion of the course has been consumed or downloaded by a customer before the refund was requested.
  • Multiple refunds have been requested by a customer for the same course or other courses
  • Excessive refunds have been requested by a customer.
  • Users who have their account reported, banned or course access disabled due to a violation of our Terms or Trust & Safety Guidelines. 
  • We do not grant refunds for any subscription services.

These refund restrictions will be enforced to the extent permitted by applicable law. 

Related products