fbpx

Microsoft Excel Basic to Intermediate level

////Microsoft Excel Basic to Intermediate level

Microsoft Excel Basic to Intermediate level

Course ID: MSO-EXBI 1 Day
   

Microsoft Excel Basic to Intermediate level

Overview

This practical and interactive workshop will be conducted with a good blend of instructions and discussions.

Description

AUDIENCE

This course is designed for those who desire to gain the skills necessary to create, edit, format and print basic Microsoft Office Excel worksheets.

CERTIFICATION

EXAM

INVESTMENT

Instructor-led / Virtual Instructor-led

Malaysia: Upon Request

PREREQUISITES

  • Familiar with Microsoft Windows

OBJECTIVES

The focus of this course will be to help users maximize their spreadsheet power for their work by first learning how to use the program effectively and efficiently for work-related tasks. Some activities you should be able to perform by end of this course:

  • Work with your data on one or more worksheets in a workbook
  • Avoid repetitive typing by entering data automatically
  • Enter a Formula to calculate value
  • Use Short Cuts to simplify every day work
  • Present Data with Excel Chart

COURSE CONTENT

Module 1: Getting Started

  • Introduction to Excel
  • Launching Microsoft Excel
  • Excel 2013 First Look
  • Backstage View
  • Overview of the User Interface & Ribbon
  • The Quick Access Toolbar
  • Getting around in the Workbook
  • Create Blank Workbook
  • Open an Existing Workbook
  • To Pin a Workbook
  • To Create a New Workbook from a Template
  • Saving and Closing Excel Workbooks
  • Compatibility Mode
  • About Excel File Types
  • The Zoom Feature

Module 2: Excel Basic

  • Create a Blank Workbook
  • Entering and Deleting Data
  • Working with Columns and Rows
  • Selection Method
  • Copying and Moving Data
  • To Access more Paste Options
  • Undo and Redo
  • Autofill and Custom Lists
  • AutoComplete
  • Flash Fill

Module 3: Working with Functions

  • Basic Formulas
  • Cell Reference in Formulas
  • Mathematical Operators
  • Order of Operations
  • Calculate with Functions
  • Basic Statistical Functions
  • Function Library
  • Date and Time Functions in Excel 2013
  • Calculate Now option

Module 4: Formatting a Worksheet

  • Changing the size of Rows or Columns
  • Adjusting Cell Alignment
  • Rotating Text
  • Creating Custom Number & Date Formats
  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit
  • Enhancing a Worksheet’s appearance
  • Working with Styles

Module 5: Printing & Viewing your Workbook

  • Using the View Ribbon
  • Freezing a Pane
  • Managing a Multiple Windows
  • Preview Your Output
  • Prepare to Print

Module 6: Charting

  • To insert a Chart
  • Chart Layout and Style
  • Other Chart options
  • To Change the Chart Type
  • To Move a Chart

What’s Next

Subscribe to our mailing list for special offers and promotions.

Processing...
Thank you! Your subscription has been confirmed. You'll hear from us soon.
ErrorHere