To complete the Business Applications program, the Microsoft Office program or Excel by itself, the entire Excel series of workshops is created to hone in on not only spreadsheets, but tasks pertaining to creating charts and working with formulas as well as filtering and sorting data. Excel is used in every business today. In order to assist the student in obtaining the skills they need to be competitive in the job market, Excel is a must!
For those who only want to take the Excel course, the entire Excel series of workshops is created to hone in on not only data entry tasks, but tasks that need formulas to provide answers to calculations, inventory information, financial data, data analysis and data entry. Excel is used in every business today. In order to assist the student in obtaining the skills they need to be competitive in the job market, Excel is an important component to any resume. This program is designed to promote job placement.
Course Length: 40 Hours (approx. 4 weeks).
Includes Microsoft Office Manual, practice files and quick reference guides
Microsoft Excel 1 – Introduction to Spreadsheets & Formulas
Create, edit and format a spreadsheet. This part 1 class gets down to basics by controlling screen layout options, creating, saving, opening, closing, previewing and printing workbooks. In this class we will show you how to move within a spreadsheet and manipulate the print area. Students will learn to edit data, undo and redo, move and copy text and formulas, use the fill handle to copy or create a series, insert and delete columns and rows, format columns, text and numbers, control cell alignment and write basic formulas.
Microsoft Excel 2 – Multiple Sheets & Formatting
This class is going to teach you advanced formatting to enhance the appearance of spreadsheets such as merging cells, working with multiple sheets in a file and work with multiple sheets by renaming, moving, copying, deleting, grouping and linking formulas between sheets. Linking formulas between multiple files, viewing multiple sheets/files and freezing titles will also be covered.
Microsoft Excel 3 – Creating & Customizing Charts
This class is loaded with fun! Students will learn to create different types of charts including column, stacked, line and pie charts. We will show you how to embed charts and chart sheets, understand chart components, use chart AutoFormats, move or resize an embedded chart, add new information to a chart, change the chart type and format, customize the chart axes, legend, titles, data markers, gridlines, plot area and add notes or arrows to a chart. We will also touch on inserting objects such as text boxes and shapes.
Microsoft Excel 4 – Formulas & More Formulas!
This class will give you extensive hands-on practice in writing and copying formulas, working with absolute referencing and understanding formula arguments, creating and using range names in formulas and use of Trace Precedents/Trace Dependents to see how multiple formulas in a spreadsheet are linked.
Microsoft Excel 5 – Databases, Sorting & Filtering
Once you have mastered the basics, you can now realize the power of Excel. Students will learn in a hands-on environment how to use Excel database features including sorting information, using a list as a database, creating database function formulas, working with the data form, using criteria to find records, filtering data to show specific records, calculating automatic database subtotals and totals and defining a criterion range. In addition, conditional IF statements, vertical and horizontal lookups and pivot tables will be covered.
Microsoft Excel 6 – Conditional Formatting
Do you ever need to know if you are over or under budget or need to pick out important data from a large list? This class is for those looking to make important data stand out. Conditional formatting helps raw data come to life by controlling the conditions you are looking for such as cells greater than or equal to a certain number.
Microsoft Excel 7 – Templates
We show you how to utilize the many templates Excel has to offer. Calendars, budgets, invoices and statements are among the many you can choose to customize. We will work with a few of the more common templates and show you how to customize these templates to your needs and save as an Excel file.
Microsoft Excel 8 – “If” Statements
In this course, students learn how to create, edit and manipulate data using Pivot Tables & Pivot Charts
Microsoft Excel 9 - Tips, Tricks & Shortcuts
Shortcuts, tips & time-savers
Microsoft Excel 10 – Review and Quiz
Recap & Review of all that we’ve learned in Excel 1-9