Course Details
Course Outline
1 - Lesson 1: Getting Started with Excel
Topic A: Navigate the Excel User InterfaceTopic B: Use Excel CommandsTopic C: Create and Save a Basic WorkbookTopic D: Navigate in Excel for the WebTopic E: Enter Cell Data
2 - Lesson 2: Performing Calculations
Topic A: Create Worksheet FormulasTopic B: Insert FunctionsTopic C: Reuse Formulas and Functions
3 - Lesson 3: Modifying a Worksheet
Topic A: Adjust Cells, Columns, and RowsTopic B: Search for and Replace DataTopic C: Use Proofing and Research Tools
4 - Lesson 4: Formatting a Worksheet
Topic A: Apply Text FormatsTopic B: Apply Number FormatsTopic C: Align Cell ContentsTopic D: Apply Colors, Borders, and StylesTopic E: Apply Basic Conditional Formatting
5 - Lesson 5: Printing Workbooks
Topic A: Preview and Print a WorkbookTopic B: Set Up the Page LayoutTopic C: Configure Headers and Footers
6 - Lesson 6: Managing Workbooks
Topic A: Manage WorksheetsTopic B: Manage Workbook and Worksheet ViewsTopic C: Manage Workbook Properties
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets.
Prerequisites
Other Prerequisites
To ensure your success, you should have end-user skills with any current version of Windows, including being able to start and close applications, navigate basic file structures, manage files and folders, and access websites using a web browser. To obtain this level of skills and knowledge, you can take the following Logical Operations course:
Using Microsoft® Windows® 10 (Second Edition)