Excel Essentials Course For Business Users

Name: Excel Essentials Course For Business Users
Rating: 4.4 (4 reviews)

Learn several Excel office tips to help on a daily basis for Excel spreadsheets

Created byMach 42 Productions

Last updated 10/2023

English

What you'll learn

How to hide/unhide Excel worksheets
How to print Excel spreadsheets properly
How to watermark Excel spreadsheets successfully
How to navigate a spreadsheet more productively
How to quickly build a column chart in under 5 minutes
How to quickly build a table in under 5 minutes
How to cut/copy and paste data concisely
How to find out the total number of worksheets in your Excel workbook

Course content

3 sections • 11 lectures • 47m total length

Introduction2:47
This lecture overviews the syllabus, its aim and best ways to learn from this Excel course!

How to print pages properly in Excel3:53
This Excel lecture shows you how to print Excel spreadsheets properly, ensuring no words or tables or charts are cut off.
How to copy or cut and paste data in Excel6:18
This Excel lecture shows you how to copy or cut (move) data in Excel. We cover the most popular options for doing this.
How to Hide/Unhide Worksheets in an Excel Workbook5:29
This Excel lecture covers how to hide and unhide Excel worksheets. The benefits of hiding Excel worksheets include:

Helps to focus a workbook by only showing the worksheets that are relevant to the user
Rather than delete a worksheet, you can simply hide it and unhide later if you ever need it again
The changes are preserved- if you hide or unhide an Excel worksheet and save/close your workbook, when you re-open it, the structure is the same i.e. anything hidden is the same and similarly for sheets that visible.
How to watermark your Excel spreadsheets5:26
In this Excel lecture, we show you how to watermark your spreadsheets. This is very useful for work which is confidential or in 'draft' status. The watermark will also print out too.
Freezing panes6:42
This Excel lecture covers how to freeze columns and rows on data. The benefit of this is it makes viewing your data much easier.
How to save an Excel file as a PDF2:28
This Excel lecture shows you how to save a file in Excel to a PDF. This can come in handy when you want to send a report to a client or other party and don't want to send the original Excel file. Also the added bonus is, the PDF cannot be altered.
How to find out the total number of worksheets in your Excel workbook3:16
This lecture shows you how to get the total number of worksheets in your Excel workbook. This is done via the Excel Workbook Statistics feature. The total figure will also include any hidden sheets in your Excel workbook.
Making an Excel column chart in 5 minutes or less4:06
Here in this Excel lecture we show you how to make a column chart in under 5 minutes.
Making an Excel table in under 5 minutes4:47
This Excel lecture shows you how to make an Excel table in under 5 minutes. This lecture is great for when you have a last minute deadline.
Tables quiz

Requirements

A basic competency of Excel- You should be able to open, close and save a workbook and have a general awareness of Excel
A copy of Excel 2013, Excel 2016, Excel 2019 or Office 365 for Windows based computers

Description

This Excel essentials business course is designed for those who need an immediate grounding in Excel office productivity basics. All these tips can be used in any type of spreadsheet work regardless of the industry and job.

Aimed at Office users such as Business Owners, Consultants, Project Managers, Administration staff and Junior Analysts, in less than an hour, you will learn the basics to help on you any Excel report you have such as:

How to save Excel files as PDFs- Perfect for sending out to clients
How to hide/unhide Excel worksheets- Helps to focus your workbook by ensuring only necessary information is visible
How to print Excel spreadsheets properly (with no cut off bits...) - Great for face to face discussions
How to build an Excel bar chart and table, each in under 5 minutes - Perfect for adding visualisations to your data
How to find out the total number of worksheets in your workbook- Also including any hidden sheets
How to watermark your spreadsheets - Very useful for when sending out 'draft' or 'final' spreadsheet versions
How to freeze row headers - For example the top row, so you can navigate your spreadsheet more productively

This course has been designed to give you the immediate Excel basics you need to help you work quicker and smarter with your spreadsheet in the office on a daily basis (especially when you have a deadline).

Course benefits:

-Its very short, you can learn everything in one lunch break at work.

-All the lectures are short and independent of each other; so you can watch in any order.

-Workbooks are supplied

-Full tutor support is given

-Lifetime access to lectures

Remember Excel is one of the most used tools in the office. Knowing these tips we teach will make you work much more productively.

I look forward to seeing you on the other side, thank you!

Who this course is for:

Office users who need to use Excel and want a very quick grounding in Excel report basics
Business owners looking to improve their Excel skills quickly
Freelancers looking to learn the basics of Excel
Project Managers who need a quick grounding in Excel basics to make using spreadsheets easier
Administration staff who are required to perform basic navigation, printing and watermarking of Excel spreadsheets
Junior analysts who are just starting out in Excel and are looking to improve their productivity
PhD students who need a basic grounding in Excel to help them with their data spreadsheets

Excel Essentials Course For Business Users

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Excel Quick Starter Basics9 lectures • 42min

Wrap up1 lecture • 2min

Requirements

Description

Who this course is for: