Basic Excel Course 2013

Basic Excel 2013 Training Singapore

Duration: 2 Days Basic Excel 2013 Course

  • One Time Free Refresh Class in 6 Month
  • SkillsFuture Approved Course
  • Hands-On Exercises
  • Attention to each participants
  • Interactive Class
  • Step-By-Step Course
  • 100% Satisfactory Record
  • Trained more than 10000 Participants
  • 10 Year Experienced Trainer
  • ACTA & Microsoft Certified Trainer

Course Objective

Microsoft Excel 2013 Course will improve the productivity and efficiency of individuals. It is very easy to grasp, so you anyone can learn the tips and tricks related to Excel 2013, which definitely make task assigned easy, by our step-by-step hands-on teaching.

Target Student: This course is for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets after that proceed to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Prerequisites: Basic knowledge to operate computer Course Objectives: Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:

SkillsFuture Claimable Course

Basic Excel 2013 Course Progression

Day 1

  • Get started with Microsoft Office Excel 2010.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Day 2

  • Customize the Excel environment.
  • Create advanced formulas.
  • Analyze data by using functions and conditional formatting.
  • Organize and analyze datasets and tables.
  • Visualize data by using basic charts.
  • Analyze data by using PivotTables, slicers, and Pivot Charts.

Basic Excel 2013 Course Content

Lesson 1: Getting Started with Microsoft® Excel® 2013

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Lesson 2: Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

Lesson 5: Printing Workbook Contents

  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

  • Customize General and Language Options
  • Customize Formula Options
  • Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Customize the Functionality of Excel by Enabling Add-Ins
  • Customize Advanced and Trust Center Options

Lesson 8: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Lesson 9: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data

Lesson 10: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

Lesson 11: Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt