Logo
uCertify

Microsoft Excel 2021 MSEXCEL.AD1

uCertify, Helena, Missouri, United States, 64459


The Microsoft Excel course for beginners teaches you the basics of this daily accounting software that’s widely used for storing, organizing, and analyzing spreadsheet data. Microsoft Excel 2021

This course includes: Interactive Lessons Gamified TestPrep Hands-On Labs Instructor Led (Add-on) AI Tutor (Add-on) This Microsoft Excel training course teaches you the foundations of Excel worksheets for storing, organizing, calculating, updating, analyzing, and presenting data effectively. Whether you are a novice or have some knowledge about spreadsheets, this Excel for beginners online training course is ideal for learning the core functionalities and features of MS worksheets. As the Excel training course progresses, you’ll learn to use and execute more advanced features with hands-on training on our ‘Software Simulation Labs’. To make it a fun learning experience, we have also added interesting features like flashcards, pre- and post-assessments, quizzes, progress tracking, and test preps along with the course content. Skills You’ll Get

Confidently enter, edit, and format data in spreadsheets Using advanced tools like conditional formatting to organize, filter, and sort data Using functions and formulas to automate calculations and data manipulation Representing data with impactful graphs and charts Working with multiple worksheets for comprehensive projects Setting up the page layout and print options Course Structure

Getting Started with Excel 2021

Exporting Ribbon Customizations as a File Adding and Replacing Data in a Cell Creating and Saving a Workbook Copying and Pasting the Data

Performing Calculations

Creating Worksheet Formulas Determining the Minimum Value Determining the Maximum Value Reusing Formulas Calculating the Sum Calculating the Average

Modifying a Worksheet

Hiding the Columns Deleting a Column Inserting a Cell Range Deleting a Row Hiding the Rows Adjusting the Columns

Formatting a Worksheet

Adding a Hyperlink Applying Fill Color Adding Borders Trimming the Decimal Places Adding the Date to a Worksheet Creating a Template

Printing Workbooks

Adding the Page Number to the Worksheet

Managing Workbooks

Deleting a Worksheet Hiding a Worksheet Adding a New Worksheet Adding Color to the Worksheet Tab Making a Copy of the Worksheet Freezing the Top Row

This course is designed for those with little to no prior experience with MS Excel 2021. Boost Your Proficiency in Microsoft Excel 2021

This training course helps you prepare the basics of MS Worksheets for a successful career.

#J-18808-Ljbffr