Microsoft Excel - The Beginners Introduction To Excel
5.0 (1 rating)
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.
2 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - The Beginners Introduction To Excel to your Wishlist.

Add to Wishlist

Microsoft Excel - The Beginners Introduction To Excel

Become a master of Excel, with expert tutor Richard Walters.
New
5.0 (1 rating)
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.
2 students enrolled
Created by NILC Training
Last updated 8/2017
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The basics of Excel (i.e. selecting and highlighting cells, copy and paste, etc).
  • Formatting and manipulation (i.e. inserting columns and rows, merging cells, etc).
  • Creating basic formulas and using the BODMAS rule for formulas.
  • Using Excel functions (automated - i.e. SUM, AVERAGE, MAX, MIN)
  • Using the AutoSum feature
  • Automated functions and manual formulas
  • Creating and formatting charts
  • Managing and linking worksheets
  • Using the Autofil feature
  • Printing and printing features (i.e. print area, print preview, print setup)
  • Freeze panes and printing with freeze panes
View Curriculum
Requirements
  • A basic familiarity with Windows and Microsoft Office is useful, but not essential. This course has no other prerequisites other than a desire to learn and start using Microsoft Excel.
Description

Are you looking to build your skills in using Microsoft Excel?

This course gives you a deep understanding of how to use some of the most popular functions in Excel. We will build you from a base skill level and assume you have no prior knowledge in using Microsoft Excel or its functions. 

In this course we will cover Excel Basics, Formatting and Manipulation, Creating Formulas and Cell Referencing, Automatic Functions, Creating and Formatting Charts, Managing and Linking Worksheets, Using AutoFill, Freeze Panes and Printing. Most lectures are 7 - 14 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.

Microsoft Excel - The Beginners Introduction To Excel Outline

  • The Excel Environment
  • Select and Highlighting Cells
  • Entering Information
  • Formatting Information
  • Modifying Information - Wrap Text and Merging Cells
  • Inserting/Deleting Columns and Rows
  • Save, Save As and Open
  • Find Opening and Closing Excel
  • Creating and Copying Formulas
  • Using BODMAS in Formulas
  • Absolute Cell Referencing
  • Using Functions - SUM, IF, COUNT, AVERAGE
  • AutoSum Features
  • Difference between Excel manual and automated calculations
  • Creating and Formatting Charts
  • Inserting, Moving and Deleting Worksheets
  • Grouping Worksheets
  • AutoFill Feature
  • Linking formulas between Worksheets
  • Freeze Panes
  • Print Area and Print Preview
Who is the target audience?
  • Delegates new to Microsoft Excel.
  • Existing Excel users looking to improve their skill base.
  • Self-taught learners looking to improve Excel working knowledge.
Compare to Other Excel Courses
Curriculum For This Course
22 Lectures
03:39:36
+
Excel Basics
3 Lectures 32:25

Selecting and Highlighting Cells
15:51

Entering Information
09:11
+
Formatting and Manipulation
5 Lectures 47:22
Formatting Information
09:43

Modifying Information - Wrap Text and Merging Cells
13:01

Inserting/Deleting Columns and Rows
10:06

Save, Save As and Open
08:16

Find Opening and Closing Excel
06:16
+
Creating Formulas and Cell Referencing
3 Lectures 35:58
Creating and Copying Forumlas
15:59

Using BODMAS in Formulas
08:57

Absolute Cell Referencing
11:02
+
Automatic Functions
3 Lectures 26:43
Using Functions - SUM, IF, COUNT, AVERAGE
08:56

AutoSum Features
08:15

Difference between Excel manual and automated calculations
09:32
+
Creating and Formatting Charts
1 Lecture 10:18
Creating and Formatting Charts
10:18
+
Managing and Linking Worksheets
3 Lectures 31:57
+
Using AutoFill
1 Lecture 06:04
AutoFill Feature
06:04
+
Freeze Panes and Printing
3 Lectures 28:49
Freeze Panes
10:29

Printing and Page Setup
07:48

Print Area and Print Preview
10:32
About the Instructor
NILC Training
5.0 Average rating
1 Review
2 Students
4 Courses
Improving Performance Through Knowledge

Since 2014, NILC Training has been providing individuals and organisations across the UK with classroom based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be Wales (UK) leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime!