Learn Excel from the inside!

The First step in preparing for the Microsoft Office Specialist (MOS) Excel Specialist Exam using Excel 2013 or higher.
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.
1,737 students enrolled
$25
Take This Course
  • Lectures 38
  • Contents Video: 3.5 hours
    Other: 19 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course 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.

What are the requirements?

  • Before attempting this course, you should be familiar with basic Windows functions.

What am I going to get from this course?

  • Introduction to Excel
  • Use Essential Worksheet Operations
  • Be Familiar with Office Backstage Operations
  • Use Basic Formulas
  • Use Excel Functions

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Excel Basics
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.

Section 2: Introducing Excel
02:34

Learn the difference between a workbook and a worksheet

09:50

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

06:00

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.

01:40

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.

02:47

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

03:55

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.

02:11

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.

03:02

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.

07:11

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

10:32

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

5 pages

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

Competency Assessment Section 2
2 pages
An Introduction to Excel
5 questions
Section 3: Essential Worksheet Operations
03:42

Learn the 3 ways to create a Microsoft Excel workbook.

11:36

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

13:45

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.

10:57

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

11:53

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

2 pages

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 Coptency to Mastery.

Essential Worksheet Operations
22 questions
Section 4: The Office Backstage
03:27

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

15:34

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

11:07

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

10:35

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.

2 pages

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.

The Office Backstage
20 questions
Section 5: Basic Formulas
01:46

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

01:39

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.

05:15

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.

15:53

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.

11:29

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.

3 pages

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!

Basic Formulas
20 questions
Section 6: Using Functions
05:01

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.

07:28

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.

14:06

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.

10:23

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.

02:53

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.

02:09

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.

3 pages

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!

Using Functions
20 questions
2 pages

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


Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Bette Daoust, 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).

Ready to start learning?
Take This Course