A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.TECHNOLOGY REQUIREMENT:-Microsoft Word-Microsoft Excel-Microsoft Powerpoint IMPORTANT INFORMATION:*This is registration for a full certificate course, which includes these classes: -Mastering Microsoft Excel (Sept.8-Oct. 2)-Intermediate Excel (Oct. 5-30)-Advanced Excel (Nov. 2-27)If you would like to register for only one of the classes, please search the name of the class here. Pre-requisite classes maybe required for certain classes. *A digital badge will be issued for each completed class, with a final badge awarded upon successful completion of the full course.*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.

Gain insights into your data! Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. 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.

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database. TECHNOLOGY REQUIREMENT:- Windows 10 or later. Macs are not compatible.-Necessary rights (local administrative rights) to install programs on the computer. 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.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.TECHNOLOGY REQUIREMENT:-Microsoft Excel is required. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel & Certificate in Mastering Computer Skills for the Workplace. 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.

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free.Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time.Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results.This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions. NOTE: This Certificate must be taken in the following order: Introduction- Intermediate- Advanced IMPORTANT INFORMATION:*This is registration for a full certificate course, which includes these classes: -Introduction to BI (Sept.8-Oct. 2)-Intermediate BI (Oct. 5-30)-Advanced BI (Nov. 2-27)If you would like to register for only one of the classes, please search the name of the class here. Pre-requisite classes maybe required for certain classes. *A digital badge will be issued for each completed class, with a final badge awarded upon successful completion of the full course.*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.

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs. Requirements:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer. This Certificate must be taken in the following order: Introduction - Intermediate - Advanced IMPORTANT INFORMATION:*This is registration for a full certificate course, which includes these classes: -Introduction to SQL (Sept.8-Oct. 2)-Intermediate SQL (Oct. 5-30)-Advanced SQL (Nov. 2-27)If you would like to register for only one of the classes, please search the name of the class here. Pre-requisite classes maybe required for certain classes. *A digital badge will be issued for each completed class, with a final badge awarded upon successful completion of the full course.*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.