Microsoft Excel - Level 1 - Foundations
4.4 (23 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.
792 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Level 1 - Foundations to your Wishlist.

Add to Wishlist

Microsoft Excel - Level 1 - Foundations

New to Excel? This course provides a thorough grounding in working with Excel from the beginning.
4.4 (23 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.
792 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • No previous knowledge of Excel required
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 64 Lectures Collapse All 64 Lectures 02:54:53
+
Selecting Cells and Ranges
6 Lectures 16:19


Moving, Copying and Deleting Cells
06:49

Using Undo and Redo
01:27

Finding and Replacing Values
03:06

Spell Check
00:47
+
Modifying a Worksheet
7 Lectures 21:19


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
+
Formatting Cells and and their Contents
6 Lectures 23:27


Changing cell alignments
07:08

Formatting numbers and dates
06:35

Cell Borders and Patterns
02:32

The Format Painter
01:57
+
Building simple Formula
11 Lectures 26:07


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
+
Absolute and Relative Referencing
4 Lectures 12:02


Relative Referencing
02:20

Absolute Referencing
04:36
+
Sorting Data
2 Lectures 05:08
+
Charts and Graphs
9 Lectures 28:20


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
+
Importing Text and Graphics
3 Lectures 05:10
+
Printing and Page Setup
6 Lectures 15:45


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
1 More Section
About the Instructor
eLearnExcel
4.3 Average rating
158 Reviews
1,792 Students
6 Courses
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.