Microsoft Excel Training Course
Excel is one of the most powerful application from the Microsoft Office Suite. The application gives you the ability to perform simple to advanced calculations and analyze the results, Excel is a spreadsheet solution that comes with data formatting, formula, function, graph, chart design, data sort, filter, pivot table and many more capabilities to organize, calculate, and create data analysis solutions.
We offer Microsoft Excel classes in three separate formats. You can take each course individually depending on your current experience level or take all 3 at a discounted cost.
This course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Students will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. They will create and modify charts, and work with graphics. Finally, they will review workbooks for spelling errors, modify page setup, and print worksheets.
This course will teach students how to work with large worksheets in Microsoft, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.
This course builds off of the Level 1 Basic and Level 2 Intermediate courses by teaching students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn how to work with advanced functions such as the vlookup, hlookup, match and index commands. Alternative Data Sets, Dynamic Worksheets with PivotTables, Automating Repetitive Tasks with Macros, Working with Other Microsoft Office Apps, Business Intelligence Analysis and Forecasts and Visualizations.
Free Ongoing Support
|Course Length (Days)||1||3|
|Course Hours (Max)||8||24|
|INDIVIDUAL - Live Instructor Online Course Cost||$295||$795|
|INDIVIDUAL - eLearn Online Course Cost||Not Available|
|GROUP - Online Live Training|
|GROUP - Onsite Live Training|
Online and Onsite Training Formats
All live online training schedules are customizable and independently set for each student as our training focuses on small group to individual one-on-one courses. We realize you have a life - therefore, we'll work with your schedule however you need us to. Click the REGISTER button to sign up for courses within month you wish to attend.