KEY FEATURES

Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance, accounting, or administration, Microsoft Excel has the tools and libraries that will make your project come to life. If you have no knowledge whatsoever of this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.

• Access 42 lectures & 7 hours of content 24/7
• Learn to create workbooks & spreadsheets
• Acquire critical Excel knowledge including keyboard shortcuts
• Learn how to add formulas to power pivot
• Create custom Excel add-ins
• Discover how to customize the Excel user interface
• Learn how to work with Excel ranges & templates

NOTE: Software NOT included

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Any version of Excel including Excel in Microsoft Office 365

THE EXPERT

LearningWhilePracticing
LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through a software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

This course will take you through a comprehensive understanding of the most popular word processing tools on the market. At the completion of this course, you will have mastered the most popular and sought-after Microsoft Word tools and come away with the confidence to complete many Word tasks with efficiency and grace.

• Access 28 lectures & 9 hours of content 24/7
• Set up Vital buttons that are used often to make your work easier
• Explore the readily available document templates
• Protect a file with password & recover a unsaved document
• Perform mail merges to create mailing labels & form letters
• Learn how to prepare documents for printing and exporting

NOTE: Software NOT included

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Word 2010, Word 2013, or Word 2016

THE EXPERT

LearningWhilePracticing
LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through a software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

This course will help you understand how Access is constructed, and then will teach you how to use the major objects within it. You'll learn how to build effective database solutions for unique data needs, save time by automating tedious tasks with macros, and even create dynamic access queries from scratch. By the time you're done, you will have built a database from scratch, kept track of large sets of data, created dynamic queries and automation tools, and more!

• Access 17 lectures & 3 hours of content 24/7
• Understand how Access is constructed & how to use the major objects within it
• Build effective database solutions for unique data needs
• Save time by automating tasks with macros and/or simple VBA subroutines
• Build an efficient database table design
• Create an access database from scratch
• Manage large sets of data in Microsoft Access relational design
• Build dynamic access database queries

NOTE: Software NOT included

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Office 2010 or later

THE EXPERT

LearningWhilePracticing
LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through a software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

Microsoft Office PowerPoint: from ZERO to ADVANCED is your guide for creating and sharing professional documents. From basic to advanced features, you'll learn how to create presentations with ease and confidence. Beginning with the basics, you'll explore everything from formatting text and graphics to creating slideshows and interactive content that communicates effectively with an audience. Follow clear and thorough instructions to edit, design and format your own PowerPoint files as well as master all aspects of designing a presentation that works live on any device (Windows PC or Mac).

• Access 13 lectures & 4 hours of content 24/7
• Create a PowerPoint presentation from scratch
• Create slides, textboxes & formatting text and paragraphs
• Learn the most common Excel functions used in the Office
• Build a solid understanding of the Basics of Microsoft Excel
• Learn how to create handouts and speaker notes

NOTE: Software NOT included

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft PowerPoint 2010, Word 2013, or Word 2016

THE EXPERT

LearningWhilePracticing
LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through a software while learning it at the same time, is a source of motivation that will make you go further.

KEY FEATURES

In this course, you shall go through the VLOOKUP and XLOOKUP functions in Excel to have a look at what they are, how to use them, and some examples of using each. VLOOKUP and XLOOKUP are handy built-in functions in Excel that are used to find and retrieve information from datasets or tables. This course is designed for anyone who wants to learn how to use these two Excel functions properly and efficiently. Each lesson will include an explanation of how the function works, an example of how it can be used, and some tips on what mistakes you should avoid when using them.

• Access 20 lectures & 1 hour of content 24/7
• Add data validation to make your lookup projects more interactive & easier to use
• Perform two-dimensional lookups
• Create nested lookup functions
• Ureate nested lookup functions
• Learn how to correct the errors that most commonly arise when creating lookup formulas
• Discover how to change the #NA error with both functions
• Use range_lookup TRUE & FALSE with VLOOKUP
• Learn what search_mode is & hwo to use it with XLOOKUP
• Learn what match_mode is & how to use it with XLOOKUP
• Discover rules to follow when using VLOOKUP & XLOOKUP

NOTE: Software NOT included

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel

THE EXPERT

Kathryn Tilley | Online Excel Instructor
Kathryn Tilley has been using Excel for many years and has used her expertise to create online courses to help her students to learn all about Excel and how it can make their life easier. Her courses are aimed to help beginners how to use spreadsheets to streamline their business & make things run much more smoothly.

KEY FEATURES

In this course, you will delve into how to present data in a spreadsheet. This course is designed with easy-to-follow lessons with some example datasets that will show you how to understand "Conditional formatting" - this is a function in Excel that allows you to add rules to cells or datasets which can format the cells if the data in those cells or datasets meets specific criteria. You could use conditional formatting to improve the spreadsheets you currently produce and make them much easier to read. This course is ideal for anybody who needs a way to present their data in a quick and easy-to-read way.

• Access 8 lectures & 1 hour of content 24/7
• Learn how to build a search box with conditional formatting
• Discover how to calculate & highlight expiration dates
• Learn about functions & formulas
• Understand basic formatting in Excel

NOTE: Software NOT included

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop & mobile
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: beginner
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsofot Excel

THE EXPERT

Kathryn Tilley | Online Excel Instructor
Kathryn Tilley has been using Excel for many years and has used her expertise to create online courses to help her students to learn all about Excel and how it can make their life easier. Her courses are aimed to help beginners how to use spreadsheets to streamline their business & make things run much more smoothly.