![]() |
Microsoft Excel Introduction1 Day Course Description This instructor-led, hands-on course teaches students the basic skills needed to enter and edit information, write formulas, format cells, and print spreadsheets in Microsoft Excel. Prerequisites This course is designed for users that are new to Microsoft Excel or are self-taught. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Windows course or have equivalent knowledge. You should feel comfortable using a mouse and have a working knowledge of the Windows environment. Is this the right level for you? Take our free assessment! Please contact our office at 202.682.4500 if you have any questions. Building a Simple Excel Workbook Understanding Important Screen Elements Opening and Reviewing a Workbook Entering Text, Numbers, and Dates Editing and Deleting Cell Contents Understanding Mouse Pointer Shapes and Selecting Ranges Moving Data by Drag-and-Drop Copying Data with the Fill Handle Reversing Mistakes with Undo and Redo Spell Checking Your Work Saving and Closing a File Using Help Working with Excel Worksheets Renaming Worksheets Adding Color to Sheet Tabs Moving Worksheets Adding and Deleting Worksheets Writing and Copying Excel Formulas Writing Formulas Using Functions in Formulas Using the AutoSum Button Copying Formulas Using the Insert Function Tool Using =TODAY to Insert the Current Date Using Dates in Formulas Using AutoCalculate Formatting An Excel Worksheet Changing Column Widths Applying Fonts, Bold, Underline, and Italics Aligning Data in Cells Centering Data Across Columns Wrapping Text Formatting Numbers, Formulas, and Dates Adding Borders and Fill Color Inserting and Deleting Columns or Rows Inserting Comments Removing Formatting and Comments Working with Larger Excel Workbooks Keeping Headings on the Screen as You Work Previewing Before Printing Printing Row and Column Headings Hiding Columns Sorting Rows of Information Printing a Worksheet
Other Helpful Links |
||
©2008 Softek Services, Inc. All Rights Reserved. |
|||