Basic Excel Course

Course Schedule

Microsoft Basic Excel Course includes all Basic to Advanced Features, Functions and Formulas of Microsoft Excel. This Master Excel Training help participants to learn Pivot Table, VLookup, Hlook up, Filtering Data using Functions, Exporting and importing data, Basic Macros and many more tricks in Microsoft Excel. This is a hands-on Excel training where you will be working on live exercises of each topic.

Claim 100% Fees From SkillConnect Credit, No Upfront fees for Singaporean

Course Duration: 1 Days

1st Day Basic Excel Course Outlines

Getting Started

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

Performing Calculations

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

Modifying a Worksheet

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

Formatting a Worksheet

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

Printing Workbook Contents

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

Analytical tools

  • Goal Seek
  • Scenarios

Our Clients