Microsoft Excel Introduction
4.2 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,644 students enrolled

Microsoft Excel Introduction

A guide to getting started with Microsoft Excel for all beginners
4.2 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,644 students enrolled
Created by ZandaX Training
Last updated 2/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010, 2013 or 2016, including a thorough treatment of the new 'Ribbon' interface, originally introduced with Excel 2007. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.
Requirements
  • A basic understanding of Microsoft Windows
Description

MODULE 1:  Getting Started with Microsoft Excel

Learning outcomes: Starting Excel and some of its basic navigation and help controls.

Topics covered:

  • Starting Out

  • About Workbooks

  • Exploring your Workbook

  • Getting Help with Excel

MODULE 2:  The Excel Interface

Learning outcomes: A look at the Ribbon interface and the different tabs and options the Ribbon offers.

Topics covered:

  • The Quick Access Toolbar and File Menu

  • The Home Tab

  • The Insert Tab

  • The Page Layout Tab

  • The Formulas Tab

  • The Data Tab

  • The Review Tab

MODULE 3:  Microsoft Excel Basics

Learning outcomes: Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.

Topics covered:

  • Working with Excel

  • Moving your Data

  • Basic Excel Features

  • Smart Tags and Options Buttons

  • Editing Tools

MODULE 4:  Editing your Workbook

Learning outcomes: Understanding formatting features and enhancing a workbook's overall appearance and using Conditional Formatting.

Topics covered:

  • Cell Formatting

  • Conditional Formatting

  • Enhancing a Worksheet's Appearance

MODULE 5:  Printing and Viewing your Workbook

Learning outcomes: Exploring Excel's printing and viewing options enhancing your ability to print and work with your data effectively.

Topics covered:

  • Using the View Tab

  • Managing a Single Window

  • Managing Multiple Windows

  • Printing your Workbook

  • Print Page Layout options

MODULE 6:  Working with Charts in Excel

Learning outcomes: Introducing charts within Excel and explain how to create basic charts to help convey your data with.

Topics covered:

  • Using Recommended and Standard Charts

  • Chart Elements

  • Chart Tools - Design & Format

Who this course is for:
  • The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.
Course content
Expand all 62 lectures 03:03:34
+ Getting Started with Excel
10 lectures 20:48
Opening Excel
Processing..
Exploring your Workbook - Overview
01:00
Exploring your Workbook
01:33
Getting Help with Excel - Overview
00:42
Getting Help with Excel
04:56
+ The Excel Interface
15 lectures 45:44
Introduction
01:50
The Quick Access Toolbar and File Menu - Overview
00:45
The Quick Access Toolbar and File Menu
04:01
The Home Tab - Overview
00:46
The Home Tab
05:57
The Insert Tab - Overview
00:35
The Insert Tab
04:51
The Page Layout Tab - Overview
00:34
The Page Layout Tab
05:22
The Formulas Tab - Overview
00:48
The Formulas Tab
07:57
The Data Tab - Overview
00:34
The Data Tab
05:12
The Review Tab - Overview
00:52
The Review Tab
05:40
+ Excel Basics
11 lectures 40:14
Introduction
01:10
Working with Excel - Overview
00:35
Working with Excel
05:43
Moving your Data - Overview
01:04
Moving your Data
03:07
Basic Excel Features - Overview
00:52
Basic Excel Features
07:35
Smart Tags and Options Buttons - Overview
01:58
Smart Tags and Options Buttons
09:19
Editing Tools - Overview
00:44
Editing Tools
08:07
+ Editing your Workbook
7 lectures 21:23
Introduction
01:30
Cell Formatting - Overview
00:21
Cell Formatting
07:26
Conditional Formatting - Overview
01:04
Conditional Formatting
04:17
Enhancing a Worksheet's Appearance - Overview
00:33
Enhancing a Worksheet's Appearance
06:12
+ Printing and Viewing your Workbook
12 lectures 35:17
Introduction
00:58
Using the View Tab - Overview
02:01
Using the View Tab
05:45
Using the View Tab
03:01
Managing a Single Window - Overview
01:12
Managing a Single Window
05:15
Managing Multiple Windows - Overview
00:34
Managing Multiple Windows
04:21
Setting Up Your Workbook - Overview
00:47
Setting Up Your Workbook
05:52
Printing Options - Overview
00:47
Print Page Layout Options
04:44
+ Working with Charts
6 lectures 18:51
Introduction
01:13
Using Recommended and Standard Charts
03:45
Chart Elements - Overview
00:28
Chart Elements
06:44
Chart Tools - Design & Format - Overview
01:03
Chart Tools - Design & Format
05:38