MacTrast Deals: eLearnExcel: The Microsoft Excel Master Certification Bundle

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 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

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 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 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

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

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

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