Microsoft Excel 2013 – Level 1

////Microsoft Excel 2013 – Level 1
Microsoft Excel 2013 – Level 1 2018-05-08T16:40:47+00:00

Microsoft Excel 2013 – Level 1

Course Length :  35 Hours

Course Description

This Microsoft® Excel 2013 Level 1 Guide teaches the information worker how to create and edit spreadsheets for business reports such as budgets or cash flow reports. The focus is placed on ensuring the basic skills are learned and can be applied to reports, including creating and editing simple formulas to handle common types of calculations.

Course Prerequisites

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.

Outline

Lesson 1: Introducing Excel

  • Understanding Basic Terminology
  • Mouse Symbols
  • Using the Quick Access Toolbar
  • Using the Ribbon
  • Identifying Screen Symbols
  • Entering Data in a Worksheet
  • Types of Data
  • Entering Text
  • Entering Numbers
  • Entering Dates and Times
  • Moving Around the Worksheet
  • Working with Workbooks
  • Saving Workbooks
  • Creating a New Workbook
  • Switching Between Workbooks
  • Opening a Workbook
  • Closing a Workbook
  • Working with the Compatibility Mode
  • Selecting Cells

Lesson 2: Constructing Cell Data

  • Editing Cells and Undoing Changes
  • Copying and Moving Data
  • Cutting, Copying and Pasting Data
  • Append Data to Worksheets
  • Using Paste Special
  • Copying and Moving Cells Using the Mouse
  • Inserting and Deleting Rows and Columns
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Inserting and Deleting Cells
  • Adjusting the Columns and Rows
  • Changing the Column Widths
  • Adjusting the Row Height
  • Using AutoFit
  • Hiding/Unhiding Rows & Columns
  • Using AutoFill
  • Managing Worksheets
  • Renaming Worksheets
  • Inserting or Deleting Worksheets
  • Moving or Copying Worksheets
  • Hiding/Unhiding Worksheets
  • Adding Color to the Worksheet Tabs

Lesson 3: Using Formulas

  • Using Formulas
  • Creating and Editing Formulas
  • Cell References
  • Mathematical Operators
  • What If Analysis
  • Referencing Other Worksheets
  • Using Functions
  • Common Excel Functions
  • Using the Subtotal Function
  • Conditional Functions
  • Using Conditional Summary Functions
  • Using Text Functions
  • Using Absolute and Relative Cell References
  • Using Absolute Cell References
  • Using Mixed Absolute and Relative Cell References
  • Displaying and Printing Formulas
  • Data Validation

Lesson 4: Formatting the Worksheet

  • Formatting a Cell
  • Formatting Numbers and Decimal Digits
  • Changing Cell Alignment
  • Changing Fonts and Sizes
  • Applying Cell Borders
  • Using Colors and Patterns
  • Using the Format Painter
  • Clearing Cell Contents and Formatting
  • Using Themes
  • Modifying Themes
  • Using Cell Styles
  • Conditional Formatting
  • Using the Ribbon
  • Using the Rules Manager

Lesson 5: Viewing and Printing Workbooks

  • Changing Worksheet Views
  • Creating and Arranging Worksheet Windows
  • SplittingPanes
  • Freezing Panes
  • Changing the Zoom
  • Printing and Previewing the Workbook
  • Changing the Workbook Views
  • Customizing the Page Layout
  • Setting Page Breaks
  • Page Formatting
  • Adding a Header or Footer
  • Printing Titles or Range of Cells
  • Printing Selected Worksheets

Online Course Fee Payment
Other Amount:
Your Email Address:

Microsoft Excel 2013 – Level 1

  • Duration :   35 Hours
  • Certificates :   Yes
Online Course Fee Payment
Other Amount:
Your Email Address:

Quick Facts

This Microsoft® Excel 2013 Level 1 Guide teaches the information worker how to create and edit spreadsheets for business reports such as budgets or cash flow reports. The focus is placed on ensuring the basic skills are learned and can be applied to reports, including creating and editing simple formulas to handle common types of calculations.