MS Excel 2010: Introduction

Introduction

In this course, you will learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.

Lessons

  • Introduction to Excel
  • Data entry and editing
  • Worksheet navigation and basic settings
  • Cell range selection
  • Manipulation with cell ranges
  • Cell inserting and deleting
  • Text and cell formatting
  • Number, Date and Time format
  • Formatting via style gallery
  • Working with files and windows
  • Printing smaller tables
  • The AutoSum button and formula copying
  • Custom formula creation
  • Work with functions
  • Chart creation
  • Chart formatting
  • Proofing
  • Basic Excel settings
  • Getting help