Excel Beginner Level 1
Beginner Microsoft Excel Tutorial - 1 Hour 29 Minutes

This course is for the novice user who has little or no experience with Microsoft Excel. We will begin by learning about the parts of the Excel interface, including the Title Bar, window control buttons, File menu, and more.

You will learn about the new Ribbon, the different tabs, groups, command, and dialog menus.

Next you will learn about the Quick Access Toolbar, the status bar, zoom controls, and scroll bars.

We will next learn about the Formula Bar, the different parts of a spreadsheet including rows, columns, and cells. You'll learn how to use the mouse pointer with respect to Excel, and learn about the different Sheet Tabs.

You'll learn how to properly input data into an Excel spreadsheet. We'll create a sales summary sheet in class with different sales reps and their sales figures by month. You'll see how to work with both the mouse and keyboard.

We'll learn how to edit data in our sheet. You'll learn how to replace data in the cells, edit data using the Formula Bar, and use Edit Mode directly in a cell. You'll also learn about Undo and Redo.

You will learn how to format your spreadsheet to make it look more professional. You'll learn about cell alignment, ranges, bold, italics, underline, and more.

Next we'll learn more formatting techniques. You'll change the font and font size. You'll learn how to resize columns and rows, change color, and more.

You will learn how to perform basic math calculations in Excel, and how formulas work. You'll learn about the basic math operators (add, subtract, multiply, divide, exponent) and how to use constants in your formulas.

We'll learn how to add multiple cells, use the mouse to build our formulas, work with the status bar, calculate an average, and we'll learn about the all-important Order of Operations.

Finally, you'll learn how to save, load, and print your worksheets. You'll also learn about pinning your files to the Recent Documents menu, and previewing your sheet before you print it.

Again, this is the perfect class for anyone who is new to Microsoft Excel. If you have little or no experience with spreadsheets, or you just want to get familiar with how Excel works, this class is for you. You should have some basic knowledge of Windows beforehand, and a little bit of Microsoft Word helps (so you're familiar with formatting text), but we'll teach you everything you need to know to use Excel to make simple spreadsheets. 

Of course, if you have any questions about whether or not this class is for you, please contact me.
 

Complete Outline - Excel Beginner Level 1