(+64) 9 425 40 99| Contact Us| FAQ's | Dealer Login

Cart (0)
Shopping cart (0)
Total 0

Course detail

Home Course Office 2013 Excel P1

1585023793-office-excel-2013.jpg

Share with your friend

Office 2013 Excel P1

0 rate

0 purchased SKU: SKU_QLCAK40317


Available ONLY TO SMART TRAINER USERS

To Purchase this Product you must be a customer BUY A SMART TRAINER

10 USD Become a customer

Course Outline

  Lesson 01 - Getting Started with MS Excel 2013
  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
  Excel 2013 File Formats
  SkyDrive
  Demo 1-2: Creating a Spreadsheet
  Topic C: Use the Help System
  The Excel Help Window
  Demo 1-3: Using Help System
  Lesson 02 - Performing Calculations
  Topic A: Create Formulas in a Worksheet
  Elements of an Excel Formula
  Common Mathematical Operators
  Demo 2-1: Creating Formulas
  Topic B: Insert Functions in a Worksheet
  Using the AutoSum Button
  Demo 2-2: Insert Functions in a Worksheet
  Topic C: Reuse Formulas
  Demo 2-3: Reusing Formulas
  Lesson 03 - Modifying a Worksheet
  Topic A: Manipulate Data
  Auto Fill
  The Clear Button
  Demo 3-1: Manipulating Data
  Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  The Hide and Unhide Options
  Demo 3-2: Adjust Display of Columns
  Topic C: Search for and Replace Data
  Cell Names and Range Names
  Demo 3-3: Searching for and Replacing Data
  Topic D: Spell Check a Worksheet
  Demo 3-4: Spell Checking a Worksheet
  Lesson 04 - Formatting a Worksheet
  Topic A: Modify Fonts
  Live Preview and Formatting
  Demo 4-1: Modifying Fonts
  Topic B: Add Borders and Color to Cells
  Demo 4-2: Adding Borders and Color to Cells
  Topic C: Apply Number Formats
  Number Formats in Excel
  Demo 4-3: Applying Number Formats
  Topic D: Align Cell Contents
  Demo 4-4: Aligning Cell Contents
  Topic E: Apply Cell Styles
  Demo 4-5: Applying Cell Styles
  Lesson 05 - Printing Workbook Contents
  Topic A: Define the Basic Page Layout for a Workbook
  Header and Footer Settings
  Page Margins
  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
  Printing Titles
  Scaling Options
  Demo 5-3: Refine Print Layout
  Lesson 06 - Managing Large Workbooks
  Topic A: Format Worksheet Tabs
  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
  Demo 6-3: Managing the View of Worksheets and Workbooks
  Lesson 07 - Customizing the Excel Environment
  The Save Options
  The Advanced Options
  Topic A: Customize General and Language Options
  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
  Demo 7-3: Customizing Proofing and Save Options
  Topic D: Customize the Ribbon and Quick Access Toolbar
  The Customize Ribbon Options
  The Quick Access Toolbar Options
  Demo 7-4: Customizing the Quick Access Toolbar
  Topic E: Customize the Functionality of Excel by Enabling Add-Ins
  What Are Add-Ins?
  The Add-Ins Dialog Box
  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

Additional Information

author

Author

Administrator

Lessons

level

Level

Beginner

Related Courses

1584159122-Microsoft _project_2013.jpg
Microsoft Project 2013: Part 1
0 rate

0 purchased

10

1584921130-outlook-2013.jpg
Office 2013 Outlook P1
0 rate

0 purchased

10

1584921350-outlook-2013.jpg HOT
Office 2013 Outlook P2
0 rate

0 purchased

10

1584923038-microsoft-powerpoint-2013.jpg
Office 2013 PowerPoint P1
0 rate

0 purchased

10