Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Excel 2019 Beginner Tutorial
Play lesson

Excel Training - Excel 2019 Beginner Tutorial

4.0 (5)
41 learners

What you'll learn

This course includes

  • 102 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Excel 2019 Beginner Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/k7acppwc Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel. What it is: Microsoft’s spreadsheet application used to clean and organize data. What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks. Start 0:00 Introduction 0:03 Start Screen & Templates 0:59 Ribbon & Quick Access Toolbar 6:04 Backstage View 12:44 Smart Lookup & Tell Me 15:33 Interface 18:49 Navigation 22:36 Keyboard Shortcuts 26:03 Entering Text 30:18 Number Formats 36:08 Deleting & Formatting 40:20 AutoSum 44:55:01 Simple Formulas 49:29 Simple Functions (Part 1) 52:57 Simple Functions (Part 2) 59:18 Absolute Referencing 1:03:01 Moving & Copying Data 1:09:15 Inserting Rows & Columns 1:12:16 AutoFill 1:16:57 Cell Styles 1:22:52 Worksheet Themes 1:27:26 Excel Templates 1:32:40 Freeze Panes 1:35:39 Grouping Worksheets 1:41:01 Page Layout View 1:43:56 Custom Views 1:45:54 Spell Check 1:48:13 Printing 1:49:58 #Excel Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere