Microsoft Excel 2010: Basic

Pre-Requisites:This course requires you to be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows XP/Vista/Windows 7 environment and be able to use Windows to manage file information on your computer. The ability to launch and close programs; navigate to information stored on the computer; and manage files and folders, is highly recommended. A familiarity with other Microsoft Office applications (e.g., Word) will be helpful.

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

This course will provide an introduction to spreadsheets and the practical uses and versatility of Microsoft® Office Excel® 2010. Students will learn time saving features and tips for using Excel effectively.

This course is intended for students learning Microsoft Excel® 2010 Basic skills.

Unit 1: Getting started

  • Topic A: Database concepts
  • Topic B: Exploring the Access environment
  • Topic C: Getting help

Unit 2: Databases and tables

  • Topic A: Planning and designing databases
  • Topic B: Exploring tables
  • Topic C: Creating tables

Unit 3: Fields and records

  • Topic A: Changing the design of a table
  • Topic B: Finding and editing records
  • Topic C: Organizing records

Unit 4: Data entry rules

  • Topic A: Setting field properties
  • Topic B: Working with input masks
  • Topic C: Setting validation rules

Unit 5: Basic queries

  • Topic A: Creating and using queries
  • Topic B: Modifying query results and queries
  • Topic C: Performing operations in queries

Unit 6: Using forms

  • Topic A: Creating forms
  • Topic B: Using Design view
  • Topic C: Sorting and filtering records

Unit 7: Working with reports

  • Topic A: Reports
  • Topic B: Modifying and printing reports

Course Number : MOUS-7-0200

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder