“To be an accountant in the age of spreadsheet program is — well, almost sexy.” — Steven Levy in “A Spreadsheet Way of Knowledge” (1984)
Howdy and welcome to Unit 3, Create Cells and Ranges.
In this unit we develop some core skills when it comes to entering data into our Excel worksheets. We look at the different ways to not only enter data but to also make life so much easier with features like AutoFill, AutoComplete, and Drop-Down List to name just a few.
We also discover how to format our cells so they are easier to use just plan old nicer to look at. Then we end with the find and replace feature that can save you hours of time in large workbooks.
About The Course
Microsoft Excel is the spreadsheet program of choice for companies, governments agencies, and organizations around the world. We have specifically designed this course to help you go from beginner to a certified professional.
In this course, you will learn how to use the most recent versions of Microsoft Excel, the 2019 and constantly updated Office 365 version.
This course follows the objectives created by Microsoft and ensures that not only will you develop the knowledge, skills, and abilities (KSAs) to use Excel but you will also be prepared to take and pass the Microsoft Office Specialist 77-727 Excel Core exam.
In this course, you will develop the KSAs to: