Minneapolis Public Schools

Accelerate your organization's success with AI. Learn how to leverage AI to cut costs, enhance data insights, automate tasks, and optimize efficiency. Master AI concepts, techniques, and strategic planning to drive innovation and position your business for the future. Courses in this certificate must be taken in the following order: Introduction to ChatGPT Intermediate AI AI Planning and Strategies Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ

Adobe Illustrator is the industry standard computer illustration software. Use Illustrator to draw shapes and design logos, flyers, posters, banners, business cards or any other vector graphics for print or web. Learn Adobe Illustrator fundamentals to set up a print document and use various tools to draw, type and color all kinds of shapes and illustrations. Discover how to efficiently manage layers and artboards, and create print-ready PDF documents. Software Requirements: Adobe Illustrator. More information on Adobe Creative Cloud software can be found at adobe.com This class can be taken on its own or as part of the Graphic Design Software Essentials Certificate Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: Getting to Know the Interface and Drawing Tools Interface menus, tools and panels. Working with various drawing and transformation tools Drawing anything from simple to complex shapes and illustrations. Unit 2: Working with Color and Text Working with color panels in the software Creating, managing and applying color and color groups Learning how to type and format text using various text formatting and styling tools and panels. Unit 3: Working with Layers and Pen tool Layers and layer management. Working with the Pen tool. Modifying a drawing using Pen tool options. Unit 4: Working with Artboards Creating and managing multiple Artboards Learning how to layout and design corporate package Business cards, letterhead and envelopes Creating print-ready PDF files

Adobe InDesign is the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. This course is a comprehensive exploration of InDesign tools and capabilities to create professional documents. Learn how to manage the InDesign environment, create, setup, design, enhance and finalize multi-page documents. Software Requirements: Adobe InDesign. More information on Adobe Creative Cloud software can be found at adobe.com This class can be taken on its own or as part of the Graphic Design Software Essentials Certificate Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: Getting to Know the Interface and Setting up a Document Interface menus Tools Panels Starting and setting up a multi-page document in InDesign Unit 2: Working with Objects and Color Learning to work with color panels Creating, managing and applying color to elements Inserting and managing images and illustrations into an InDesign document Unit 3: Working with Text Learning about insert and flow text to multiple pages Managing long text documents Text editing in InDesign documents Unit 4: Typography Advance typography tools and menus Character and paragraph settings and styles Creating print-ready PDF files.

This fundamental course covers Adobe Photoshop CC most commonly used tools, menus and panels. Learn all the basics of Photoshop to effectively work with selection and editing tools, layers, and masks to edit, retouch and enhance existing images or create your own composite digital art work. Impress your business organization, friends and family by enhancing their photos and create magazine cover quality enhanced images. Software Requirements: Adobe Photoshop. More information on Adobe Creative Cloud software can be found at adobe.com This class can be taken on its own or as part of the Graphic Design Software Essentials Certificate Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: Getting to know the Interface and Selection Tools Interface menus Tools Panels Working with the various Selection tools Unit 2: Working with Layers and Masks Layers and layer management Non- destructive editing using masks How to type and format text Using various type formatting and style tools and panels Unit 3: Image Correction & Enhancement Photo correction and enhancement tools Crop, dodge and burn Recoloring, retouching Healing brushes Unit 4: Using the Drawing Tools How to use the Pen tool Other drawing tools in Photoshop Advanced drawing and selection File formats How to save files for print or web

This Certificate offers you an introduction to the use of games for business purposes. Learn the basics of designing both video and analog games, with a focus on games beyond entertainment. In the first course, Explore game design resources, mechanics, and verbs used in different games. Develop game ideas and understand how to work with game developers. In the second course, discover the basics of the video game design process, main video game genres, and use a game development application to start creating games. Completing this Certificate in Basic Game Design will equip you with knowledge and skills to create games and understand game design. Courses must be taken in order: Introduction to Game Design Intermediate Video Game Design Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Introduction to Game Design Unit 1: What Makes a Game? Practical Definition for Game The Anatomy of a Game Games and Play Different Types of Games Unit 2: Essentials of Design Getting Beyond a Game Idea Game Verbs and Game Mechanics Documentation Test Early, Test Often Unit 3: Game Design: Solo and in Teams Defining Development Needs Roles in Game Design Finding Design and Development Partners Unit 4: Serious Games & Gamification Games Beyond Entertainment Designing "Serious" Games Gamification Designing Gamification Systems Intermediate Video Game Design Unit 1: A brief history of Video Game Development Arcades & Consoles From PCs to Multiplayer Play a Game -Game Analysis Game Maker Introduction Unit 2: Player Motivation Geographics, demographics, and psychographics Who Plays Why We Play Game Maker Making Art: About Sprites, Objects, Rooms Unit 3: Platforms, Genres and Story Elements Game Application: The Audience Platforms & Player Modes Story Elements: Premise, Backstory, Synopsis, Theme, & Setting Character Archetypes & Character Development Game Maker: Programming Events & Actions Unit 4: The Production Process Documentation: The Game Design Doc Creating the Team Production Phases Marketing Game Maker: Your First Game

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned. Students need to have an understanding of Microsoft Excel to complete this certificate. This Certificate is comprised of the following courses. (Scroll down for class details): Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Data Analysis Unit 1: Understanding Data Identify sources of Data Discover methods of Collecting Data Examine Quantitative Data Examine Qualitative Data Unit 2: Processing Data Introduction to Statistics Determine the Appropriate Statistical Method for use in various scenarios Identify methods of Sorting and Filtering Data Categorize Data Unit 3: Analyzing Data Discuss Probability and the Normal Distribution Perform Trend Analysis Perform Breakeven Analysis Understand basic Statistical Modelling Unit 4: Interpreting and Presenting Results Design Professional-looking Tables Generate Effective Charts Create Pivot Tables and Pivot Charts Compile a Dashboard for Management Intermediate Data Analysis Unit 1: Looking for Differences between Groups Two separate groups Two related groups Three or more groups Unit 2: Looking for Relationships Pairs of variables Clusters of variables Predicting one variable from one or more variable Unit 3: Looking at Ratings Tests of difference using ratings Tests of relationship using ratings Unit 4: Looking at How to Report the Results Visual displays How to draft the narrative How to engage your audience Advanced Data Analysis Unit 1: Developing a Survey Purposes of surveys Fundamentals of Survey Research Ethical Considerations Likert Scales Unit 2: Comparing Means Chi-Square Statistical Significance Communicating Results Graphically and Textually Practical Problems involving Means Comparisons Unit 3: Finding Differences between Groups ANOVA Post Hoc Comparisons Communicating Results Graphically and Textually Practical Problems Involving ANOVA Unit 4: Individual Research Inquiries Developing Research Questions Setting Up Study Communicating Results Graphically and Textually

Become a Microsoft Office Pro! Master Word, Excel, and PowerPoint to create stunning documents, analyze data, and captivate audiences. This hands-on course will boost your career and digital skills. Courses: Mastering Microsoft Excel Mastering Microsoft Word Mastering Microsoft PowerPoint Software requirement: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Excel Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users Word Unit 1: Getting Started with Word Why businesses use Word for document creation Launch Word and create your first Word document Discover how to protect and save your documents. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: Word Document Creation Explore the different features and functionality of Word Understand documents and their makeup Learn how to create, format, and present documents Create multiple documents and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage documents Learn to organize documents into chapters and sections Create “live” connections between documents and Excel worksheets Create effective and informative documents with tables and charts Unit 4: Word Management and Sharing Create meaningful file names and understand filing systems to manage Word documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including print settings PowerPoint Unit 1: PowerPoint Overview Why businesses use PowerPoint for presentations Launch PowerPoint and create your first PowerPoint presentation Discover how to protect and save your slides. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: PowerPoint Document Creation Explore the different parts of the PowerPoint slide navigation Understand slides and templates, and their makeup Learn how to populate, format, and present slides Create multiple slides and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage slides Learn to organize slides into sections Create “live” connections between slides and Excel worksheets Create effective and informative slides with tables and charts Unit 4: PowerPoint Management and Sharing Create meaningful file names and understand filing systems to manage PowerPoint documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including print settings

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. Students must have Microsoft Excel installed to complete this certificate. Courses must be taken in order: Mastering Microsoft Excel Intermediate Excel Advanced Excel Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Mastering Microsoft Excel Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users Intermediate Excel Unit 1: Organizing Worksheet and Table Data Introduction to tables Formatting tables using table styles Using formulas in tables Sorting and Filtering table data Unit 2: Understanding Popular Excel Functions Understanding Named Ranges Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3: Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using templates Customizing Excel toolbar Unit 4: Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables Advanced Excel Unit 1: Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2: Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3: Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4: Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data

