Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 8.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Mastering Microsoft Excel 2019 & 365 Training Tutorial

A Complete Beginner's Guide to Excel
Rating: 0.0 out of 50.0 (0 ratings)
9 students
Created by TeachUcomp, Inc.
Published 8/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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!

Requirements

  • Good command of operating system
  • Basic Microsoft Office skills helpful (Especially Word)

Description

You can learn Microsoft Excel with this comprehensive Excel tutorial from TeachUcomp, Inc. Mastering Excel Made Easy features 212 video lessons with over 10 hours of introductory through advanced instruction. With our course you can easily learn by watching and listening as your knowledgeable instructor guides you through each different chapter and lesson step-by-step. Plus, you can reinforce your learning with the text of our printable classroom instruction manual (453 pages) that will include additional images and practice exercises to do in your own program. Our Excel tutorial shows how to effectively create and format spreadsheets, charts, pivot tables and much more. During this media-rich learning experience, you will see each feature and function performed just as if your instructor were there with you. Learning has never been more easy and convenient.

Our Excel tutorial is based on years of classroom training experience and teaching techniques. This lets us create an Excel tutorial course that is easy to use and understand. You can also customize it to meet your personal learning needs. Just watch our complete Excel tutorial or open a manual, and you’re on your way to mastering Excel! Whether you are completely new to Excel or upgrading from an older version, this Excel course empowers you with the knowledge and skills to become a proficient user.

Who this course is for:

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

Course content

36 sections • 213 lectures • 8h 16m total length

  • Preview01:03

  • Preview01:30
  • Preview02:01
  • Preview01:31
  • Preview02:01
  • Preview01:25
  • Preview00:20
  • Preview02:50
  • Touch Mode
    01:13
  • The Formula Bar
    00:47
  • The Workbook Window
    02:45
  • The Status Bar
    01:56
  • The Workbook View Buttons
    01:08
  • The Zoom Slider
    01:22
  • The Mini Toolbar
    00:22
  • Keyboard Shortcuts
    01:52

  • Creating New Workbooks
    00:33
  • Saving Workbooks
    04:58
  • Closing Workbooks
    00:27
  • Opening Workbooks
    05:15
  • Recovering Unsaved Workbooks
    01:06
  • Opening a Workbook in a New Window
    00:43
  • Arranging Open Workbook Windows
    01:40
  • Freeze Panes
    01:27
  • Split Panes
    02:12
  • Hiding and Unhiding Workbook Windows
    00:27
  • Comparing Open Workbooks
    01:01
  • Switching Open Workbooks
    00:21
  • Switching to Full Screen View
    00:38
  • Working with Excel File Formats
    03:31
  • AutoSave Online Workbooks
    03:58

  • Selecting Cells
    01:39
  • Entering Text into Cells
    01:51
  • Entering Numbers into Cells
    02:25
  • AutoComplete
    00:49
  • Pick from Drop-Down List
    00:42
  • Flash Fill
    03:28
  • Selecting Ranges
    05:03
  • Ranged Data Entry
    00:50
  • Using AutoFill
    02:44

  • Ranged Formula Syntax
    01:24
  • Simple Formula Syntax
    00:51
  • Writing Formulas
    04:39
  • Using AutoSum
    01:58
  • Inserting Functions
    03:14
  • Editing a Range
    01:08
  • Formula AutoCorrect
    00:29
  • AutoCalculate
    00:59
  • Function Compatibility
    02:07

  • Relative References and Absolute References
    03:40
  • Cutting, Copying, and Pasting Data
    03:04
  • AutoFilling Cells
    00:46
  • The Undo Button
    00:49
  • The Redo Button
    00:40

  • Selecting Columns and Rows
    01:33
  • Adjusting Column Width and Row Height
    01:53
  • Hiding and Unhiding Columns and Rows
    01:10
  • Inserting and Deleting Columns and Rows
    03:26

  • Formatting Cells
    02:57
  • The Format Cells Dialog Box
    06:00
  • Clearing All Formatting from Cells
    00:21
  • Copying All Formatting from Cells to Another Area
    01:01

  • Inserting and Deleting Worksheets
    01:09
  • Selecting Multiple Worksheets
    01:03
  • Navigating Worksheets
    01:09
  • Renaming Worksheets
    00:48
  • Coloring Worksheet Tabs
    00:59
  • Copying or Moving Worksheets
    02:00

  • Using Page Break Preview
    01:18
  • Using the Page Layout View
    00:39
  • Opening the Page Setup Dialog Box
    00:34
  • Page Settings
    01:37
  • Setting Margins
    00:52
  • Creating Headers and Footers
    03:42
  • Sheet Settings
    02:38

Instructor

TeachUcomp, Inc.
Quality Software Training
TeachUcomp, Inc.
  • 4.3 Instructor Rating
  • 19,140 Reviews
  • 257,738 Students
  • 86 Courses

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.