Mar

16

2022

Excel 2021/365 Starter Pack: Beginner to Intermediate Course

Laser 16 Mar 2022 13:33 LEARNING » e-learning - Tutorial

Excel 2021/365 Starter Pack: Beginner to Intermediate Course
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 190 lectures (20h 29m) | Size: 10.3 GB

Master Excel spreadsheets with this bner to intermediate training course!

What's new in Excel 2021
Navigating the Excel 2021 interface
Utilizing useful keyboard shortcuts to increase productivity
Using basic and intermediate Excel formulas and functions
Effectively applying formatting to cells and using conditional formatting
Linking to other worksheets and workbooks
Protecting and sharing workbooks
Saving your workbook in different file formats
Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
How to use Excel tables to structure data and make it easy to update
Sorting and filtering data using advanced features and new Excel formulas
Working with date and functions and extracting data using text functions
How to control user input with data validation
Importing data and cleaning it up before analysis
Using WhatIf analysis tools to see how chag inputs affect outcomes.
Analyzing data using PivotTables and representing data visually with charts and PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors

Microsoft Excel 2021/365 desktop version for Windows installed and ready to use on your computer.
Basic knowledge of Microsoft Excel is helpful but not required. This course is suitable for absolute bners

Exercise and demo files included
We've combined our Excel 2021/365 for Absolute Bners and Excel 2021/365 Intermediate courses to give you the ultimate starter pack to jump-start your spreadsheet journey!
Whether you're an Excel novice or already have some Excel knowledge, this course can help you get the ball rolling. This course bundle will give you a great Excel foundation or build on those skills you already have. It's also perfect for students who have bner to intermediate skills in an older version of Excel and are looking to explore the newest features.
Excel 2021 is Microsoft's latest stand-alone version of Excel, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.
The only prerequisite for this course is a working copy of Excel 2021 or Excel 265.
This course covers
Becoming familiar with what's new in Excel 2021
Navigating the Excel 2021 interface
Utilizing useful keyboard shortcuts to increase productivity
Creating your first Excel spreadsheet
Using basic and intermediate Excel formulas and functions
Effectively applying formatting to cells and using conditional formatting
Using Excel lists and master sorting and filtering
Working efficiently by using the cut, copy, and paste options
Linking to other worksheets and workbooks
Analyzing data using charts
Inserting pictures in a spreadsheet
Working with views, zooms, and freezing panes
Setting page layout and print options
Protecting and sharing workbooks
Saving your workbook in different file formats
Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
Constructing functional and flexible lookup formulas
How to use Excel tables to structure data and make it easy to update
Extracting unique values from a list
Sorting and filtering data using advanced features and new Excel formulas
Working with date and functions
Extracting data using text functions
Importing data and cleaning it up before analysis
Analyzing data using PivotTables
Representing data visually with PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to control user input with data validation
Using WhatIf analysis tools to see how chag inputs affect outcomes.
This course includes
20+ hours of video tutorials
180+ individual video lectures
Course and exercise files to follow along
Certificate of completion

Microsoft Excel novice
Those who need an Excel refresher and want to improve their knowledge
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2021/365 knowledge.




DOWNLOAD
uploadgig.com



rapidgator.net


nitro.download

High Speed Download

Add Comment

  • People and smileys emojis
    Animals and nature emojis
    Food and drinks emojis
    Activities emojis
    Travelling and places emojis
    Objects emojis
    Symbols emojis
    Flags emojis