The eLearnExcel: The Microsoft Excel Master Certification Bundle will help you come to grips with Excel.
Come to Grips with the Excel Essentials in Less Than 5 Hours
Understanding Excel can feel intimidating amidst all of those empty cells, but in less than five hours, this beginner-friendly training will get you up and running with the essentials and ready to impress with your own industry-backed CPD certification. Following along expert instructors, you’ll come to grips with navigating the interface, formatting and editing, and entering formulas to streamline your workflows.
- Access 42 lessons & 4.5 hours of content 24/7
- Learn how to navigate the Excel interface & toolbars
- Discover how to format fonts & cells
- Format an Excel worksheet & insert/edit cells
- Receive an Apprentice-level Certification upon completion
Excel Formulas and Functions
Get Smart About Managing Data with Excel’s Most Popular Functions
Excel is filled with functions and formulas designed to save you time, but using them can be daunting for beginners. Across 30 step-by-step lessons, you’ll learn how to use Excel’s most popular formulas to streamline your spreadsheets. You’ll learn how to leverage advanced functions, track down information with VLOOKUP and HLOOKUP, and even earn a CPD-certified credential by the course’s end.
- Access 30 lessons & 4 hours of content 24/7
- Learn new functions to save time
- Use Excel’s Quick Analysis tool to create different chart types
- Automate your spreadsheets & use VLOOKUP and HLOOKUP to track down important insights
- Receive a CPD-certified Excel certification upon completing the course
Excel Analyzing Data Course
Make Sense of Large Datasets in 2.5 Hours
Excel sheets can hold a ton of data, but you’ll still need to organize and filter them to get the insights you’re looking for. Focused on working with lists and tables, this training will show you how to make sense of large datasets and validate your know-how with a CPD-certified credential.
- Access 26 lessons & 2.5 hours of content 24/7
- Dive into sorts & filters, as well as custom and conditional formats
- Use Excel’s CONCATENATE function to join up to 255 text strings into one text string
- Learn how to insert tables & present data faster
- Earn a CPD-certified Excel Specialist Certification
Excel Charts Course
Make Your Data User-Friendly with Charts, Photos & More
Not everyone can gather insights from staring at rows of Excel cells, but that’s what charts are for! This step-by-step guide will walk you through displaying the meaning behind the numbers with vivid sparklines, charts, and other visualization media. Finish the training, and you’ll have a CPD-certified Excel Professional Certification to back up your newfound skills.
- Access 27 lessons & 4 hours of content 24/7
- Discover how to make comparisons easier w/ charts, photos & other media
- Leverage sparklines to quickly show new trends
- Get a CPD-certified Excel Professional Certification to validate your training
Excel Pivot Tables and Dashboards Course
Tap Into One of Excel’s Most Powerful Visualization Tools
Excel is loaded with features, but few offer as much power and flexibility as Pivot Tables. From navigating the interface to creating gripping dashboards, this training will show you how to leverage Pivot Tables to its full potential. And, with the CPD-certified Excel Expert Certification, you’ll have no problem demonstrating your new understanding to potential employers.
- Access 64 lessons & 4.5 hours of content 24/7
- Discover what a Pivot Table is & how to build your own
- Utilize your Pivot Table w/ different table styles & drill-down options
- Learn how to filter data w/ slicers & timelines
Excel Protection and Design Course
Learn How to Lock Down Your Excel Workbooks in 6 Hours
Excel sheets are superb at tracking everything from accounting information to customer data, but that information is not for everyone’s eyes to see. This training will show you how to secure your workbook and determine who can access it. Make your way through the whole course, and you’ll have a CPD-certified Excel Architect certification to impress prospective employers.
- Access 30 lessons & 3.5 hours of content 24/7
- Dive into protection & sharing to better safeguard your workbooks
- Structure & design your workbook to make it collaboration-friendly
- Discover how to identify errors & prepare your workbooks for review
Excel Recording and Macros Course
Discover How to Automate Excel Like a Pro in 6 Hours
Most people view using Excel as a mind-numbing slog through empty cells, but some simple automation can help you avoid much of the tedium. Step by step, this course will guide you through automating with macros and VBA, and you’ll even emerge with a CPD-certified Excel Developer Certification, validating your skills when you’re done.
- Access 67 lessons & 5.5 hours of content 24/7
- Follow along step-by-step videos to get started
- Familiarize yourself w/ macros & VBA to save time in Excel
- Download practice files to refine your skills
- Earn a CPD-certified Excel Developer Certification & impress employers
Excel Master Project and Certification
Wrap up Your Excel Education with a Powerful CPD-Certified Credential
Think of this course as the finishing touch for your Excel education. With one final project, this training is all that stands between you and a coveted CPD-certified Excel Master Diploma certification. Whether you’re a finance professional, data analyst, accountant, or any other data-driven expert, this certification can pave the way to higher pay grades and promotion prospects.
- Access 1 lecture & 3 hours of training 24/7
- Demonstrate your Excel understanding by earning the Excel Master Diploma certification
- Improve your employment prospects w/ a CPD-certified credentia
15 Time Saving Excel Tips
Elevate Your Excel Efficiency with These Smart Shortcuts
Working in Excel can feel tedious, but smart use of shortcuts can dramatically minimize the monotony. In less than an hour, you’ll arm yourself with a myriad of shortcuts, tricks, and functions to streamline your workflows.
- Access 1 lesson & 30 minutes of content 24/7
- Discover 10 new shortcuts to speed up your workflow
- Learn tricks & tips for more efficient copy/pasting
- Increase your efficiency w/ 5 new functions & Flash Fill