Spear phishing. Ransomware. Malware. Like the threats your business faces, the cybersecurity lexicon is constantly evolving. This comprehensive presentation imparts practical privacy and data security know-how and creates fluency with the latest terminology. Learn best practices for cybersecurity safety, as well as tailored training for those in positions responsible for implementing security policies. It is...

This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that...

In this one-hour course, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables, create structured references, enter formulas, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of...

A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has...

This one-hour course will introduce users to table functions in Excel and Power BI. Users will demonstrate an ability to apply and utilize named ranges and naming conventions to data. Specific focus will be given to common formulas and functions within Excel. Common pitfalls in formula implementation will be discussed. Users will utilize exercises alongside...

This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel version. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to...

This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables...

Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to...

This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a...

This one-hour course will focus on the use of Excel with Power BI and Power Query to organize and analyze data. Users will primarily work with calculated columns generated from existing data. They will walk through hands-on exercises to create calculated columns, add dimensions to existing data tables, and create hierarchies within the data tables....

This one-hour course serves as the introductory module to data analytics. Users of the course will learn the basic terminology used in performing data analytic-based tasks or working with data analytics. An understanding of the sources of data and importance in combining multiples sources will be developed. Users will be introduced to and will practice...

This course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It...