MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Excel 2013 The Basics

Course Summary

This course covers the basic functions and features of Excel 2013.

• +

Course Syllabus

• Getting Started with Microsoft Excel 2013
• Instructor Introduction
• Course Introduction
• Section 01 Introduction
• Topic A: Identify the Elements of the Excel Interface
• Microsoft Excel 2013
• The Excel Interface
• Cell References and the Formula Bar
• The Go To Feature
• ScreenTips and Key Tips
• Demo 1-1: Excel Elements
• Topic B: Create a Basic Worksheet
• The Ribbon
• The Backstage View
• Data Types
• Excel 2013 File Formats
• SkyDrive
• The Convert Option
• The Compatibility Checker
• Demo 1-2: Creating a Spreadsheet
• Topic C: Use the Help System
• The Excel Help Window
• Demo 1-3: Using Help System
• Review
• Getting Started with Microsoft Excel 2013
• Workbook
• Performing Calculations
• Section 02 Introduction
• Topic A: Create Formulas in a Worksheet
• Formulas
• The Formula Bar
• Elements of an Excel Formula
• Common Mathematical Operators
• The Order of Operations
• Demo 2-1: Creating Formulas
• Topic B: Insert Functions in a Worksheet
• Functions
• The Function Library
• Using the AutoSum Button
• The Formula AutoComplete Feature
• Demo 2-2: Insert Functions in a Worksheet
• Topic C: Reuse Formulas
• The Cut, Copy, and Paste Commands
• Relative References
• Absolute References
• Mixed References
• Demo 2-3: Reusing Formulas
• Review
• Performing Calculations
• Workbook
• Modifying a Worksheet
• Section 03 Introduction
• Topic A: Manipulate Data
• The Undo and Redo Commands
• Auto Fill
• Live Preview
• The Clear Button
• Demo 3-1: Manipulating Data
• Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
• The Insert and Delete Options
• The Hide and Unhide Options
• Demo 3-2: Adjust Display of Columns
• Topic C: Search for and Replace Data
• Cell Names and Range Names
• The Find Command
• The Replace Command
• Demo 3-3: Searching for and Replacing Data
• Topic D: Spell Check a Worksheet
• The Spelling Dialog Box
• Demo 3-4: Spell Checking a Worksheet
• Review
• Modifying a Worksheet
• Workbook
• Formatting a Worksheet
• Section 04 Introduction
• Topic A: Modify Fonts
• Fonts
• The Font Group
• The Format Cells Dialog Box
• Galleries
• Live Preview and Formatting
• The Mini Toolbar
• Demo 4-1: Modifying Fonts
• Topic B: Add Borders and Color to Cells
• Border Options
• Sheet Backgrounds
• Demo 4-2: Adding Borders and Color to Cells
• Topic C: Apply Number Formats
• Number Formats
• Number Formats in Excel
• Demo 4-3: Applying Number Formats
• Topic D: Align Cell Contents
• The Indent Commands
• The Wrap Text Command
• Orientation Options
• Demo 4-4: Aligning Cell Contents
• Topic E: Apply Cell Styles
• Cell Styles
• Demo 4-5: Applying Cell Styles
• Review
• Formatting a Worksheet
• Workbook
• Printing Workbook Contents
• Section 05 Introduction
• Topic A: Define the Basic Page Layout for a Workbook
• The Page Setup Dialog Box
• Workbook Views
• Page Margins
• Page Orientation
• Demo 5-1: Previewing a Workbook Before Print
• Demo 5-2: Applying Print Changes
• Topic B: Refine the Page Layout and Apply Print Options
• Zoom Options
• Page Breaks
• The Print Area
• Printing Titles
• Scaling Options
• Demo 5-3: Refine Print Layout
• Review
• Printing Workbook Contents
• Workbook
• Managing Large Workbooks
• Section 06 Introduction
• Topic A: Format Worksheet Tabs
• Tab Formatting Options
• Demo 6-1: Formatting Worksheet Tabs
• Topic B: Manage Worksheets
• Insertion and Deletion Options for Worksheets
• Hide and Unhide Options
• Worksheet References in Formulas
• Demo 6-2: Managing Worksheets
• Topic C: Manage the View of Worksheets and Workbooks
• The Split Command
• The Freeze Panes Options
• The Arrange All Command
• The View Side by Side Command
• Demo 6-3: Managing the View of Worksheets and Workbooks
• Review
• Managing Large Workbooks
• Workbook
• Customizing the Excel Environment
• Section 07 Introduction
• Topic A: Customize General and Language Options
• The Excel Options Dialog Box
• The General Options
• The Language Options
• Demo 7-1: Customizing General and Language Options
• Topic B: Customize Formula Options
• The Formulas Options
• Demo 7-2: Formula Options
• Topic C: Customize Proofing and Save Options
• The Proofing Options
• The Save Options
• Demo 7-3: Customizing Proofing and Save Options
• The Customize Ribbon Options
• Topic E: Customize the Functionality of Excel by Enabling Add-Ins
• The DEVELOPER Tab
• Demo 7-5: Customizing the Functionality of Excel
• Topic F: Customize Advanced and Trust Center Options
• The Trust Center Options
• Demo 7-6: Customizing Advanced and Trust Center Options
• Review
• Course Closure
• Customizing the Excel Environment
• Workbook

Course Fee:
USD 49

Self-Study

Course Status:

Active

1 - 4 hours / week

Related Posts: