Mastering Microsoft Excel 2019 & 365 Training Tutorial

Mastering Microsoft Excel 2019 & 365 Training Tutorial, available at $19.99, has an average rating of 4.6, with 213 lectures, based on 5 reviews, and has 19 subscribers.

You will learn about Create both basic and advanced spreadsheets Create complex formulas Chart and graph data Create PivotTables and PivotCharts Audit worksheets Manage security features Much more! This course is ideal for individuals who are Students new to Microsoft Excel or Office employees or Executives or Managers or Assistants or Accounting professionals It is particularly useful for Students new to Microsoft Excel or Office employees or Executives or Managers or Assistants or Accounting professionals.

Enroll now: Mastering Microsoft Excel 2019 & 365 Training Tutorial

Summary

Title: Mastering Microsoft Excel 2019 & 365 Training Tutorial

Price: $19.99

Average Rating: 4.6

Number of Lectures: 213

Number of Published Lectures: 213

Number of Curriculum Items: 213

Number of Published Curriculum Objects: 213

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Create both basic and advanced spreadsheets
Create complex formulas
Chart and graph data
Create PivotTables and PivotCharts
Audit worksheets
Manage security features
Much more!

Who Should Attend

Students new to Microsoft Excel
Office employees
Executives
Managers
Assistants
Accounting professionals

Target Audiences

Students new to Microsoft Excel
Office employees
Executives
Managers
Assistants
Accounting professionals

Unlock the Power of Microsoft Excel with Our Comprehensive Tutorial!

Discover the world of Excel like never before with “Mastering Excel Made Easy,” your go-to learning resource from TeachUcomp, Inc.

What Awaits You:

212 in-depth video lessons
Over 10 hours of comprehensive instruction
Suitable for beginners to advanced users

Our experienced instructor will be your guide as you embark on a step-by-step journey through each chapter and lesson. Learn effortlessly by watching and listening, as if your instructor is right there beside you.

Your Learning Arsenal:

A detailed, 453-page printable classroom instruction manual
Loaded with additional images and practice exercises for hands-on learning

Uncover the art of creating and formatting spreadsheets, crafting stunning charts, and mastering pivot tables, and much more. Each Excel function and feature comes to life during this media-rich learning experience.

The TeachUcomp Advantage:

Built on years of classroom training experience and teaching expertise
Crafted for ease of use and understanding
Tailorable to your unique learning preferences

Whether you’re a complete Excel novice or making the leap from an older version, our Excel tutorial equips you with the knowledge and skills to become a proficient user. It’s like having a personal Excel mentor at your disposal.

Ready to Excel:

With just a click, your journey to Excel mastery begins. Dive into our complete Excel tutorial or explore the manual, and you’ll be well on your way to becoming an Excel pro!

Experience the convenience of learning and unleash your Excel potential – enroll in “Mastering Excel Made Easy” today!

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Course Introduction

Chapter 2: Getting Acquainted with Excel

Lecture 1: About Excel

Lecture 2: The Excel Environment

Lecture 3: The Title Bar

Lecture 4: The Ribbon

Lecture 5: The “File” Tab and Backstage View

Lecture 6: Scroll Bars

Lecture 7: The Quick Access Toolbar

Lecture 8: Touch Mode

Lecture 9: The Formula Bar

Lecture 10: The Workbook Window

Lecture 11: The Status Bar

Lecture 12: The Workbook View Buttons

Lecture 13: The Zoom Slider

Lecture 14: The Mini Toolbar

Lecture 15: Keyboard Shortcuts

Chapter 3: File Management

Lecture 1: Creating New Workbooks

Lecture 2: Saving Workbooks

Lecture 3: Closing Workbooks

Lecture 4: Opening Workbooks

Lecture 5: Recovering Unsaved Workbooks

Lecture 6: Opening a Workbook in a New Window

Lecture 7: Arranging Open Workbook Windows

Lecture 8: Freeze Panes

Lecture 9: Split Panes

Lecture 10: Hiding and Unhiding Workbook Windows

Lecture 11: Comparing Open Workbooks

Lecture 12: Switching Open Workbooks

Lecture 13: Switching to Full Screen View

Lecture 14: Working with Excel File Formats

Lecture 15: AutoSave Online Workbooks

Chapter 4: Data Entry

Lecture 1: Selecting Cells

Lecture 2: Entering Text into Cells

Lecture 3: Entering Numbers into Cells

Lecture 4: AutoComplete

Lecture 5: Pick from Drop-Down List

Lecture 6: Flash Fill

Lecture 7: Selecting Ranges

Lecture 8: Ranged Data Entry

Lecture 9: Using AutoFill

Chapter 5: Creating Formulas

Lecture 1: Ranged Formula Syntax

Lecture 2: Simple Formula Syntax

Lecture 3: Writing Formulas

Lecture 4: Using AutoSum

Lecture 5: Inserting Functions

Lecture 6: Editing a Range

Lecture 7: Formula AutoCorrect

Lecture 8: AutoCalculate

Lecture 9: Function Compatibility

Chapter 6: Copying and Pasting Formulas

Lecture 1: Relative References and Absolute References

Lecture 2: Cutting, Copying, and Pasting Data

Lecture 3: AutoFilling Cells

Lecture 4: The Undo Button

Lecture 5: The Redo Button

Chapter 7: Columns and Rows

Lecture 1: Selecting Columns and Rows

Lecture 2: Adjusting Column Width and Row Height

Lecture 3: Hiding and Unhiding Columns and Rows

Lecture 4: Inserting and Deleting Columns and Rows

Chapter 8: Formatting Worksheets

Lecture 1: Formatting Cells

Lecture 2: The Format Cells Dialog Box

Lecture 3: Clearing All Formatting from Cells

Lecture 4: Copying All Formatting from Cells to Another Area

Chapter 9: Worksheet Tools

Lecture 1: Inserting and Deleting Worksheets

Lecture 2: Selecting Multiple Worksheets

Lecture 3: Navigating Worksheets

Lecture 4: Renaming Worksheets

Lecture 5: Coloring Worksheet Tabs

Lecture 6: Copying or Moving Worksheets

Chapter 10: Setting Worksheet Layout

Lecture 1: Using Page Break Preview

Lecture 2: Using the Page Layout View

Lecture 3: Opening the Page Setup Dialog Box

Lecture 4: Page Settings

Lecture 5: Setting Margins

Lecture 6: Creating Headers and Footers

Lecture 7: Sheet Settings

Chapter 11: Printing Worksheets

Lecture 1: Previewing and Printing Worksheets

Chapter 12: Helping Yourself

Lecture 1: Using Excel Help

Lecture 2: The Tell Me Bar

Lecture 3: Smart Lookup

Chapter 13: 3D Formulas

Lecture 1: Creating 3D Formulas

Lecture 2: 3D Formula Syntax

Lecture 3: Creating 3D Range References

Chapter 14: Named Ranges

Lecture 1: Naming Ranges

Lecture 2: Creating Names from Headings

Lecture 3: Moving to a Named Range

Lecture 4: Using Named Ranges in Formulas

Instructors

TeachUcomp, Inc.
Quality Software Training

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 0 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu