Tag Archive: Excel

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: advanced

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: Expert

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: advanced

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: advanced

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: Intermediate

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

It’s time to show Excel who’s boss! Whether you’re starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you’ll learn why these formulas are awesome and how they can be applied in a number of ways.

• Access 93 lectures & 6 hours of content 24/7
• Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data
• Go rogue & design your own formula-based formatting rules
• Join datasets from multiple sources in seconds w/ lookup, index, & match functions
• Pull real-time data from APIs directly into Excel
• Manipulate dates, times, text, & arrays
• Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• Microsoft Excel required

Compatibility

• Internet required

THE EXPERT

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

KEY FEATURES

Ask people what comes to mind when they think of Excel and odds are they’ll say, “spreadsheets”. However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel’s latest data visualization tools and techniques. You’ll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

• Access 49 lectures & 4.5 hours of content 24/7
• Explore each of the 20+ chart types that Excel 2016 has to offer
• Dive into a series of 12+ advanced Excel demos guaranteed to turn you into a data visualization pro

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• Microsoft Excel 2016 required

Compatibility

• Internet required

THE EXPERT

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

KEY FEATURES

This course will introduce you to Microsoft Excel’s powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you’re looking for.

• Access 86 lectures & 7 hours of content 24/7
• Use sample data from a fictional supermarket chain to get hands-on w/ Power Query
• Practice shaping, blending, & exploring project files
• Cover the fundamentals of database design & normalization
• Explore & analyze your data model using Power Pivot & DAX
• Cover basic DAX syntax & learn some of the most powerful and commonly used functions

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

Compatibility

• Internet required

THE EXPERT

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

KEY FEATURES

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to explore and analyze raw data quickly, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you’re exploring product sales, analyzing marketing tactics, or wonder how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

• Access 82 lectures & 6 hours of content 24/7
• Cover raw data structure, table layouts & styles
• Explore design & formatting options
• Understand sorting, filtering, & grouping tools
• Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

Compatibility

• Internet required

THE EXPERT

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

KEY FEATURES

During this course, you will build a foundation of working with Excel Macros and VBA. You’ll engage in several projects that will build upon one another as you progress through the basic building blocks of automating tasks within Excel. Soon you’ll be ready to enter the world of Excel VBA, where you will experience a more dynamic, robust experience for yourself and your peers.

• Access 57 lectures & 3.5 hours of content 24/7
• Automate placing & formatting a title on a worksheet
• Interact w/ the users of your Macros through input & message boxes
• Clean up multiple Excel worksheets & prepare the data to be reported on
• Create a report based on multiple sets of data found within multiple Excel worksheets
• Automate the creation of Excel Formulas to SUM data up in your report

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• Microsoft Excel 2010, 2013, or 2016

Compatibility

• Internet required

THE EXPERT

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

• Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
• Excel, Word, PowerPoint, Outlook, Access and Visio
• SharePoint End-User 2007, 2010, 2013
• VBA (Excel and Access)
• Adobe Suite
• Photoshop, Illustrator, InDesign
• Maya (Modeling and Animation)
• Unity3d (Game Design)
• HTML, CSS and JavaScript
• Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

KEY FEATURES

More than 750 million people have Excel installed on their computer but most do not know how to use it. Whatever version of Excel you have, this course will show you how to build and prepare a workbook good enough for a Fortune 500 CEO, to a household budget, and everything in between.

• Access 80 lectures & 6.5 hours of content 24/7
• Get downloadable Excel workbooks which you can use to follow along
• Learn how to install Microsoft Excel & work w/ formulas and functions
• Calculate w/ the IF Function & apply conditional formatting
• Use the PMT Function to explore monthly & yearly compounding
• Use Google Drive to collect data

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• Microsoft Excel required

Compatibility

• Internet required

THE EXPERT

Warrick Klimaytys has spent many years with all kinds of computers in many different situations around the world and is eager to share his knowledge and skills with the StackCommerce community.

Around a decade ago Warrick started his professional life in the military where experienced all kinds of computers and machines. Today, he could be referred to as just a Microsoft “Windows Warrior”. As a result of his past experience, he finds it best to deliver lessons in bite sized chunks.

KEY FEATURES

With thousands of features and menu commands to get lost in, learning to seamlessly navigate Microsoft Excel 2016 is essential to succeeding in today’s workforce. Gain a solid foundation in this spreadsheet software with this introductory course, and use your newfound knowledge to leverage your salary or take on a new career. You’ll learn everything from spreadsheet terminology to how to insert graphics and charts, becoming comfortable with the newest edition of Excel.

• Access 38 lectures 24/7
• Learn the basic functions & features of Excel 2016
• Discover basic worksheet skills & learn how to work w/ formulas
• Explore editing workbooks from a granular perspective
• Create professional-quality graphs & charts
• Practice w/ Excel & fortify your knowledge by completing 3 projects
• Impress potential employers w/ your new skills

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Their online classes allow students to take courses at their own pace and schedule with step-by-step tutorials. Their courses offer high quality video-based training presented in an easy to learn format.

For more details on this course and instructor, click here.

KEY FEATURES

Once you’ve mastered the basics, take your knowledge to the next level with the Excel 2016 Advanced Course. Move through the intermediate-to-advanced tutorials at your own pace and understand how to manage workbooks, track your changes, troubleshoot, and most importantly, reduce your workload by automating repetitive tasks. It’ll make your workday more productive, and impress your colleagues and superiors with your ninja-like skills. Once you’ve completed the course, you’ll be fully prepared to ace the Microsoft Office Specialist exam. Take that, Excel.

