Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.TECHNOLOGY NOTE: -Microsoft Excel is required.PREREQUISITE REQUIREMENT: -Students should have completed Mastering Microsoft Excel. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. Prerequisite Recommendation: While not required, participants are encouraged to complete Introduction to Power BI before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, Power BI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.TECHNOLOGY REQUIREMENTS:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer.Prerequisite Requirement: Students should have taken Introduction to SQL and have competency in the Introductory level of SQL. IMPORTANT INFORMATION:*This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence. TECHNOLOGY NOTE: Students must have Microsoft Excel to complete this class. PREREQUISITE REQUIREMENT: -Students should have completed Mastering Microsoft Excel & Intermediate Excel. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.Prerequisite Recommendation: While not required, participants are encouraged to complete Introduction to Power BI & Intermediate Power BI before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, Power BI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.TECHNOLOGY REQUIREMENTS:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer.Prerequisite Requirement: Students should have taken Introduction to SQL & Intermediate SQL and have competency in the Introductory and Intermediate levels of SQL. IMPORTANT INFORMATION:*This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.