Super Simple Excel 2016 for Beginners (MS Office 365)

Super Simple Excel 2016 for Beginners (MS Office 365), available at Free, has an average rating of 4.57, with 57 lectures, based on 464 reviews, and has 13702 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is for you if you are brand new to Excel and already have it installed on your computer or 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 or 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 or This course is NOT for you if you already have a good level of knowledge with a version of Excel from 2007 onwards It is particularly useful for This course is for you if you are brand new to Excel and already have it installed on your computer or 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 or 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 or This course is NOT for you if you already have a good level of knowledge with a version of Excel from 2007 onwards.

Enroll now: Super Simple Excel 2016 for Beginners (MS Office 365)

Summary

Title: Super Simple Excel 2016 for Beginners (MS Office 365)

Price: Free

Average Rating: 4.57

Number of Lectures: 57

Number of Published Lectures: 57

Number of Curriculum Items: 57

Number of Published Curriculum Objects: 57

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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:

You’ll read the lesson notes; step by step instructions supported by screen shots
Watch and listen to the ‘how to’ video – I tend to talk on these videos as if I’m sitting right next to you
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
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.

Course Curriculum

Chapter 1: Course Introduction and Pre-Course Reading

Lecture 1: Introduction to your course and the instructor

Lecture 2: Download these files before you start

Lecture 3: Using the mouse and keyboard

Lecture 4: Understanding the Ribbon

Chapter 2: Introduction to Excel 2016

Lecture 1: What is Excel 2016?

Lecture 2: How to get Excel 2016

Lecture 3: Office 2016 vs Office 365 vs Office Online and how to get a 1 month free trial

Chapter 3: Start Excel and Create a New, Blank Workbook

Lecture 1: Start Excel

Lecture 2: The start screen, recent workbooks and opening a new workbook

Lecture 3: Start Excel and Create a Blank Workbook

Lecture 4: Take a Look Around a New, Blank Workbook

Lecture 5: Look around a new workbook and the Ribbon

Lecture 6: Exercise – Start Excel and Create a New, Blank Workbook

Chapter 4: Adding Text and Numbers to a Worksheet

Lecture 1: Typing Text and Numbers

Lecture 2: Add text and numbers

Lecture 3: Column Width

Lecture 4: Formatting Cells as Currency

Lecture 5: Column width and formatting cells as currency

Lecture 6: Cut and Paste

Lecture 7: Auto Fill and Undo

Lecture 8: Cut, Paste, Autofill and Undo

Lecture 9: Exercise – Adding Text and Numbers

Chapter 5: Formulas

Lecture 1: Manually Create a SUM Formula

Lecture 2: AutoSum

Lecture 3: Populate a Cell with a Number from Another Cell

Lecture 4: Basic Formulas

Lecture 5: Exercise – Formulas

Chapter 6: Formatting

Lecture 1: Font Size, Colour and Fill Colour

Lecture 2: Font Bold, Italic, Underline

Lecture 3: Merge & Centre Two Cells into One

Lecture 4: Cell Content Alignment

Lecture 5: Hiding Rows

Lecture 6: Formatting

Lecture 7: Exercise – Formatting

Chapter 7: Conditional Formatting

Lecture 1: Conditional Formatting

Lecture 2: Copying Conditional Formatting Between Cells

Lecture 3: Basic Conditional Formatting

Lecture 4: Exercise – Conditional Formatting

Chapter 8: Images

Lecture 1: Insert an Image

Lecture 2: Insert an Image

Lecture 3: Exercise – Insert and Resize and Image

Chapter 9: Managing Worksheets

Lecture 1: Copy and Move a Worksheet to Create a Template

Lecture 2: Use a Template

Lecture 3: Copying and Moving Worksheets

Lecture 4: Exercise – Managing Worksheets

Chapter 10: Printing

Lecture 1: Printing

Lecture 2: Optional Exercise – Printing

Chapter 11: Spelling and Thesaurus

Lecture 1: Set Default Language

Lecture 2: Check Spelling

Lecture 3: Spelling and Thesaurus

Lecture 4: Exercise – Spelling and Thesaurus

Chapter 12: Save and Close

Lecture 1: Save and Close

Lecture 2: Save and Close

Lecture 3: Exercise – Save and Close

Chapter 13: Getting Help

Lecture 1: Get Help within Excel

Lecture 2: Help from the Instructor

Lecture 3: Preview – Super Simple Microsoft Forms

Instructors

Mark Thompson
Microsoft 365 and Teams Adoption Specialist

Rating Distribution

1 stars: 10 votes
2 stars: 9 votes
3 stars: 64 votes
4 stars: 167 votes
5 stars: 214 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu