Excel Basic

Course Syllabus

Getting Started Spreadsheet terminology Exploring the Excel window Getting help Opening and navigating workbooks Closing workbooks Entering and Editing data Creating workbooks Entering and editing labels and values Entering and editing formulas Saving and updating workbooks Modifying a Worksheet Moving and copying data Moving and copying formulas Using absolute references Inserting and deleting ranges

Using Functions Entering functions Using AutoSum Using AVERAGE, MIN, and MAX Formatting Worksheets Formatting text Formatting rows and columns Number formatting Using Format Painter and AutoFormat Printing Preparing to print Page Setup options Printing worksheets Creating Charts Chart basics Modifying charts Printing charts