Mastering Excel 365 - Beginner (2022)

DOWNLOAD SETUP

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.

HOMEPAGE

https://www.udemy.com/course/mastering-excel-365-beginner-2022/