Excel Essentials for Professionals: Boost Your Productivity

Name: Excel Essentials for Professionals: Boost Your Productivity
Rating: 4.4 (24 reviews)

Learn foundational Excel skills, formulas, and time-saving tools to work smarter and enhance your business efficiency

Created byLong Nguyen

Last updated 11/2024

English

What you'll learn

Confidently navigate the Excel interface and utilize essential shortcuts to improve workflow efficiency.
Master foundational Excel functions, formulas, and cell references to handle data accurately and effectively.
Apply formatting tools, borders, and charts to create visually appealing and professional worksheets.
Organize, analyze, and manage data using sorting, filtering, and conditional formatting techniques

Course content

4 sections • 31 lectures • 2h 2m total length

Take charge of Excel6:37
First of all, we need to get familiar with the user interface of Excel, where things are and what we call them.
Take charge of Excel - quiz
Navigating and selecting in Excel5:49
It's important that we can navigate confidently but also efficiently around the Excel user interface. So, you may be kind of getting around, but let's look at some of the quicker ways of doing that and also selecting data.
Navigating and Selecting - Quiz
Use and change view options in Excel5:24
Let's take a look at how we can use and change view options, such as zoom in, zoom out, free panes, etc.
View options - quiz
Data Entry, Editing and Deleting data in Excel6:16
Are you ready to create your own worksheet? What about editting it correctly? Let's learn how to do those things today.
Using Fill Handle in Excel5:21
Have you ever heard of the Fill Handle, one of the most useful tools in Excel? Let's take a look at it today.
Quiz on Fill Handle
All about Copy, Cut and Paste Options in Excel5:01
Do you know how to copy, cut, and paste data across Excel and to other programs? Let's talk about it in this lesson.
Essential shortcuts in Excel3:11
Practice challenge for section 10:10

Simple Excel formulas3:36
To be a competent Excel user, you have to know the basics. Once you've mastered these basics, once you've got the critical call of how it actually works, the rest becomes easy
Quiz on basic formulas
Using Formulas in Business context4:08
Let's use what we have learnt to solve a real Excel problem with more than 1,000 records, shall we?
Quiz on using Formulas in Context
Basic Excel Functions - Sum and Autosum3:50
Hi guys,
In this video, we start learning Excel functions. The first functions we will learn are Sum and Autosum, how they work and how to use them quickly.
Thank you for choosing this course. Please also dowmload our resources to practise.
Quiz on Sum and Autosum
Basic Excel Functions - Average, Max, and Min4:29
Hi guys,
In this video, we continue learning Excel functions. The next functions we will learn are Average, Max, and Min, and different ways to use them.
Thank you for choosing this course. Please also dowmload our resources to practise.
Quiz on Average, Max, and Min functions
Absolute cell references3:42
How can you "lock" a cell in Excel? Check out my new video to see how and why we should do it sometimes.
Quiz on Absolute cell reference
Calculations across sheets4:53
In your daily Excel tasks, sometimes you need to do calculations with data from different sheets. Let's take a look at how to do it today.
Quiz on calculations across sheets
Excel options5:46
Did you know that you can control how Excel operates? Let's take a look at how to do that in today's lesson.
Practice challenges for section 20:28

Formatting tools - Font group3:35
In the first lesson of this section, we will take a look at how to change the font, font size, etc. to make our workbook look better.
Quiz on formatting tools
How to use different kinds of borders4:02
You may have heard and used borders in Excel. In this lesson, we will talk about how to use them properly to make your spreadsheet much more readable and professional.
Quiz on how to use borders
How to use vertical and horizontal alignment tools4:05
Did you know about alignment tools in Excel? Let's check out today's lesson and see.
Quiz on alignment tools
How to copy and clear formatting quickly3:53
Did you know how to quickly copy, as well as clear formatting in Excel? Let's take a look at those tools today.
Number Formatting5:12
In this video, we are going to talk about number formatting and how to use it in your data.
Quiz on Number formatting
Basic Chart types4:51
Charts will make your spreadsheet look more professional and help you present your data visually. Let's take a look at some basic ones today.
Quiz on basic charts
Keyboard shortcuts and some tips1:01
Practice challenge for section 30:08

Managing rows and columns4:20
This lesson is all about how to manage your rows and columns effectively.
Find and replace data3:16
Today we are going to have a short lesson about how to find and replace data in Excel.
Filtering tools6:34
In today's lesson, we will talk about how to use filter tool to narrow down your data to just the one you need.
Sorting data3:46
The Sorting tool helps you to arrange your data in a specific order. In this video, let's learn how to use it to sort our data quickly and effectively.
Conditional formatting6:42
This lesson is all about how to use conditional formatting, which allows you to automatically apply formatting whenever certain criteria are met.
Terminology and useful keyboard shortcuts1:36
Practice challenge for Section 40:18

Requirements

Microsoft Excel 2016 is preferable but other versions are OK
Willing to learn and practice a lot

Description

Hi guys,

Are you ready to unlock the full potential of Microsoft Excel? Whether you're a beginner or looking to sharpen your skills, this course is your ultimate guide to mastering Excel, packed with engaging lessons, hands-on quizzes, and real-world challenges.

What You’ll Learn:

Navigate Like a Pro: Explore the Excel interface and discover essential shortcuts to streamline your work.
Master Foundational Skills: Build a strong foundation with data entry, editing, formatting, and leveraging tools like the Fill Handle.
Harness the Power of Formulas: Understand basic formulas and functions such as SUM, AVERAGE, MAX, and MIN, and apply them in practical business scenarios.
Enhance Data Visualization: Create better-looking worksheets using formatting tools, borders, alignment, and charts to make your data stand out.
Simplify Data Management: Organize and analyze data effortlessly with filtering, sorting, conditional formatting, and efficient find-and-replace techniques.

Why Choose This Course?

Interactive Learning: Test your understanding with quizzes after every key topic.
Practice Challenges: Tackle realistic exercises to cement your skills in each section.
Practical Applications: Gain insights into how Excel solves real-world problems in business and beyond.
Preview Enabled Lectures: Get a sneak peek into select lectures before committing to the course.

Who This Course Is For:

Beginners aiming to build a solid Excel foundation.
Professionals seeking to enhance their productivity and efficiency with Excel.
Students and job seekers preparing for a career that requires Excel proficiency.

With this course, you'll gain the confidence to use Excel for personal, academic, or professional purposes. Join us now and take charge of your data like never before!

Who this course is for:

Office workers
Excel learners

Excel Essentials for Professionals: Boost Your Productivity

What you'll learn

Explore related topics

Course content

Excel user interface and key foundational features8 lectures • 38min

Basic formulas, basic functions and cell references8 lectures • 31min

Tools to make better - looking worksheets8 lectures • 27min

Working and managing data7 lectures • 27min

Requirements

Description

Who this course is for: