Business Analyst Certificate

In this beginner Excel course, you will learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

• Become familiar with the interface and data entry
• Learn essential formulas and functions
• Format and print your work
• Create charts, including line, column, and pie charts
• Learn tips and tricks for easy workbook management
• Review key concepts in a final project

Learn intermediate Excel functions like VLOOKUP and SUMIFs, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.

• Learn to split and join text, add data validation, and named ranges
• Use database functions such as VLOOKUP & HLOOKUP
• Add logical statements, including AND, OR, and IF statements
• Create Pivot Tables to quickly summarize large databases
• Use statistcal functions such as Ranking, COUNTIFS, and SUMIFS
• Create advanced combo charts from multiple charts
• Review key concepts by creating a final project

Learn all of the most complex features of Microsoft Excel in this advanced training course - Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.

• Cell management including cell locking, auditing, and hot keys
• Special formatting for calculating dates
• Use advanced functions such as nested IF statements
• Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
• Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
• Record macros and relative reference macros for ad hoc reporting
• Create a project that applies key concepts from the class

This beginner-friendly PowerPoint course covers the core skills needed to create engaging and professional presentations. From building slides to working with images, charts, and transitions, you'll learn how to design visually compelling presentations and deliver them with confidence.

• Build new presentations from templates and customize layouts, themes, and content structure
• Add and edit text, bullets, and numbered lists using Outline View and other formatting tools
• Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment tools
• Create and format tables, add connector lines, and import charts from Excel to display data
• Apply transitions, manage presenter notes, and use presentation tools for live or virtual delivery
• Save, print, and export presentations to PDF, with options tailored for professional use

This advanced PowerPoint course is designed for users ready to take their presentation skills to the next level. Learn how to build professional themes, streamline design with Slide Master, and enhance visual storytelling through animation, video, and advanced chart customization.

• Create and manage Slide Master layouts to maintain consistent branding across entire presentations
• Design custom PowerPoint themes, including personalized color palettes, fonts, and reusable backgrounds
• Animate bullet points, charts, and objects using entrance, emphasis, and exit effects, plus explore the Morph transition
• Integrate video, hyperlinks, and dynamic charts and tables imported from Excel for interactive presentations
• Customize presentation workflows with hidden slides, custom shows, sections, and the Quick Access Toolbar
• Collaborate and finalize projects with built-in commenting tools, PDF export options, and optimized printing settings

This beginner Tableau course introduces the core concepts of data visualization and gives students the hands-on experience needed to create impactful charts, dashboards, and stories using Tableau Public. Learn to connect, clean, and transform your data into visuals that drive insights and decision-making.

• Understand the types, formats, and sources of data and how to connect them to Tableau
• Create foundational visualizations such as bar charts, line graphs, and treemaps using the “Show Me” panel
• Use built-in functions and custom calculations to analyze and manipulate your data within visualizations
• Clean and organize raw data using tools like the Data Interpreter, pivoting features, and filters
• Build interactive dashboards and stories that combine multiple views for dynamic storytelling
• Format and publish your visualizations to Tableau Online or export them for sharing and presentation

This advanced Tableau course is designed for users ready to elevate their data visualization skills with custom charts, interactive dashboards, and powerful geographic mapping tools. Learn to work with complex datasets and tailor your visualizations for deeper insights and dynamic storytelling.

• Format geographic data and build a variety of interactive map types, including heat maps, spider maps, and choropleth maps
• Integrate custom visuals using background images, polygon data, and Mapbox maps for enhanced design and functionality
• Create advanced charts such as dual-axis (layered) maps, alluvial diagrams, ranking visuals, and circular area charts
• Add interactivity to dashboards through sheet swapping, filtering actions, and dynamic content controls
• Track and display time-based data trends spatially using map animations and proportional symbols
• Prepare and publish high-quality map visualizations for presentation, sharing, and Tableau Online distribution

This beginner-level SQL course introduces the foundational concepts of structured query language and relational databases. Through hands-on exercises and the use of SQL Server Management Studio, you'll learn how to write, filter, and structure queries to extract meaningful insights from data.

• Understand core database concepts, including tables, rows, columns, and different types of SQL
• Connect to databases and navigate SQL Server Management Studio using tools like Object Explorer and Query Editor
• Write SELECT statements to retrieve data, specify columns, sort results, and eliminate duplicates
• Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
• Explore data types, comparison operators, and case sensitivity to refine queries with greater control
• Learn how to join tables using INNER JOIN and understand relational database concepts with ER diagrams and table aliases

This intermediate SQL course expands your ability to analyze and manipulate data through advanced querying techniques. Learn to work with joins, data types, aggregate functions, and date/time operations to uncover deeper insights and organize complex datasets.

• Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
• Identify and work with NULL values to ensure complete and accurate data analysis
• Use the CAST function to convert data types and make your queries more flexible 
• Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
• Apply date functions to extract, format, and compare dates for time-based analysis
• Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation