In this course, Excel 365 Pro, you will take your Excel knowledge to the ultimate level. When youíre finished with this course, you will have the skills needed to create advanced professional spreadsheets (and complete preparation for the Office exams).

Test your Excel knowledge

Take your Excel skills to the next level by learning how to sort, filter, and pivot data.

In this course, you learn the basic commands for manipulating Excel in IBM RPA. Among the actions to work with Excel are reading and writing in an Excel file.

Make sure you’re not reinventing the wheel in your Excel spreadsheets. Logic functions are at the core of automating your work and keeping things up to date. Learn by example how to write and debug the AND, OR, NOT, IF, IFS, and IFERROR functions.

Save time and reduce errors by using the right functions in Excel. Statistics and finance functions can help you make quick work of reports and evaluations. Learn by example how to use the SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV functions.

Learn to have better control over your excel books.

Understanding and using exceptions is vital if you want to create maintainable code that responds correctly to runtime errors. This course will teach you how to handle errors in C# applications by throwing, catching, and customizing exceptions.

This course will teach you the tips, tricks, and pitfalls of exception handling in Java to help you prepare for the certification exam.

Application stability and reliability are essential to application success. This course will teach you how to use Java exceptions to build stable and reliable Java applications.

A trigger is responsible for executing an Azure function and there are dozens of triggers to choose from. This module will you show you some of the most common types of triggers and how to configure them to execute your logic.

This course covers the use of the Analytics service in Couchbase and the use of its query language - N1QL for Analytics. It includes use cases, the architecture which supports analytics, and the execution of queries to understand the underlying data.