In this course, you will gain a foundational understanding of the basic functionality in Excel 2021. You will begin by navigating the Excel 2021 environment. From there, you will perform the basic tasks associated with creating and saving Excel worksheets and exploring the Help system. You will use formulas and functions to perform calculations in your worksheets, and you will modify worksheets by manipulating cells and data, by searching for and replacing data, and by checking for spelling errors. You will format worksheets and prepare them for printing. You will also begin working with larger workbooks that contain multiple worksheets. Finally, you will customize how Excel behaves to more closely meet your needs. This course is intended for people who want to gain the foundational understanding of Microsoft Office Excel 2021 that is necessary to create and develop worksheets.This course helps you tomprepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications
Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Before starting this course, delegates should be comfortable in the Windows environment, and be able to use Windows to manage information on their computers. Specific tasks the delegates should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.