Save time, track money, and get important insights with Quickbooks Online. As a small business manager, owner, bookkeeper, or accounting professional, Quickbooks Online is the preferred choice. Benefit from the patches and regular automatic upgrades to the software. Gain a comprehensive understanding of QuickBooks Online and learn how to work with more advanced topics to maximize the benefits of the platform. Courses must be taken in order: Level 1 Level 2 Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Level 1: Unit 1: Introduction to QuickBooks Online Use the interface Edit the Chart of Accounts Make General Journal Entries Memorized Transactions Find and Adjust General Journal Entries Create Journal Reports Create Inventory Items Create Service Items Inventory Report Unit 2: Create and modify supplier records Enter Bills for purchases Enter Checks Find and modify Supplier Bills Midterm Project Unit 3: Create Memorized Transactions Purchase Orders Supplier Reports Payments Supplier Credit Unit 4: Create and modify Customer records Enter Sales Receipts Record Sales Estimates Enter Invoices in Accounts Receivable View, adjust and delete sales Receive Customer Payments Run Customer Reports Final Project Level 2: Unit 1: Company Setup, Banking and Credit Cards Setting up and Customizing Settings Entering Balances – B/L, Customer, Vendor and Inventory Bank Reconciliation Using Credit Card Unit 2: Budgets and Inventory Budgets Tags Adjusting bundles Midterm Project Unit 3: Multiple Currencies Setting up Foreign Currency Updating the Exchange Rate Setting up a Foreign Currency Bank Account Setting up a Foreign Vendor Setting up a Foreign Customer Purchases and Sales using foreign currency Unit 4: Statements, NSF Checks and Bad Debts Preparing Customer Statements NSF cheques Using Projects Final Project

Online users say a website’s design is the number one criteria for deciding whether a company is credible or not, according to recent research. Understanding what it takes to produce effective web design is essential in today’s market of highly saturated digital competition. First discover the basics of web design using HTML and CSS. No prior knowledge of HTML or web design is required. After the first course you will have the info you need to plan and design effective web pages. Then find out how to create effective and dynamic websites/applications. Take away a functioning web application hosted on a web server that is both accessible and Search Engine Optimized. Finally, learn about responsive design process, advanced layout and design features. Plus explore industry standard technologies and frameworks. This Certificate must be taken in the following order: Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Introduction Unit 1: The Principles of Web Design Plan the Structure of a Website / File Management Target your audience Designing Effective Web Layout and Navigation Unit 2: Structure vs Presentation Introduction to HTML5 Basic Markup Introduction to CSS3 - Linking and Embedding Stylesheets Unit 3: Web Graphics and Content Understanding web graphics Acquiring images / Copyright law and graphics on the web Optimizing images Adding images to your web page Unit 4: Publishing Your Site Domain Name Registration / Hosting Services Finding the appropriate Hosting space Publishing Website Using FTP-Client Intermediate Unit 1: Javascript Expressions and Control Flow Functions, Objects, and Arrays Form Validation and Error Handling Accessing CSS from JavaScript Unit 2: MySQL Install a local testing server Use phpMyAdmin to create MySQL databases and manage users Create MySQL database tables with common field types and options Gain a working knowledge of most common MySQL statements Unit 3: PHP Structure Expressions and functions Objects and arrays Practical use Unit 4: Accessibility and Search Engine Optimization Accessibility Guidelines Accessibility Conformance Search Engine Optimization Advanced Unit 1: Responsive Web Design Planning your layout Creating HTML containers, content, and links Unit 2: Responsive Web Design - Styling Creating and styling the layout with CSS Creating a menu system Styling headings, body text, and footers Unit 3: Responsive Web Design – Styling the Navigation & Making Adjustments Making layout adjustments for different screen sizes Swapping high-resolution graphics for Retina displays Making sure content is printable Where to go for more information Unit 4: Responsive Web Design / Additional Frameworks What is Bootstrap Creating a basic template Reviewing basic styles and typography Where to go for more information

Coding is becoming one of the most in-demand skills in the workplace today. As a result, coding has become a core skill that bolsters one’s chances of becoming a higher value to organizations. The highest demand is for programming languages with broad applicability. Begin by getting introduced to the basics of computer programming and various programming languages. Then go to the next level and acquire all the basics of HTML and CSS. You will learn the relationship between these two industry-standard web page coding languages and the step by step process of hand coding and building web pages. Finally, discover the advanced features of CSS and learn how to use this very powerful language. Students must take the Coding Certificate classes in the below order: Introduction to Coding HTML Fundamentals CSS Fundamentals Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Introduction to Coding Unit 1: Introduction to Programming Types of programming languages Practical Uses of Programing Text Editors Unit 2: Basic HTML/CSS Introduction to HTML Introduction to CSS Making a Simple Web Page Unit 3: Drawing and Coloring using Code Elements of Java Script Basic Drawing Using Code Basic Coloring Using Code Unit 4: Basic Animation using Code Uses of Animation Animation Basics Making a Simple Animation HTML Fundamentals Unit 1: HTML Basic Tags naming convention, tags: h, p, b, i, u, hr,br, attributes Unit 2: More HTML Tags links, lists, tables Unit 3 Images, directory structure Unit 4 Creating a multipage website, domains, hosting, pointing, FTP CSS Fundamentals Unit 1: Getting to Know CSS about CSS, CSS syntax, CSS types, working with internal CSS, styling text, styling links, styling lists, and styling tables. Unit 2: Using External CSS working with external CSS sheets, styling a multi-page website, Google fonts, and Web colors. Unit 3: div Elements id Selectors, introduction to elements, floating elements, Clearing Unwanted Floated Elements, web page layout using elements Unit 4: More about div Elements centering a web page, CSS box model, resetting margins and paddings, class selectors, inline CSS, tag

Equip yourself with the foundational knowledge and advanced skills needed to safeguard networks, data, and systems from cyber attacks. Conquer the core principles of cybersecurity, develop strategies to protect networks, and gain hands-on experience in identifying and mitigating cyber threats. Come away with the essential tools and knowledge to succeed in the ever-evolving field of cybersecurity. Courses in this certificate must be taken in the following order: Introduction to Cybersecurity Network Security and Defense Strategies Advanced Cyber Threat Analysis and Mitigation Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ

The Adobe software tools are the leading software for graphic design. Adobe Illustrator is the industry standard computer illustration software. Use Illustrator to draw shapes and design logos, flyers, posters, banners, business cards or any other vector graphics for print or web. Adobe InDesign is the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. Use Adobe Photoshop to effectively work with selection and editing tools, layers, and masks to edit, retouch and enhance existing images or create your own composite digital art work. Access to the Adobe software tools required. Courses: Adobe Illustrator Essentials Adobe Photoshop Essentials Adobe InDesign Essentials Software Requirements: Adobe Illustrator, Adobe Photoshop and Adobe InDesign. More information on Adobe Creative Cloud software can be found at adobe.com Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Adobe Illustrator Essentials Unit 1: Getting to Know the Interface and Drawing Tools Interface menus, tools and panels. Working with various drawing and transformation tools Drawing anything from simple to complex shapes and illustrations. Unit 2: Working with Color and Text Working with color panels in the software Creating, managing and applying color and color groups Learning how to type and format text using various text formatting and styling tools and panels. Unit 3: Working with Layers and Pen tool Layers and layer management. Working with the Pen tool. Modifying a drawing using Pen tool options. Unit 4: Working with Artboards Creating and managing multiple Artboards Learning how to layout and design corporate package Business cards, letterhead and envelopes Creating print-ready PDF files Adobe Photoshop Essentials Unit 1: Getting to know the Interface and Selection Tools Interface menus Tools Panels Working with the various Selection tools Unit 2: Working with Layers and Masks Layers and layer management Non- destructive editing using masks How to type and format text Using various type formatting and style tools and panels Unit 3: Image Correction & Enhancement Photo correction and enhancement tools Crop, dodge and burn Recoloring, retouching Healing brushes Unit 4: Using the Drawing Tools How to use the Pen tool Other drawing tools in Photoshop Advanced drawing and selection File formats How to save files for print or web Adobe InDesign Essentials Unit 1: Getting to Know the Interface and Setting up a Document Interface menus Tools Panels Starting and setting up a multi-page document in InDesign Unit 2: Working with Objects and Color Learning to work with color panels Creating, managing and applying color to elements Inserting and managing images and illustrations into an InDesign document Unit 3: Working with Text Learning about insert and flow text to multiple pages Managing long text documents Text editing in InDesign documents Unit 4: Typography Advance typography tools and menus Character and paragraph settings and styles Creating print-ready PDF files.

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. Leave class with a set of skills that are in high demand and will be a deciding factor in your future success. Software requirements: Microsoft Excel This class can be taken on its own, as part of the Certificate in Mastering Computer Skills for the Workplace, or as part of the Certificate in Mastering Excel. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users

