59 Lessons

3 hours, 45 minutes

Beginner

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.

- IntroductionIntroductionMicrosoft 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:48Student Files for this CoursePlease download these practice files as you will be using them during this course.

- Introducing ExcelWorksheet - Entering and Editing Worksheet DataUnderstanding Workbooks and WorksheetsLearn the difference between a workbook and a worksheet2:35Moving Around a WorksheetMoving 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:19Using the RibbonChanges 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:01Using Shortcut MenusEveryone 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:41The Quick Access ToolbarEveryone 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:48Dialog BoxesDo 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:56Task PanesDialog 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:11Backstage ViewTask 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:03Workbook - Excel's ViewsA spreadsheet can be viewed from many angles. The spreadsheet also has view. Learning how to manipulate your work environment in this lesson.Excel's ViewsA spreadsheet can be viewed from many angles. The spreadsheet also has view. Learning how to manipulate your work environment in this lesson.7:12The Excel Help SystemExcel has a robust Help system that is housed online. Learn to search for answers.10:33Introduction to Excel WorkbookYour turn to make your first workbook using the skills you have just mastered,Competency AssessmentTest your ability based on what you have learned in this chapter

- Essential Worksheet OperationsCreating WorkbooksLearn the 3 ways to create a Microsoft Excel workbook.3:43Workbook - Saving WorkbooksTwo questions need to be answered here: Where do you want to save the file? and What name will you give to the file?Saving WorkbooksTwo questions need to be answered here: Where do you want to save the file? and What name will you give to the file?11:37Workbook - Basic Data EntryYou 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 EntryYou 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:46Basic Data Entry Part TwoThis is part two of the Basic Data Entry and Modification Lecture10:58Workbook - Cut Copy PasteLearn how to arrange and rearrange data in your worksheet uing cut, copy, and paste.Cut Copy PasteLearn how to arrange and rearrange data in your worksheet uing cut, copy, and paste.11:54Practical ExerciseTake 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 BackstageWorkbook - Backstage ViewLearn about Excel's backstage view and how to use it for your own projects.Backstage ViewLearn about Excel's backstage view and how to use it for your own projects.3:28Workbook - Printing With Backstage ViewLearn 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 ViewLearn 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:35Workbook - Changing the Excel EnvironmentLearn to manipulate various aspects of the Excel working environment such as the Quick Access Toolbar, the Ribbon, and worksheet properties.Changing the Excel EnvironmentLearn to manipulate various aspects of the Excel working environment such as the Quick Access Toolbar, the Ribbon, and worksheet properties.11:08Workbook - Accessing and Using Excel TemplatesExcel 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 TemplatesExcel 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:36Test Your SkillsTest 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 FormulasWorkbook - Overview of FormulasThis part of the lessons covers an overview of Formulas and how to display them within a cell.Overview of FormulasThis part of the lessons covers an overview of Formulas and how to display them within a cell.1:47Workbook - Order of OperationsThe 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 OperationsThe 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:40Workbook - Building Basic FormulasYou 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 FormulasYou 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:16Workbook - Using Cell References in FormulasCell 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 FormulasCell 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:54Workbook - Using Cell Ranges in FormulasA 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 FormulasA 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:30Test Your SkillsThis 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 FunctionsWorkbook - Exploring FunctionsA 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 FunctionsA 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:02Workbook - Displaying Dates and Times with FunctionsIn 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 FunctionsIn 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:29Workbook - Summarizing Data With FunctionsIn 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 FunctionsIn 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:07Workbook - Uncovering Formula ErrorsFormulas 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 ErrorsFormulas 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:54Workbook - Using Formulas to Create SubtotalsMany 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 SubtotalsMany 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:24Workbook - Displaying and Printing FormulasFormulas 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 FormulasFormulas 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:10Competency AssessmentThis 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 ExamSample ExamPractice what you learned in this course by taking this simple practice exam.

- Microsoft Excel