Microsoft Excel 365 Business Essentials

Focused View

Donna Hanson

1:28:21

0 View

1 - Introduction

1 -Introduction.mp4

01:54

1 -UExcel Essentials Workbook 24.pdf

1 -U Excel Essentials Sample File.xlsx

2 - Spreadsheet Basics

1 -Spreadsheet Basics - Introduction and Set Up.mp4

01:57

2 -Understanding Excels Mouse Pointers.mp4

02:15

3 -Understanding How Excel treats data.mp4

02:11

4 -Selection Techniques in Excel.mp4

02:31

5 -Renaming & Coloring Worksheet tabs.mp4

02:51

6 -Copying & Pasting Options.mp4

03:10

7 -Duplicate a Worksheet.mp4

01:23

8 -Display a List of all Worksheets.mp4

00:50

9 -Page Break Preview.mp4

01:52

3 - Formatting Basics - Introduction & Set Up

1 -Formatting Basics - Introduction & Set Up.mp4

01:36

2 -Format Painter.mp4

01:16

3 -Formatting Cells, Changing Fonts & Alignment.mp4

03:09

4 -Formatting Numbers in Excel.mp4

05:22

5 -Date Formats.mp4

02:08

6 -How to insert and widen rows and columns.mp4

01:39

7 -Converting Numbers displayed as Dates.mp4

00:58

8 -Print Titles.mp4

03:00

4 - GraphChart Basics

1 -GraphChart Basics - Introduction & Set Up.mp4

00:56

2 -Understanding Graphs.mp4

01:52

3 -Different Graph Types.mp4

04:05

4 -Creating a Basic Graph.mp4

02:10

5 -Modifying and Editing GraphsCharts.mp4

04:22

5 - Formula & Function Basics

1 -Formula & Function Basics - Introduction & Set Up.mp4

01:09

2 -Formulas vs Functions - Whats the difference.mp4

01:40

3 -Formula Basics.mp4

03:22

4 -Relative vs Absolute Cell Addressing - what does this mean and how it impacts.mp4

03:48

5 -Calculating Percentages.mp4

02:41

6 -SUM Function.mp4

02:46

7 -Average Function.mp4

01:42

8 -Proper Function.mp4

02:49

9 -Trim function.mp4

02:38

6 - Data Analysis Basics

1 -Simple Data Analysis Basics - Introduction & Set Up.mp4

01:18

2 -How to Set Up an Excel Database.mp4

02:13

3 -Sorting Data.mp4

00:56

4 -Custom Sort.mp4

01:22

5 -Filtering Data Using AutoFilters.mp4

02:19

6 -Freezing Panes.mp4

02:44

7 - What now

1 -What now.mp4

01:27

Description

Get Started with the Basics for Business

What You'll Learn?

Identify the Microsoft Excel foundational spreadsheet skills that are needed in business
How to utilize Excel tools to simplify common tasks and activities in spreadsheets
How to format cells depending on needs and content - ie numbers and text as well as troubleshooting
How to set up and create simple graphs
Simple formulas needed in everyday business.
Clarity of features and tools in Excel required in a day to day business context

Who is this for?

This course is written for users of Excel who have had little to no training or are looking to fill their Excel knowledge or skill gaps

For example, users new to administrative roles who are looking for practical insights applicable to a work environment rather than generic how to topics.

What You Need to Know?

Students will ideally have opened and used Excel at a basic, introductory or beginner level.

More details

Description
Unlock the power of Excel in your everyday tasks with this comprehensive business focused, beginner-friendly course.
Tailored specifically for those new to Excel or those who have never had formal training, this program provides a solid foundation along with step by step guidance through a range of essential tools, tips, features and functions to navigate and utilize spreadsheets effectively in a business environment.
You will begin by exploring how Excel treats data, as well as understanding the various mouse pointers and their timesaving features. As you progress you will deep dive into essential formatting tools, tips and techniques to produce professional looking spreadsheets every time.
You will also learn how to organize data, create common functions, and produce basic charts to boost your productivity and confidence in the workplace.
The course is structured to provide you with practical insights with each lesson exploring real-world examples.Â There is also a downloadable exercise file to practice on to reinforce the concepts taught, ensuring you can immediately apply what you've learned to your job.
By the end of the program, you will have gained the skills and confidence you need to use Excel as a part of your everyday tool kit for business activities helping improve your productivity, confidence and efficiency.
Regardless of your role in finance, logistics, administration or any role that involves data management, this program is the first step towards mastering Excel in the workplace.
Who this course is for:
This course is written for users of Excel who have had little to no training or are looking to fill their Excel knowledge or skill gaps
For example, users new to administrative roles who are looking for practical insights applicable to a work environment rather than generic how to topics.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Donna Hanson

Instructor's Courses

About DonnaWant to reduce your stress and frustration with everyday Microsoft Office programs and also increase your productivity?Want to learn practical tools and features of Microsoft Office programs that relate back to what you do in your day to day work? Then I'd love to help.For over 20 years, I've has been working as a speaker, trainer and educator to businesses large and small. I believes the very technology that was supposed to make life easier has in fact created more work.I am passionate about productivity and believe that we need to get stuff done, faster and smarter so we can get back to enjoying our lives with those we love.My style is practical, engaging and fun, because I think when things are fun we learn more! I have a degree in Training & Development, and years of real world business experience which means no jargon sessions that focus on what you need to know to get more done in less time with less stressJoin me here and let me help you:- Learn what you need to do to make analyzing data in Microsoft Excel EASY.- Create documentation In Microsoft Word that is practical and professional EVERY SINGLE TIME.- Learn how to make your next presentation with Microsoft PowerPoint engaging and effectively get your message across to your audience.- Learn SECRET tips to help you IMMEDIATELY increase your productivity AND reduce your stress with Microsoft Word & ExcelHer motto is "You don't know what you don't know."

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.