Take this
course

Office Productivity / Microsoft

Excel Basics

Learn Excel from the Inside

Instructor

Description

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

Full details

Curriculum

  • Introduction
    Introduction
    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.
    1:48
    Student Files for this Course
    Please download these practice files as you will be using them during this course.
  • Introducing Excel
    Worksheet - Entering and Editing Worksheet Data
    Understanding Workbooks and Worksheets
    Learn the difference between a workbook and a worksheet
    2:35
    Moving Around a Worksheet
    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.
    11:19
    Using the Ribbon
    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.
    6:01
    Using Shortcut Menus
    Everyone loves a shortcut, and Excel offers many shortcuts that a contextually sensitive. You will not see the same menu for a cell that you would for a sheet tab or ribbon group. Learn the basics of shortcuts and make Excel work for you.
    1:41
    The Quick Access Toolbar
    Everyone loves a shortcut, and Excel offers many shortcuts that a contextually sensitive. You will not see the same menu for a cell that you would for a sheet tab or ribbon group. Learn the basics of shortcuts and make Excel work for you.
    2:48
    Dialog Boxes
    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.
    3:56
    Task Panes
    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.
    2:11
    Backstage View
    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.
    3:03
    Workbook - Excel's Views
    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
    A spreadsheet can be viewed from many angles. The spreadsheet also has view. Learning how to manipulate your work environment in this lesson.
    7:12
    The Excel Help System
    Excel has a robust Help system that is housed online. Learn to search for answers.
    10:33
    Introduction to Excel Workbook
    Your turn to make your first workbook using the skills you have just mastered,
    Competency Assessment
    Test your ability based on what you have learned in this chapter
  • Essential Worksheet Operations
    Creating Workbooks
    Learn the 3 ways to create a Microsoft Excel workbook.
    3:43
    Workbook - Saving Workbooks
    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
    Two questions need to be answered here: Where do you want to save the file? and What name will you give to the file?
    11:37
    Workbook - Basic Data Entry
    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
    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.
    13:46
    Basic Data Entry Part Two
    This is part two of the Basic Data Entry and Modification Lecture
    10:58
    Workbook - Cut Copy Paste
    Learn how to arrange and rearrange data in your worksheet uing cut, copy, and paste.
    Cut Copy Paste
    Learn how to arrange and rearrange data in your worksheet uing cut, copy, and paste.
    11:54
    Practical Exercise
    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.
  • The Office Backstage
    Workbook - Backstage View
    Learn about Excel's backstage view and how to use it for your own projects.
    Backstage View
    Learn about Excel's backstage view and how to use it for your own projects.
    3:28
    Workbook - Printing With Backstage View
    Learn to use the Backstage Print functions including setting the print area, printing worksheets and workbooks. Please note that the downloadable is the same file as the previous lesson.
    Printing With Backstage View
    Learn to use the Backstage Print functions including setting the print area, printing worksheets and workbooks. Please note that the downloadable is the same file as the previous lesson.
    15:35
    Workbook - Changing the Excel Environment
    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
    Learn to manipulate various aspects of the Excel working environment such as the Quick Access Toolbar, the Ribbon, and worksheet properties.
    11:08
    Workbook - Accessing and Using Excel Templates
    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
    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.
    10:36
    Test Your Skills
    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.
  • Basic Formulas
    Workbook - Overview of Formulas
    This part of the lessons covers an overview of Formulas and how to display them within a cell.
    Overview of Formulas
    This part of the lessons covers an overview of Formulas and how to display them within a cell.
    1:47
    Workbook - Order of Operations
    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
    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.
    1:40
    Workbook - Building Basic Formulas
    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
    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.
    5:16
    Workbook - Using Cell References in Formulas
    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
    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.
    15:54
    Workbook - Using Cell Ranges in Formulas
    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
    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.
    11:30
    Test Your Skills
    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!
  • Using Functions
    Workbook - Exploring Functions
    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
    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.
    5:02
    Workbook - Displaying Dates and Times with Functions
    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
    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.
    7:29
    Workbook - Summarizing Data With Functions
    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
    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.
    14:07
    Workbook - Uncovering Formula Errors
    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.
    Uncovering Formula Errors
    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.
    2:54
    Workbook - Using Formulas to Create Subtotals
    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
    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.
    10:24
    Workbook - Displaying and Printing Formulas
    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
    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.
    2:10
    Competency Assessment
    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!
  • Sample Practical Competency Exam
    Sample Exam
    Practice what you learned in this course by taking this simple practice exam.

Skills

  • Microsoft Excel

Similar Courses

More Courses by this Instructor