Super Simple Excel 2016 for Beginners (MS Office 365)
4.7 (10 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.
709 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Super Simple Excel 2016 for Beginners (MS Office 365) to your Wishlist.

Add to Wishlist

Super Simple Excel 2016 for Beginners (MS Office 365)

A blended course with exercises - learn as you create a working Gift Budget worksheet step by step with the instructor
4.7 (10 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.
709 students enrolled
Created by Mark S Thompson
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 42 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Launch Excel and start a blank workbook
  • Alter size, colour and alignment of text and numbers
  • Set cell format as a currency with decimal points
  • Create basic formulas and use AutoSum
  • Use Conditional Formatting to highlight a problem
  • Insert and resize images
  • Manage language, check spelling and use the thesaurus
  • Print, save and close Excel
  • Find help within Excel and from the Instructor
  • Use the above skills to create a working Gift Budget for any occasion
View Curriculum
Requirements
  • You'll need Excel 2016 already installed (or use my link to a 1 month Office 365 trial)
  • I will explain the basics such as left, right, single, double and triple mouse clicks
  • At the beginning of the course you will need to click a file and save it to your computer and be able to find this file for use later in the course
Description

Super Simple Excel 2016 for Beginners is a concise course with exercises, aimed at getting you from no knowledge to to creating and using a gift buying budget. Follow along as we create the budget together step-by-step.

What type of learner are you? 

  • Reading Learners will benefit from reading the written step-by-step instructions
  • Writing Learners will benefit from using the printable ‘Personal Quick Reference Guide’ download sheet as they make their own notes throughout the course
  • Visual Learners will love the screen shots and video tutorials
  • Auditory Learners benefit from the step-by-step commentary on the videos
  • Kinaesthetic Learners will enjoy the hand on exercise at the end of each section as they get their work to the same stage as that part of the course

You are most likely a blend of learning types.  Each topic is covered in a way that ensures that every learner gets the maximum out of the session. 

This course is not a spectator sport; you won’t watch hours of video and hope it sinks in. Also, it will take you longer than you might expect if you do it right. We'll start with a new, blank workbook and gradually build it up until it is ready to run a basic budget for buying gifts. Here's how we'll work together:

  1. You'll read the lesson notes; step by step instructions supported by screen shots
  2. Watch and listen to the 'how to' video - I tend to talk on these videos as if I'm sitting right next to you
  3. You'll do an exercise at the end of every section to get your own workbook to the same point as I got to in the lesson. Either do these exercises by following the instructions on-screen or by using the downloadable exercise book
  4. Finally, you'll make make your own notes, a kind of quick reference guide to refer back to using the 'Personal Quick Reference Guide’ 

If you have a question about a topic just ask in the lesson or in the supporting Facebook Group and I'll answer.

What are you waiting for? Sign up and get started, If you're not delighted you can have your money back, no questions asked.

Who is the target audience?
  • This course is for you if you are brand new to Excel and already have it installed on your computer
  • This course is for you if you want to put in the work (this will include reading lesson notes) and finish with confidence KNOWING you can apply your new knowledge
  • This course is NOT for you if you want to just sit back, watch video demos and can't be bothered to read the step-by-step guides and do exercises to apply your new knowledge
  • This course is NOT for you if you already have a good level of knowledge with a version of Excel from 2007 onwards
Students Who Viewed This Course Also Viewed
Curriculum For This Course
56 Lectures
01:19:49
+
Course Introduction and Pre-Course Reading
4 Lectures 05:35

Download and save these files:

  1. The Reference Workbook contains a worksheet for every stage of the course, if you have trouble with your worksheets as we work together you can refer to and use this one if necessary
  2. The Gift image will be used in a later lesson
  3. The Personal Quick Reference Guide (QRG) is for you to print off now and make notes on as you go along
Download these files before you start
00:03

Using the mouse and keyboard
00:46

Understanding the Ribbon
00:36
+
Introduction to Excel 2016
3 Lectures 01:19
What is Excel 2016?
00:22

How to get Excel 2016
00:20

Office 2016 vs Office 365 vs Office Online and how to get a 1 month free trial
00:36
+
Start Excel and Create a New, Blank Workbook
6 Lectures 08:54
Start Excel
00:22

The start screen, recent workbooks and opening a new workbook
00:25


Take a Look Around a New, Blank Workbook
00:39


Exercise - Start Excel and Create a New, Blank Workbook
00:26
+
Adding Text and Numbers to a Worksheet
9 Lectures 16:56
Typing Text and Numbers
00:38

Add text and numbers
03:20

Column Width
00:35

Formatting Cells as Currency
01:07

Column width and formatting cells as currency
04:44

Cut and Paste
00:44

Auto Fill and Undo
00:34

Cut, Paste, Autofill and Undo
04:36

Exercise - Adding Text and Numbers
00:38
+
Formulas
5 Lectures 09:06
Manually Create a SUM Formula
00:53

AutoSum
00:29

Populate a Cell with a Number from Another Cell
00:30

Basic Formulas
06:50

Exercise - Formulas
00:22
+
Formatting
7 Lectures 11:48
Font Size, Colour and Fill Colour
01:10

Font Bold, Italic, Underline
00:24

Merge & Centre Two Cells into One
00:22

Cell Content Alignment
00:16

Hiding Rows
00:13

Formatting
08:39

Exercise - Formatting
00:43
+
Conditional Formatting
4 Lectures 11:23
Conditional Formatting
00:56

Copying Conditional Formatting Between Cells
00:56

Basic Conditional Formatting
08:37

Exercise - Conditional Formatting
00:53
+
Images
3 Lectures 04:13
Insert an Image
00:33

Insert an Image
03:08

Exercise - Insert and Resize and Image
00:32
+
Managing Worksheets
4 Lectures 03:14
Copy and Move a Worksheet to Create a Template
00:26

Use a Template
00:17

Copying and Moving Worksheets
02:19

Exercise - Managing Worksheets
00:12
+
Printing
2 Lectures 02:39
Printing
02:30

Optional Exercise - Printing
00:09
3 More Sections
About the Instructor
Mark S Thompson
4.2 Average rating
83 Reviews
2,092 Students
3 Courses
17 years in I.T. and certified Microsoft Office Specialist

I am a Microsoft Office Specialist (MOS) and trainer at Super Simple Training. I conduct classroom, 1 to 1, web-conference and floor walking training in the U.K. My clients have included the Ministry of Defence, Mercedes Benz, British Army, Zurich Insurance, the National Health Service and the Office for National Statistics.

I specialise in Microsoft Office, 365, Windows and SharePoint and produce manuals, training web pages, Quick Guides and instructional videos.

I live in the West Midlands, England with my partner, two kids, a French Bulldog and a ginger cat.