Mastering Excel 2021 - Basics

[LeeAndro]

Published 10/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 26 lectures (2h 58m) | Size: 2.5 GB

Open and save existing workbooks
Manage rows, columns, and worksheets
Create and use named ranges
Add logical and conditional functions
Address formula errors
Apply cell and number formats, including cell styles and themes
Modify charts
Create Tables and PivotTables
Configure page settings and headers/footers for printing

No prerequisites needed

Target Audience: Users who know the basic elements of Excel 2021 and want to learn additional features.​

.

Course Goal: Users will know how to use and customize the basic elements of Excel 2021 and start perfog data analysis.

You will be able to

· Open and save existing workbooks

· Manage rows, columns, and worksheets

· Create and use named ranges

· Add logical and conditional functions

· Address formula errors

· Apply cell and number formats, including cell styles and themes

· Modify charts

· Create Tables and PivotTables

· Configure page settings and headers/footers for printing

Go beyond the basics of data entry to analyze your data and create visually appealing workbooks.

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you'll learn to make your spreadsheets easily readable and visually appealing, while including complex functions and summary reports. Excel expert Kathy Jones will also show you how to address function errors, customize your charts, and create and use tables and PivotTables to easily manipulate and summarize your data.

Topics covered include

· Managing rows, columns, and worksheets

· Creating and using named ranges

· Adding logical and conditional functions

· Addressing formula errors

· Applying cell and number formats, including cell styles and themes

· Modifying charts

· Creating Tables and PivotTables

· Configuring page settings and headers/footers for printing

Almost 3 hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!

Users who know the basic elements of Excel 2021 and want to learn additional features.

HomePage:

https://anonymz.com/https://www.udemy.com/course/mastering-excel-2021-basics/

DOWNLOAD

https://1dl.net/9jduf3o9yxwk/wRTrNCQh__Mastering_.part1.rar.html
https://1dl.net/b1xta3vbx39n/wRTrNCQh__Mastering_.part2.rar.html
https://1dl.net/q3f5gsoux8jq/wRTrNCQh__Mastering_.part3.rar.html