Mastering Excel 365 - Beginner (2022)
Published 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.59 GB | Duration: 2h 7m

Learn to use the world's most popular tool for analyzing and reporting on data.
What you'll learn
Navigate the interface including accessing commands and selecting and entering data
Create and save a new workbook
Perform calculations using formulas and functions
Format text cells and apply Conditional Formatting
Requirements
No prerequisites required to take this course.
Description
Learn how to use the world's most popular software tool for analyzing and reporting on data.When you master Excel, you have one of the most practical and valuable skillsets in modern business. You will learn to work wonders with your data—from organizing lists to creating charts and interactive reports. Excel will help you answer critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.This is our most requested training course!Topics covered include:Navigating the interfaceCreating and saving workbooksSelecting and entering dataPerforming calculationsFormatting dataAdding charts and graphicsSorting and filtering listsOver two hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!Objectives, You will be able to:Navigate the interface including accessing commands and selecting and entering dataCreate and save a new workbookPerform calculations using formulas and functionsFormat text cells and apply Conditional FormattingPrint workbooksAdd charts and graphics to your workbookSort and filter data in a listTarget Audience: Users who are new to Excel and want to learn foundational tools.Prerequisites: noneLearn to use the world's most popular tool for analyzing and reporting on data.Over two hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
Overview
Section 1: Getting Started
Lecture 1 Introduction
Lecture 2 Navigating Excel
Lecture 3 Using Commands
Lecture 4 Selecting Data
Section 2: Data Entry
Lecture 5 Creating a New Workbook
Lecture 6 Entering Cell Data
Lecture 7 Using AutoFill
Lecture 8 Getting Help
Section 3: Formulas and Functions
Lecture 9 Creating Formulas
Lecture 10 Inserting Functions
Lecture 11 Copying Formulas and Functions
Section 4: Formatting and Printing
Lecture 12 Applying Text Formats
Lecture 13 Applying Cell Styles
Lecture 14 Applying Basic Conditional Formatting
Lecture 15 Printing Workbooks
Section 5: Charts and Graphics
Lecture 16 Creating Charts
Lecture 17 Inserting Graphics
Section 6: Working with Lists
Lecture 18 Sorting Data
Lecture 19 Filtering Data
Users who are new to Excel and want to learn foundational tools.
Screenshots