Online Class: Ultimate Excel Training Bundle
no certificate
with CEU Certificate*
Only $125.00* - Save $165.00
-
62Lessons
-
92Exams &
Assignments -
45Hours
average time -
4.5CEUs
Course Description
Excel 2019 is the latest iteration of the popular spreadsheet software developed by Microsoft. Excel allows users to create rich, stylized spreadsheets used for storing, organizing, sorting, calculating, and charting data. With Excel, you can create visually appealing content that represents your data. Before you start using Excel though, you should first learn what all the features Excel offers are and how to use them, so that your spreadsheets are built correctly the first time.
- Create spreadsheets
- Format cells, rows, columns, and entire worksheets so they fit and match your data
- Enter data into a spreadsheet
- Use formulas and functions for math, accounting, and totaling
- Create formulas and functions
- Calculate data
- Create charts and diagrams for your data
- Create data lists and forms
- Create and use pivot tables and pivot charts
- Work with Excel templates
- Share and protect your worksheets and workbooks
- Use What-If Analysis to determine possible outcomes
- And much more!
Nowadays, your Excel spreadsheet should include at least one chart, so we have step-by-step tutorials on charting, graphics, and using images. All these added components help make spreadsheets more visually appealing. We also review ways to use common functions as well as sort and filter data, so you can view large data sets in chronological, alphabetical or numerical order.
Excel is one of the most powerful tools in Microsoft Office. You can import, query, analyze and manipulate data to create powerful reports that can be used by individuals and enterprise businesses alike. This course explores some of the more advanced features of Microsoft Excel to give you a more powerful experience when you need the most out of spreadsheet software.
- Outlines, Custom Views, and Templates
- Mathematical Functions
- Data Functions and Data Lookups
- The IF Function
- Manipulating Text
- Conditional Formatting
- Sparklines
- Importing, Cleaning and Validating Data
- Pivot Tables and Pivot Charts
- The What-If Analysis
- Goal Seek and Solver
- The Analysis ToolPak
- Using Get & Transform to Perform Queries
- Macros
- And Much More!
Pivot tables are one of the most beneficial tools in Excel, and this course covers pivot tables both basic and advanced features. It then moves on to pivot charts, which are graphs that can be used with pivot table data.
Analysis tools in Excel 2019 are some of the most advanced and useful to users that want to run complex reports. Excel has three What-If analysis tools that can be run on your data and provide reports on goals that give answers to your problems. The Solver and Analysis Toolpak are two add-ins that expand on these tools, and they are also covered in this course.
The final lessons cover data validation, troubleshooting, querying data and macros. These lessons provide ways to work with data and clean up unstructured information. This course fully covers advanced features in Excel so that you can create complex spreadsheets for business or individual use.
- Completely Online
- Self-Paced
- 6 Months to Complete
- 24/7 Availability
- Start Anytime
- PC & Mac Compatible
- Android & iOS Friendly
- Accredited CEUs
Additional Course Information
- Document Your Lifelong Learning Achievements
- Earn an Official Certificate Documenting Course Hours and CEUs
- Verify Your Certificate with a Unique Serial Number Online
- View and Share Your Certificate Online or Download/Print as PDF
- Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced | |
Instructor support | |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 600+ courses
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 24 Months |
No. of courses | 600+ |
Student Testimonials
- "i found this course to be very thorough in explanation. The detail and explanation was very easy to follow and look back at." -- Patricia A.
- "This course is detailed and easy to follow." -- Tonji R.
- "This course was very helpful to me." -- Yu L.
- "Thoroughly enjoyed the course, feel like I gained a lot of knowledge and that I am better prepared to use Excel in my work." -- Claire S.
- "Plenty of material in this course. For me, it was very helpful." -- Jennifer O.
- "I thought this course was very helpful. I have learned a lot that I can use. Thank you." -- Connie R.
- "It was a great course that went into some advanced Excel abilities that I had not typically used." -- Greg M.
- "This course was very informative. It helped me to regain my confidence in using Excel." -- David G.
- "Taking the Microsoft Excel course was something that was long overdue, and this course in particular met my needs and expectations. It was helpful in learning basic actions more thoroughly, as well as more newfound advanced features I was eager to comprehend. The theme of each lessons were explained well and I am looking forward to putting my knowledge of Excel to good use." -- Jadah N.
- "I thought this course was beneficial. I never used Excel for much more than adding and subtracting. However, I have a great new understanding of the possibilities of this program now. I have done a cool project using Excel since starting this class and am interested in going further. Thank you." -- Daryl S.
Related Courses
- 45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
- 30 hours 3.0 CEUs Microsoft Office 2021: Word, Excel, PowerPoint and Outlook $110.00
- 14 hours 1.4 CEUs QuickBooks Online $95.00
- 5 hours 0.5 CEUs Outlook 2021 $95.00
- 7 hours 0.7 CEUs Financial Analysis 101: Planning and Control $95.00
- 7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00
- 5 hours 0.5 CEUs SalesForce 101 $95.00
- 6 hours 0.6 CEUs Microsoft Visio 2021 $95.00
- 6 hours 0.6 CEUs Microsoft Publisher 2021 $95.00
- 7 hours 0.7 CEUs Understanding Financial Statements $95.00
- 8 hours 0.8 CEUs Adobe InDesign 101 $95.00
- 5 hours 0.5 CEUs Windows 10 $95.00
- 11 hours 1.1 CEUs Introduction to CSS $95.00
- 7 hours 0.7 CEUs Google Sheets $95.00
- 6 hours 0.6 CEUs Google Docs $95.00
- 7 hours 0.7 CEUs Google Slides $95.00
- 8 hours 0.8 CEUs MySQL $95.00
- 6 hours 0.6 CEUs Cybersecurity 101 $95.00
- 6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics $95.00
- 7 hours 0.7 CEUs Microsoft Word 2021 $95.00
- 17 hours 1.7 CEUs Introduction to SQL $95.00
- 11 hours 1.1 CEUs Excel 2021 $80.00
- 8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 $95.00
- 4 hours 0.4 CEUs Slack $95.00
- 6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online $95.00
- 9 hours 0.9 CEUs Microsoft Project 2021 $95.00
- 8 hours 0.8 CEUs Microsoft Access 2019 $95.00
- 8 hours 0.8 CEUs Quicken Tutorial: All Versions $95.00
- 7 hours 0.7 CEUs PowerPoint 2021 $95.00
- 32 hours 3.2 CEUs Accounting & Bookkeeping 101 for Everyone $95.00