Bring your ideas to life and leave a lasting impression with Microsoft PowerPoint. Master the tools and techniques that turn humdrum slides into dynamic presentations that will captivate your audience. With hands-on practice and real-world examples, learn design principles and multimedia elements such as images, videos, and charts that elevate you to the next level. Acquire critical know-how to deliver your presentations with confidence and ease. Whether you're a beginner or a seasoned user, you'll find new ways to work smarter, not harder. Leave class with in-demand skills and the ability to create professional, visually appealing presentations that will engage your audience and help you stand out. Software requirement: Microsoft PowerPoint This class may be taken alone or as part of the Certificate in Mastering Computer Skills for the Workplace. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: PowerPoint Overview Why businesses use PowerPoint for presentations Launch PowerPoint and create your first PowerPoint presentation Discover how to protect and save your slides. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: PowerPoint Document Creation Explore the different parts of the PowerPoint slide navigation Understand slides and templates, and their makeup Learn how to populate, format, and present slides Create multiple slides and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage slides Learn to organize slides into sections Create “live” connections between slides and Excel worksheets Create effective and informative slides with tables and charts Unit 4: PowerPoint Management and Sharing Create meaningful file names and understand filing systems to manage PowerPoint documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including print settings

Master the art of document creation and take your professional skills to the next level with Microsoft Word, which is essential for success in the modern business world. Discover how to format text, paragraphs, images, and pages with ease. Get hands-on experience creating professional-looking documents, from resumes and cover letters to reports and brochures. Find out how to use templates and themes to save time and streamline your workflow. Walk away equipped with the skills to create, edit and share polished documents that will impress employers and coworkers and give you a competitive edge in the workplace. Software requirement: Microsoft Word This class can be taken alone or as part of the Certificate in Mastering Computer Skills for the Workplace. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: Getting Started with Word Why businesses use Word for document creation Launch Word and create your first Word document Discover how to protect and save your documents. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: Word Document Creation Explore the different features and functionality of Word Understand documents and their makeup Learn how to create, format, and present documents Create multiple documents and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage documents Learn to organize documents into chapters and sections Create “live” connections between documents and Excel worksheets Create effective and informative documents with tables and charts Unit 4: Word Management and Sharing Create meaningful file names and understand filing systems to manage Word documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including print settings

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. This Certificate must be taken in the following order: Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Power BI Unit 1: Overview Power BI Components Install Power BI Desktop (free software) Getting started Unit 2: Connect with Data Sources Types of data sources Import Excel and text files Connect to databases (Access) Import data from the Web Unit 3: Transform Data Introduction to Power Query Shape data Filter data Understand the Data Model Unit 4: Creating Reports Overview Create visuals Format reports Share your files Intermediate Power BI Unit 1: Power Query Review the ETL Process Insert columns using different methods Group, Summarize, Pivot, and UnPivot data Merge and Append queries Unit 2: Data Modeling What Data Modeling is Modeling Options Create and manage relationships Create Date table Unit 3: DAX Introduction to DAX Calculate columns and measures Time Intelligence functions Quick Measures Unit 4: Reports Filters versus Slicers Visual Hierarchies and Drill downs Drillthrough Define visual interactions Apply conditional formatting Advanced Power BI Unit 1: Power Query Utilize Column profile, distribution, and quality Perform fuzzy match Duplicate versus Reference queries Debug errors Unit 2: Data Modeling What a Star Schema is Understand relationship types Manage relationships Unit 3: DAX Understand contexts CALCULATE function COALESCE function Compute visual totals accurately Unit 4: Reports Insert Objects Create Bookmarks

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 8 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 Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to SQL Unit 1: The Relational Database and Structured Query Language The relational database structure Structured Query Language Table creation and data insertion Defining datatypes and constraints Creating Indexes Unit 2: Table Management Table management Adding columns to a table Deleting columns from a table Deleting a table Unit 3: Selecting and Retrieving Data Creating a SELECT statement to retrieve data Using DISTINCT to display unique values in a column Using the AS keyword to create an alternate name for a column Merging columns Unit 4: Filtering Data Creating a WHERE clause Using comparison, character, and logical operators to match conditions Using the IN operator to match a condition Using the BETWEEN operator to match a condition Intermediate SQL Unit 1: The Relational Database and Structured Query Language The relational database structure Structured Query Language Table creation and data insertion Defining datatypes and constraints Creating Indexes Unit 2: Table Management Table management Adding columns to a table Deleting columns from a table Deleting a table Unit 3: Selecting and Retrieving Data Creating a SELECT statement to retrieve data Using DISTINCT to display unique values in a column Using the AS keyword to create an alternate name for a column Merging columns Unit 4: Filtering Data Creating a WHERE clause Using comparison, character, and logical operators to match conditions Using the IN operator to match a condition Using the BETWEEN operator to match a condition Advanced SQL Unit 1: Creating Advanced Subqueries Structured Query Language Review Using the IN keyword to link queries Using the EXISTS keyword to link queries Using the ANY keyword to link queries Using the ALL keyword to link queries Unit 2: Creating Advanced Joins Creating inner joins review Creating outer joins review Creating joins with aggregate functions Creating nested joins Unit 3: Creating Union Queries Creating UNION queries Creating UNION ALL queries Creating a WHERE clause and multiple UNION queries Unit 4: Transaction Processing, Stored Procedures, Triggers Implementing transaction processing Implementing stored procedures Implementing triggers

