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.
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.
Learn the difference between a workbook and 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.
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.
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.
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.
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.
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.
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.
A spreadsheet can be viewed from many angles. The spreadsheet also has view. LEarning how to manipulate your work environment in this lesson.
Excel has a robust Help system that is housed online. Learn to search for answers.
In this part of Introducing Excel, you will be creating a workbook and making changes to the workbook settings.
Learn the 3 ways to create a Microsoft Excel workbook.
Two questions need to be answered here: Where do you want to save the file? and What name will you give to the file?
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.
This is part two of the Basic Data Entry and Modification Lecture
Learn how to arrange and rearrange data in your worksheet uing cut, copy, and paste.
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.
Learn about Excel's backstage view and how to use it for your own projects.
Learn to use the Backstage Print functions including setting the print area, printing worksheets and workbooks.
Learn to manipulate various aspects of the Excel working environment such as the Quick Access Toolbar, the Ribbon, and worksheet properties.
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.
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.
This part of the lessons covers an overview of Formulas and how to display them within a cell.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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!
Practice what you learned in this course by taking this simple practice exam.
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).