Deals

MacTrast Deals: eLearnExcel: The Microsoft Excel Master Certification Bundle

The eLearnExcel: The Microsoft Excel Master Certification Bundle will help you come to grips with Excel.

eLearnExcel: The Microsoft Excel Master Certification Bundle – Go from Beginner to Certified Excel Whiz w/ Lifetime Access to 28+ Hours of Actionable Instruction – Just $39!

Excel Foundations

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

eLearnExcel: The Microsoft Excel Master Certification Bundle – Go from Beginner to Certified Excel Whiz w/ Lifetime Access to 28+ Hours of Actionable Instruction – Just $39!

Chris Hauk

Chris is a Senior Editor at Mactrast. He lives somewhere in the deep Southern part of America, and yes, he has to pump in both sunshine and the Internet.