Microsoft Excel - Level 1 - Foundations

New to Excel? This course provides a thorough grounding in working with Excel from the beginning.
4.5 (15 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
779 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 64
  • Length 3 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course Description

This course introduces you to the power of Microsoft Excel starting from the beginning. You’ll learn how to open and close files, how to enter formulae into a cell, build basic charts and format a spreadsheet. You’ll learn how to use the most important features of Excel.

What are the requirements?

  • No previous knowledge of Excel required

What am I going to get from this course?

  • If you’re new to Excel or are going to be using Excel in the future, you’ll need to understand the fundamentals. This course will provide you with a solid platform from which you can learn. By completing this course, you’ll save yourself a lot of time when using Excel.

What is the target audience?

  • Anyone needing to learn how to use Excel or those familiar with other spreadsheet programmes but new to Microsoft Excel, or anyone who has not used the product for a period of time. If you’re about to start a new role, or are looking for a new position, this course is ideal.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: The Basics
00:33

This section includes the exercise files for Excel Level 1. Please download these before you start the course.

Starting Excel
Preview
00:52
Touring Excel
Preview
03:12
Entering and Editing Data
Preview
02:37
Saving a Workbook as an .XLSX
Preview
04:16
Saving a Workbook in a different file format
Preview
04:09
Closing a Workbook
Preview
01:00
Setting Excel File Defaults
Preview
01:35
Section 2: Selecting Cells and Ranges
Introduction
Preview
00:26
Selecting Cells, Rows and Columns
Preview
03:44
Moving, Copying and Deleting Cells
06:49
Using Undo and Redo
01:27
Finding and Replacing Values
03:06
Spell Check
00:47
Section 3: Modifying a Worksheet
Introduction
Preview
00:30
Inserting, Deleting and Renaming a worksheet
Preview
03:30
Worksheet Views
03:32
Clearing and Deleting Cells
02:53
Inserting and Deleting Rows and Columns
02:40
Modifying Column and Row Size
03:30
Freezing and Unfreezing Rows and Columns
04:44
Section 4: Formatting Cells and and their Contents
Introduction
Preview
00:27
Formatting cells using the font group
Preview
04:48
Changing cell alignments
07:08
Formatting numbers and dates
06:35
Cell Borders and Patterns
02:32
The Format Painter
01:57
Section 5: Building simple Formula
Introduction
Preview
00:43
Basic Operators
Preview
03:04
Using the SUM function
03:01
Using AutoSUM
02:57
Using the AVERAGE function
02:46
Using the COUNT function
02:36
Using the MAX function
01:56
Using the MIN function
01:26
Using the ROUND function
01:25
Using the IF function
03:15
Common formula errors
02:58
Section 6: Absolute and Relative Referencing
Introdcution
Preview
00:34
Using the AutoFill Tool
Preview
04:32
Relative Referencing
02:20
Absolute Referencing
04:36
Section 7: Sorting Data
Introduction
Preview
00:31
Sorting Data
Preview
04:37
Section 8: Charts and Graphs
Introduction
Preview
00:47
Inserting and Deleting a chart
Preview
04:16
Moving and Resizing a Chart
03:33
Editing the Chart type
01:40
Chart Layouts and Labels
05:07
Editing the Axes and Gridlines
02:58
Formatting Selected Items in a chart
04:32
Printing a Chart
01:49
Special Features for Pie Charts
03:38
Section 9: Importing Text and Graphics
Introduction
Preview
00:22
Inserting Images onto an Excel Sheet
Preview
01:47
Importing Text Files (*.TXT)
03:01
Section 10: Printing and Page Setup
Introduction
Preview
00:29
Print Preview & Basic Print Settings
Preview
02:58
Different Excel Sheet Views
01:50
Inserting Headers And Footers
03:41
Settings in Page Setup
02:52
Scaling our Data for Printing
03:55
Section 11: Using Help in Excel
Introduction
Preview
00:19
Using the HELP function in Excel
02:43

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

eLearnExcel, Leading provider of Online Excel training

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.

Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.

Ready to start learning?
Take This Course