Learn Basic Excel Skills For Beginners
5.0 (2 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.
769 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Basic Excel Skills For Beginners to your Wishlist.

Add to Wishlist

Learn Basic Excel Skills For Beginners

Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data
5.0 (2 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.
769 students enrolled
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $105 Discount: 90% off
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Enter data in a spreadsheet
  • Save and open spreadsheet
  • Create formulas and functions
  • Format rows, columns, cells, and data
  • Align text in a cell
  • Adjust rows and columns
  • Find and replace data
  • Insert and delete sheets
  • Sort data
  • Add Borders and Fill Colours
  • Use Number Formatting
  • Use AutoSum
  • Insert Functions
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
Description

Microsoft Excel is a powerful tool essential for managing and presenting data
in today’s working environment. In this one day excel course,
you  will gain the knowledge and skills required  to create and edit worksheets, use formulas
and functions, sort and filter detail data visually, and present summary information
in a consumable and professional format.


What You Will Learn Include:

  •  What is Office 365
  • Setting up Office 365
  • Excel 2016 user interface
  • Exploring the Excel Ribbon 
  • Customizing the Quick Access Toolbar
  • Keeping Tabs on the Ribbon
  • Entering Data 
  • Opening a new workbook 
  • Entering Data in Excel
  • Basic Data entry
  • Entering Data with Autofill
  • Entering Date
  • Entering Time
  • Undo and Redo Changes
  • Adding Comments
  • Giving your worksheet a title
  • Saving your work
  • Creating Formulas and Functions 
  • Using formulas for arithmetic tasks
  • Re-using Formulas
  • Calculating YTD Profits
  • Calculating Percentage Change
  • Using Relative and Absolute Reference
  • Using RANK Function
  • STD Function
  • Small and Large Functions
  • Median Function
  • Count and counta functions
  • Formatting   
    Exploring Fonts
  • Adjusting Column Width and Row Height
  • Using Alignment  
    Designing Borders
  •  Formatting Numbers
  •  Conditional Formatting
  • Creating Tables
  • Inserting Shapes

After completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets  that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more.


Who is the target audience?
  • Beginners to spreadsheets and excel
  • Those who need a refresher to excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
50 Lectures
04:37:09
+
Installing and Exploring Excel 2016
10 Lectures 01:08:58




Getting Office 365
10:41

Setting up Office 365
11:03

Excel 2016 user interface
10:50

Exploring the Excel Ribbon
05:57

Customizing the Quick Access Toolbar
05:38

Keeping Tabs on the Ribbon
12:29
+
Entering Data
10 Lectures 01:00:33
Opening a new workbook
07:18

Entering Data in Excel
10:31

Basic Data entry
05:55

Entering Data with Autofill
05:58

Entering Date
05:23

Entering Time
05:37

Undo and Redo Changes
05:52

Adding Comments
04:13

Giving your worksheet a title
03:51

Saving your work
05:55
+
Creating Formulas and Functions
11 Lectures 54:34
Introduction
05:21

Using formulas for arithmetic tasks
05:55

Re-using Formulas
04:15

Calculating YTD Profits
06:49

Calculating Percentage Change
06:42

Relative and Absolute Reference
09:39

Using RANK Function
03:59

STD Function
02:29

Small and Large Functions
03:44

Median Function
01:58

Count and counta functions
03:43
+
Formatting
8 Lectures 51:57
Exploring Fonts
05:09

Adjusting Column Width and Row Height
07:52

Using Alignment
06:27

Designing Borders
04:49

Formatting Numbers
07:00

Conditional Formatting
07:14

Creating Tables
06:48

Inserting Shapes
06:38
+
Excel 2016 Useful Tips
7 Lectures 26:14
Add or Remove Worksheets
02:35

Resizing Columns and Rows
04:40

Presenting Excel Data in a Chart
03:39

Making workbook read only
02:54

Changing text alignment
03:58

Freezing panes
03:42

Add and remove columns and Rows
04:46
+
Sharing and Security
4 Lectures 14:53
Sharing workbook and Tracking Changes
03:26

Protectecting workbook from structural change
04:58

Protecing your workbook
03:21

Protecting your worksheet
03:08
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,578 Reviews
35,319 Students
86 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.