Microsoft Excel: Beginners to Advanced (All-In-One)

Focused View

Cheriamor Houston

4:56:47

121 View

1 - Introduction

1 - Introduction Course Content.mp4

02:16

2 - Excel-Beginners-to-Advanced-Specialized-Study-Plan.docx

2 - NEW Specialized Study Plan.html

2 - Navigating Excel

3 - Introduction to Navigating Excel.mp4

16:34

4 - Adding and Scrolling Worksheets.mp4

01:34

5 - Worksheet vs Workbook.mp4

00:21

6 - Naming and Coloring Tabs.mp4

01:02

7 - Moving and Copying Worksheets.mp4

01:38

8 - Zooming and Page View Options.mp4

02:03

9 - Cells and Gridlines.mp4

07:13

10 - Navigating the Ribbon.mp4

06:05

11 - Save vs Save As.mp4

04:28

3 - Beginners Knowledge

12 - Adjusting Column Sizes and Wrapping Text.mp4

03:11

13 - Calculations Using the SUM Function.mp4

02:22

14 - Calculations Adding and Multiplying.mp4

04:36

15 - Highlighting Cells Merging Cells and Changing Row Height.mp4

06:04

16 - Borders Frames Aligning Text and Adding Color.mp4

03:19

17 - Adding Columns and Rows and Sorting I Alphabetizing.mp4

09:04

18 - Formulas Finding Averages Adding Hyperlinks.mp4

02:47

19 - Adding Notes and Comments Duplicating and Moving Content.mp4

15:44

20 - Formulas Subtracting Dividing Adding Introducing Tables and Charts.mp4

13:21

21 - Page Layout Headers Footers and Page Numbers.mp4

05:54

22 - Formatting to Print on One Page Saving As a PDF.mp4

07:36

23 - DOWNLOAD Assignments List I Optional.html

23 - Udemy-eTeach-uExcel-Assignments-List-1-BICS.xlsx

24 - DOWNLOAD Assignment Workbook I Optional.html

24 - Udemy-Excel-Course-Assignment-Workbook-1-BICS.xlsx

4 - Next Level Intermediate Office Tips and Knowledge

25 - Introduction to Section.mp4

05:37

26 - Creating a Dropdown List.mp4

03:50

27 - Date Format Options and Calculating Age.mp4

04:54

28 - Working With Payment Balances.mp4

02:50

29 - Adding Checkmarks and Checkboxes Numbering Sequentially.mp4

13:23

30 - Finding and Removing Duplicates.mp4

08:04

31 - Preventing Duplicates.mp4

04:27

32 - Freezing Panes.mp4

04:00

33 - Sorting II Numerical Data.mp4

02:32

34 - Introduction to Pivot Tables.mp4

14:44

35 - Protecting and Unprotecting.mp4

12:33

36 - DOWNLOAD Assignments List II Optional.html

36 - Udemy-eTeach-uExcel-Assignments-List-2-CC.xlsx

37 - DOWNLOAD Assignments Workbook II Optional.html

37 - Udemy-eTeach-uExcel-Assignment-Workbook-2-CC.xlsx

5 - Advanced Functions and Formulas

38 - Functions vs Formulas.mp4

03:51

39 - Review of Basic Functions and Formulas.mp4

08:43

40 - IF.mp4

02:40

41 - COUNT.mp4

06:21

42 - COUNTIF.mp4

04:00

43 - COUNTIFS.mp4

05:17

44 - COUNTA.mp4

04:27

45 - SUMIF.mp4

02:25

46 - SUMIFS.mp4

03:08

47 - DATE & DATEIF.mp4

12:04

48 - SUMPRODUCT.mp4

02:48

49 - ROUND.mp4

03:23

50 - Surprise Content.mp4

03:38

51 - CONCATENATE.mp4

03:57

52 - Extra Content Separating Text From 1 to 2 Columns.mp4

06:29

53 - TRANSPOSE.mp4

03:40

54 - LOOKUP.mp4

06:19

55 - XLOOKUP Primary Features of XLOOKUP.mp4

01:26

56 - XLOOKUP Previous Functions and Syntax.mp4

02:36

57 - XLOOKUP Example of Use.mp4

03:36

58 - XLOOKUP Review of Guidelines on General Use of XLOOKUP.mp4

03:48

59 - XLOOKUP If Not Found Argument.mp4

03:56

60 - XLOOKUP Extra Pointer.mp4

02:10

6 - Additional Quick TipsShort Tutorials Videos Only

61 - Add Times to a Meeting or Event Schedule QUICKLY.mp4

00:48

62 - Add Days and Months QUICKLY Without Typing All Individually.mp4

00:40

63 - QUICK Count OptionsNumber Rows of Data.mp4

00:31

7 - DOWNLOAD EXTRA 50 Shortcuts Guide

64 - 50-Excel-Shortcuts-Guide-by-Cheriamor.pdf

64 - DOWNLOAD 50 Excel Shortcuts Guide.html

Description

Go From No Knowledge to Using Formulas to Make Your Office Work Quicker and Easier

What You'll Learn?

Learn Excel from beginners to advanced
Learn basic and advanced functions and formulas
Understand how to perform tasks quicker and easier
Learn how to apply knowledge to real-world work projects
Gain confidence through knowledge
Gain knowledge that you can use in almost any field!

Who is this for?

Beginners and anyone who wishes to advance their knowledge in Microsoft Excel.

More details

Description
This course is a detailed, all-inclusive curriculum in Microsoft Excel. It is outlined in 3 parts: Beginners/Navigating Excel, Next Level (working with databases), and Advanced Functions and Formulas.
There are a little more than 50 videos of step-by-step instruction on how to navigate Excel, how to do highly desired tasks, and how to use functions and formulas to automate certain tasks to make your work quicker and easier.
It includes a downloadable Customizable Study Guide to help you get through the course in less than 1 month (if you so desire), a Shortcuts Guide, and downloadable optional assignments to practice what you learn.

What Youâ€™ll Learn:
From basic knowledge to fun things in working with databases, to advanced functions and formulas (3-part course for one price)
Navigating Excel
Course is taught using sample projects
Formulas are taught using real-work world scenarios for office jobs
Basic & Advanced functions and formulas, such as XLOOKUP, TRANSPOSE, SUMPRODUCT, different COUNT, SUM, and DATE functions, and more.
Intro to Pivot Tables
Finding, Removing, and Preventing Duplicate Data
Formatting to Print on one sheet
Creating drop-down lists
Freezing panes
Sorting data
Splitting text from one column into two
Merging text from two columns into one
Calculating age
Adding checkmarks, checkboxes, and progress marks
Easy-to-understand, step-by-step instructions

This Course Includes:
Over 50 videos of instruction
A Customizable Study Plan to help you keep track and finish what you start to get your moneyâ€™s worth
Downloadable files to follow along and practice (optional)
50 Excel Shortcuts Guide
Certificate of Completion
Who this course is for:
Beginners and anyone who wishes to advance their knowledge in Microsoft Excel.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Cheriamor Houston

Instructor's Courses

Cheriamor Houston is a Program Coordinator and former Development Manager and Administrator with over 20 years in the nonprofit sector. She has worked in many facets of nonprofit and managed multiple projects. Cheriamor’s areas of experience in nonprofit include community engagement, social media marketing, office administration, special and annual events, graphic design, volunteer coordination, human resources, and fundraising management, using Excel in many of these capacities. Cheriamor has led a number of training courses, including a series in Excel. She has a Master’s of Nonprofit Administration and three non-profit certificates.

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.