Excel 2010 Introduction
4.1 (288 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.
1,319 students enrolled

Excel 2010 Introduction

All you need to know to unleash the power of Excel spreadsheets
4.1 (288 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.
1,319 students enrolled
Last updated 5/2018
English
English, Arabic, 8 more
  • French
  • German
  • Hindi
  • Japanese
  • Portuguese
  • Russian
  • Simplified Chinese
  • Spanish
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 2 downloadable resources
  • 1 Practice Test
  • 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
  • Create the framework of a basic worksheet
  • Build formulas and work with basic functions
  • Edit a worksheet
  • Format a worksheet to enhance appear and increase readability
  • Handle large worksheets effectively
  • Protect a worksheet from edits
  • Print all or parts of a worksheet
Requirements
  • Basic Microsoft Windows training or equivalent experience
Description

This course is designed to teach students the fundamentals of Excel.    Specifically you will understand how to create, save, enter data and   print spreadsheets in addition to learning how to create formulas and   use functions to calculate in Excel.  You will learn how to format   spreadsheets, manipulate columns and rows, add headers and footers and   use page setup options to prepare them for printing.  You will also   learn how to handle large worksheets or multiple workbooks.



This IAAP-certified counts for 3.5 recertification points for the CAP certification under the Technology and Information Distribution content area.
Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:
  • Students who need to create, modify and print basic spreadsheets including formulas and functions
Course content
Expand all 62 lectures 03:49:07
+ Introduction
1 lecture 03:29
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.
Preview 03:29
+ Getting Started
5 lectures 20:39
Overview of the Excel Screen
08:00
Navigating a Worksheet
06:08
Using Zoom
00:40
+ Basic Worksheet Skills
8 lectures 34:15
Creating a New Workbook
03:32
Entering Data
05:20
Selecting a Range
02:10
Selecting Columns, Rows and Non-contiguous Cells
04:45
Using Worksheets
02:58
Using AutoFill
11:43
Deleting a Worksheet
00:52
Saving a Workbook
02:55
+ Creating Formulas
11 lectures 48:17
Using Autofill with Formulas
02:14
Using AutoSum
03:19
Inserting Functions: AVERAGE, MAX, MIN, COUNT
16:34
Using Clear All
01:01
Relative v. Absolute Cell Addressing
05:51
+ Formatting the Worksheet
13 lectures 43:16
Hiding Rows and Columns
03:17
Changing Numeric Formats
01:49
Using the Format Cells Dialog Box
03:17
Changing Text Formats
02:00
Aligning Data
06:05
Using Borders and Shading
06:18
Using the Format Painter
01:30
Using Cell Styles
04:38
Creating New Cell Styles
01:17
Modifying Cell Styles
00:37
Using Themes
02:52
+ Working with Large Worksheets or Multiple Workbooks
6 lectures 17:10
Using the Zoom Feature
02:43
Splitting the Window
04:03
Tiling Multiple Workbooks
03:41
Synchronous Scrolling
00:56
Hiding, Maximizing, and Closing Windows
01:54
+ Using Protection and Comment Boxes
2 lectures 12:30
Adding, Hiding, and Deleting Comments
06:14
Locking and Unlocking Cell Ranges
06:16
+ Printing and Page Setup
9 lectures 28:50
Using Page Break Preview
07:10
Using Print Preview
04:35
Changing the Orientation
01:23
Changing the Margins
01:06
Adding Headers and Footers
04:50
Setting Sheet Options
01:52
Setting Print Titles
03:59
Working with Print Areas
01:27
Using the Page Layout Tab
02:28