• Advance your Excel 2016 skills w/ 24/7 access to 34 lectures
• Prepare to pass the Microsoft Office Specialist exam in Excel, Exam-427 & Exam-428
• Understand how to manage workbooks
• Learn to calculate investments
• Discover how to automate workbooks
• Figure out how to create custom formats & layouts

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels

Compatibility

• Internet required

THE EXPERT

iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Their online classes allow students to take courses at their own pace and schedule with step-by-step tutorials. Their courses offer high quality video-based training presented in an easy to learn format.

For more details on this course and instructor, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: advanced

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: Expert

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: advanced

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: advanced

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: Intermediate

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

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

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming and mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

The Irish Academy of Computer Training Group operates a suite of global sites that help people enhance their skills. For more details on this subscription and instructors, click here.

KEY FEATURES

With thousands of features and menu commands to get lost in, learning to seamlessly navigate Microsoft Excel 2016 is essential to succeeding in today’s workforce. Gain a solid foundation in this spreadsheet software with this introductory course, and use your newfound knowledge to leverage your salary or take on a new career. You’ll learn everything from spreadsheet terminology to how to insert graphics and charts, becoming comfortable with the newest edition of Excel.

• Access 38 lectures 24/7
• Learn the basic functions & features of Excel 2016
• Discover basic worksheet skills & learn how to work w/ formulas
• Explore editing workbooks from a granular perspective
• Create professional-quality graphs & charts
• Practice w/ Excel & fortify your knowledge by completing 3 projects
• Impress potential employers w/ your new skills

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner

Compatibility

• Internet required

THE EXPERT

iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Their online classes allow students to take courses at their own pace and schedule with step-by-step tutorials. Their courses offer high quality video-based training presented in an easy to learn format.

For more details on this course and instructor, click here.

KEY FEATURES

Once you’ve mastered the basics, take your knowledge to the next level with the Excel 2016 Advanced Course. Move through the intermediate-to-advanced tutorials at your own pace and understand how to manage workbooks, track your changes, troubleshoot, and most importantly, reduce your workload by automating repetitive tasks. It’ll make your workday more productive, and impress your colleagues and superiors with your ninja-like skills. Once you’ve completed the course, you’ll be fully prepared to ace the Microsoft Office Specialist exam. Take that, Excel.

• Advance your Excel 2016 skills w/ 24/7 access to 34 lectures
• Prepare to pass the Microsoft Office Specialist exam in Excel, Exam-427 & Exam-428
• Understand how to manage workbooks
• Learn to calculate investments
• Discover how to automate workbooks
• Figure out how to create custom formats & layouts

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels

Compatibility

• Internet required

THE EXPERT

iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Their online classes allow students to take courses at their own pace and schedule with step-by-step tutorials. Their courses offer high quality video-based training presented in an easy to learn format.

For more details on this course and instructor, click here.

KEY FEATURES

Excel with Business offers so much more than Excel training. They do that with the best of them, of course, but if you’re looking to boost your career or business prospects, EwB offers thousands of hours of online learning in Microsoft, business, technology, finance, and even wellbeing. All of these courses are designed to help you supercharge your business acumen, become more productive, and enrich your life with new skills and hobbies. With one year of access to their complete library, you’ll be hard-pressed to run out of new things to learn.

• Get unlimited access to more than 60 courses & 2,000 videos
• Earn CPD UK Accredited Certificates of Attainment for each course you complete
• Access members only live classes including Q & A
• Boost your professional & personal skills w/ complete access to all future courses added during your subscription
• Over 20 Microsoft courses including 5 Excel courses
• Business courses ranging from Project Management to communication, including all courses in the Mini MBA Bundle
• Tech courses such as web development, Photoshop & WordPress
• Fun courses like photography & chess

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: 1 year
• Access options: web streaming
• Certificates of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels

Compatibility

• Internet required

THE EXPERT

Formed in 2009, Excel with Business was created by founders Marc, Vin and Chris to solve a problem close to their hearts – ineffective Microsoft Excel training. As three Strategy and Management Consultants they understood the importance of being able to apply MS Excel skills in a business context.

The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:

A business relevant Excel training course that was affordable and personalized to each person taking it.

The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.

For more details on this course and instructor, click here.

KEY FEATURES

Linear Regression is a powerful method for quantifying the cause and effect relationships that affect different phenomena in the world around us. This course will teach you how to build robust linear models that will stand up to scrutiny when you apply them to real world situations. You’ll even put what you’ve learnt into practice by leveraging Excel, R, and Python to build a model for stock returns.

• Access 40 lectures & 5 hours of content 24/7
• Cover method of least squares, explaining variance, & forecasting an outcome
• Explore residuals & assumptions about residuals
• Implement simple & multiple regression in Excel, R, & Python
• Interpret regression results & avoid common pitfalls
• Introduce a categorical variable

PRODUCT SPECS

Details & Requirements

• Length of time users can access this course: lifetime
• Access options: web streaming, mobile streaming
• Certification of completion not included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels

Compatibility

• Internet required

THE EXPERT

Loonycorn is comprised of four individuals—Janani Ravi, Vitthal Srinivasan, Swetha Kolalapudi and Navdeep Singh—who have honed their tech expertises at Google and Flipkart. The team believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.