Learn Excel from the inside!
4.4 (5 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.
1,741 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Excel from the inside! to your Wishlist.

Add to Wishlist

Learn Excel from the inside!

The First step in preparing for the Microsoft Office Specialist (MOS) Excel Specialist Exam using Excel 2013 or higher.
4.4 (5 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.
1,741 students enrolled
Created by Dr. Bette Daoust
Last updated 1/2017
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Introduction to Excel
  • Use Essential Worksheet Operations
  • Be Familiar with Office Backstage Operations
  • Use Basic Formulas
  • Use Excel Functions
View Curriculum
Requirements
  • Before attempting this course, you should be familiar with basic Windows functions.
Description

The course teaches you all you need to know for part 1 of the Microsoft Office Specialist exam for Excel.

Whether you need the skills for work or for personal use, this course will help you to:

Work effectively with Excel

Populate a worksheet with Data

Modify data entries and use Data Types

Use Basic Formulas

And Use Functions to enhance your work

Not only will you be exposed to the basics of Excel, we will work with you to practice your skills using real-life examples.

Together, we will walk you through the entire basics of Excel and provide you with opportunities to practice your new skills, step-by-step.

Who is the target audience?
  • This course is meant for those interested in taking the Microsoft Office Specialist Exam for certification. This course is a thorough introduction to Excel and assumes the student is familiar with the basic Windows functions.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
38 Lectures
03:59:07
+
Excel Basics
1 Lecture 01:47

Microsoft Excel is an essential tool for business. Whether you want to get your certification or not, the essentials provided in this first course are enough to push you toward being an Excel specialist. You will need to download the student data files to start this course. See the Download tab on the right for information.

Preview 01:47
+
Introducing Excel
12 Lectures 49:42

Learn the difference between a workbook and a worksheet

Preview 02:34

Moving around a worksheets may seem like a boring part of the lesson. You will be surprised at what you learn when it comes to navigating the Excel screen.

Preview 09:50

Changes to the Excel environment over the years has made a world of difference when it comes to doing things efficiently and effectively. The Ribbon holds tabs, group, launchers and more as an aid in improving how you use Excel.

Using the Ribbon
06:00

Everyone loves a shortcut, and Excel offers many shortcuts that a contextually sensitive. You will not see the same menu for a cell tht you would for a sheet tab or ribbon group. Learn the basics of shortcuts and make Excel work for you.

Using Shortcut Menus
01:40

Do you have commands that you use frequently and want to have instant access? Learn about the Quick Access Toolbar and how to customize it for your own work.

Customizing Your Quick Access Toolbar
02:47

Dialog boxes are popups that are launched when you issue various commands. Excel offers so many commands for any particular action that it is often best to place them into dialog boxes where they can be concentrated in one place. For example you can launch the Font dialog box and there you will find all the commands that control anything to do with the font.

Working with Dialog Boxes
03:55

Task panes are similar to dialog boxes except they are loaded in a panel on the right side of your document and will remain open until you close them. Task panes contain commands related to your current needs, such as formatting images and graphics.

Using Task Panes
02:11

The backstage is the operational side of Excel. It houses many of the administrative functions such as Document Info, Save, Print and setting Options. We will learn more in a later lesson as well as the basics here.

The Backstage
03:02

A spreadsheet can be viewed from many angles. The spreadsheet also has view. LEarning how to manipulate your work environment in this lesson.

Excel's Views
07:11

Excel has a robust Help system that is housed online. Learn to search for answers.

The Excel Help System
10:32

In this part of Introducing Excel, you will be creating a workbook and making changes to the workbook settings.

Creating Your First Excel Workbook
3 pages

Competency Assessment Section 2
2 pages

An Introduction to Excel
5 questions
+
Essential Worksheet Operations
6 Lectures 51:53

Learn the 3 ways to create a Microsoft Excel workbook.

Creating Workbooks
03:42

Two questions need to be answered here: Where do you want to save the file? and What name will you give to the file?

Saving Workbooks
11:36

You can type data directly into a cell. You can also copy and paste information from another worksheet or from other programs. In this lecture you will practice both scenarios.

Basic Data Entry and Modification
13:45

This is part two of the Basic Data Entry and Modification Lecture

Modifying Data Part 2
10:57

Learn how to arrange and rearrange data in your worksheet uing cut, copy, and paste.

Cut, Copy and Paste
11:53

Take this assessment of where you are with being an Excel Office Specialist. This is a series of 6 small projects to test your ability from Competency to Mastery.

Practical Exercise
2 pages

Essential Worksheet Operations
22 questions
+
The Office Backstage
5 Lectures 40:43

Learn about Excel's backstage view and how to use it for your own projects.

Backstage View
03:27

Learn to use the Backstage Print functions including setting the print area, printing worksheets and workbooks.

Printing with the Backstage
15:34

Learn to manipulate various aspects of the Excel working environment such as the Quick Access Toolbar, the Ribbon, and worksheet properties.

Changing the Excel Environment
11:07

Excel has several templates available. You can select from a list of templates or create one of your own. Templates save you time. In this lesson you will become familiar with templates.

Accessing and Using Excel Templates
10:35

Test your skills with this 6 part competency through Mastery Practical exercise set based on the Office Backstage. Good luck. If you have questions about this practicum, post a message to your instructor.

Practical Excercise
2 pages

The Office Backstage
20 questions
+
Basic Formulas
6 Lectures 36:02

This part of the lessons covers an overview of Formulas and how to display them within a cell.

Overview of Formulas
01:46

The order of operations will make the difference between accurate calculations and numbers that do not make sense. In this lesson you will be exposed to the order of operations and how to use that knowledge.

Order of Operations
01:39

You can do basic math in your head or you can use Excel for the same thing. Excel takes it one step further by adding formulas to calculations. In this lesson you will learn the basics of formulas.

Building Basic Formulas
05:15

Cell references are using in formulas and by addressing a cell or a range of cells, you can control how Excel calculates numbers. In this lesson you will learn about relative, absolute, and mixed cell references.

Using Cell References in Formulas
15:53

A group of cells is called a range. The ranges can be contiguous or non-contiguous. Once a range has been named, it can be used in formulas. In this lesson you will be exposed to naming ranges, modifying ranges, and creating formulas using ranges.

Using Cell Ranges in Formulas
11:29

This is a 6 part Competency through Mastery practical exercise based on your use of Basic Formulas. If you have any issues, please send a message to your instructor. Good Luck!

Practical Exercise
3 pages

Basic Formulas
20 questions
+
Using Functions
8 Lectures 42:00

A function is different from a formula. A function is a predefined formula that performs a calculation. The formulas can be simple to complex. In this lesson you will learn how to use functions.

Exploring Functions
05:01

In Excel all dates are numbers. The number is simply formatted to look like a date. In this lesson you will learn about using Excel Functions that are related to Date and Time.

Displaying Dates and Times with Functions
07:28

In this lesson you will be exposed to ore of Excel's functions that provide an easy way to perform mathematical work on a range of cells.

Summarizing Data with Functions
14:06

Many Excel users use formulas to create subtotals. This makes it easy for analyzing large volumes of data. In this lesson you will learn how to use the SUBTOTAL function.

Using Formulas to Create Subtotals
10:23

Formulas can be very complex and are therefore prone to errors. Error messages and Trace Arrows help to trace those errors so you can make corrections. In this lesson you will review error messages and use trace arrows to track a formula.

Formula Error Detection
02:53

Formulas do not show in cells, nor do they print unless you can the settings in Excel. In this lesson you will learn about showing formulas in cells and printing the formulas.

Displaying and Printing Formulas
02:09

This is a 6 part Competency through Mastery practical exercise is based on your use of Basic Functions. If you have any issues, please send a message to your instructor. Good Luck!

Practical Exercise
3 pages

Using Functions
20 questions

Practice what you learned in this course by taking this simple practice exam.


Sample Exam
2 pages
About the Instructor
Dr. Bette Daoust
4.5 Average rating
6 Reviews
2,934 Students
3 Courses
Author, Speaker and Business Consultant

Dr. Bette Daoust is an author, speaker and consultant to business. She is a best-selling author with her Blueprints for Success series of publications (now in 7 languages world-wide). Her love is to help people achieve success in their business, whether it is working from home or in an office environment. She is the Past President of the Fort Langley Chamber of Commerce, The Vancouver and Victoria Information Systems Training Association, The Rotary Club of Langley Sunrise, and a former Board Member of the Better Business Bureau in the San Francisco Bay Area. She is currently a member of the Rotary Club of Yaletown in Vancouver, BC and a founding member of the Authors Success Guild and National Book Marketing Association where she provides training content to help authors achieve success.

Her specialty is in the field of Knowledge Management and Business Process Development. Her work includes working with Fortune 500 companies including Accenture, Cisco Systems, Peet’s Coffee & Tea, Telus, BC Hydro, BC Ministry of Education, and many others in the capacity of developing knowledge systems, online learning programs, and business process improvement. Her degrees include: Bachelor of Education (University of British Columbia, Vancouver BC Canada), Master of Arts in Educational Technology (Simon Fraser University, Burnaby, BC Canada) and Doctorate in Business Management, Computing Science and Engineering (North Central University, Arizona, United States).