WordPress is the most popular content management system (CMS) for website and blog design.During the first week, you will learn or refresh your knowledge of all the initial steps and the required elements for having a website. Then find out how to build a simple WordPress website or blog. Topics include an introduction to CMS, WordPress installation and setup, page and content creation, administration, themes (selection, purchase, installation, and setup), working with widgets and plugins, and more. Finally, acquire advanced knowledge about WordPress options and features. You will learn how to modify WordPress web pages by hand-coding, learn about simple yet effective search engine optimization (SEO) techniques that improve your website ranking, and much more. After successfully completing the WordPress Certificate you will know how to build a WordPress website or blog, customize your WordPress site by hand-coding HTML, CSS, and PHP, know necessary regular WordPress maintenance, create WordPress website backup, and know how to apply SEO techniques in WordPress. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: Website Setup All the initial steps and the required elements for having a website, including the process of registering a domain name, signing up for a host company, pointing your domain to the host and getting ready for website design in WordPress. Unit 2: WordPress Fundamentals After successfully completing this course, you will know how to build a simple WordPress website or blog. Topics include an introduction to CMS, WordPress installation and setup, page and content creation, administration, themes (selection, purchase, installation, and setup), working widgets and plugins, and more. Unit 3: Advanced WordPress Now that you have learned how to set up a WordPress website, it's time to learn advanced options and features of WordPress. You will learn how to modify WordPress web pages by hand-coding. You'll also learn about simple yet effective SEO techniques that improve your website ranking. We will also cover very important on-going site maintenance and site security.