Skip to main content

Business Analyst Certificate (NYC or Online)

via Noble Desktop No rating
Book live on Noble Desktop
Difficulty
Beginner
Format
Live or Self-paced

Choose how you learn

Compare formats, then explore the details for your choice.

Book directly on nobledesktop.com. Opens in a new tab.

Book live on Noble Desktop

Summary

Browse related programs, including the Data Analytics Certificate, Excel Bootcamp, and Tableau Bootcamp.

Build the foundational skills required for a successful career in business analysis. This certificate program focuses on practical training in Excel, SQL, Python, and Tableau to equip you with the tools and techniques to interpret data and communicate insights.

  • Data Management in Excel: Start with the essentials and progress to advanced Excel techniques. Learn how to work with functions, formulas, Pivot Tables, and macros to manage large datasets and support decision-making.
  • Querying with SQL: Learn to extract, filter, and manipulate data using SQL. Write queries, use joins, apply aggregates, and manage large datasets with PostgreSQL to generate clear and reliable insights.
  • Analyzing Data with Python: Build a solid foundation in Python programming and data analysis. Clean and structure datasets with Pandas and create visualizations with Matplotlib as you prepare for advanced analytical work.
  • Visualizing Insights with Tableau: Turn data into compelling visual stories with Tableau. Create interactive dashboards and a wide range of visualizations to clearly communicate your findings to diverse audiences.
  • Bonus Elective Courses: Strengthen your understanding of business concepts and communication tools through supplemental training in financial accounting, PowerPoint, and Google Ads.
Explore format options

Curriculum

What you'll learn

  • Organize, clean, and analyze large datasets using Excel functions, formulas, Pivot Tables, and macros
  • Write SQL queries to retrieve, filter, group, and join data from relational databases
  • Use Python with libraries like Pandas and Matplotlib to manipulate data and create visualizations
  • Build interactive dashboards and compelling data visualizations in Tableau for diverse audiences
  • Apply statistical and analytical techniques to uncover insights and support data-driven decisions
  • Translate complex data into clear presentations that inform business strategies and solutions

Course outline

  1. Excel Level I: Fundamentals 6 hours

    Join us for a beginner Excel workshop where you'll 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.

    • Get comfortable with the Excel interface and learn multiple ways to enter and organize data in a worksheet.
    • Work with rows, columns, and worksheets by inserting, deleting, hiding, grouping, and managing spreadsheet elements.
    • Build foundational Excel skills with Autofill, basic calculations, AutoSum, and essential functions such as SUM, AVERAGE, MAX, MIN, and COUNT.
    • Use formulas more effectively with absolute references, logical true/false tests, text functions, and multi-input functions.
    • Format spreadsheets for clarity with cell formatting and conditional formatting that highlights data based on specific rules.
    • Create visual reports with column charts, line charts, pie charts, sparklines, and Excel Tables.
    • Manage workbooks more efficiently using Freeze Panes, printing tools, display options, templates, and essential keyboard shortcuts and Excel tips.
    • Reinforce key concepts through end-of-class projects designed to review what you learned.
  2. Excel Level II: Intermediate 6 hours

    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.

    • Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells.
    • Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand.
    • Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations.
    • Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data.
    • Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet.
    • Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results.
    • Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project.
  3. Excel Level III: Advanced 6 hours

    Learn advanced 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.

    • Use advanced navigation tools, Autofill techniques, Hot Keys, and Go To Special to move through worksheets and work more efficiently.
    • Build stronger formulas with mixed references, cell auditing tools, date functions, and custom number formats.
    • Create advanced logic with nested IF statements and IF formulas that incorporate AND/OR criteria for more flexible results.
    • Perform What-If Analysis with Goal Seek and Data Tables to test variables and evaluate possible outcomes.
    • Analyze data with advanced PivotTable tools, including base fields and sets, calculated fields, and Pivot Charts.
    • Use XMATCH, INDEX-MATCH, macros, and dynamic arrays to create powerful lookups, automate tasks, and complete an end-of-class project reviewing key concepts.
  4. SQL Bootcamp 18 hours

    Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.

    • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver, a popular free database app.
    • Write SQL queries to retrieve data from tables in the database
    • Combine information from multiple tables using JOIN statements
    • Filter data, group it, and sort it to extract the specific information you need
    • Master advanced techniques, including subqueries, string functions, and IF‑Else logic with CASE
    • Learn how to use views and functions with parameters instead of directly querying tables
  5. Python for Data Science Bootcamp 30 hours

    Unlock the power of Python for data-driven decision-making as you master Python programming fundamentals and dive into data analysis. Acquire essential skills to clean and manipulate data, create insightful visualizations, and perform statistical analysis, all through hands-on projects with real-world datasets.

    • Learn Python fundamentals, including variables, data types, functions, loops, and control flow, for building robust programs
    • Work with complex data structures such as dictionaries and lists to efficiently organize and access data
    • Use NumPy and Pandas to import, clean, and manipulate datasets for analysis and exploration
    • Generate descriptive statistics and apply filtering, grouping, and pivoting techniques to gain deeper insights
    • Visualize data using Matplotlib and create clear, customized charts, including bar graphs, histograms, and scatter plots
    • Gain the practical skills needed to transition into machine learning with a solid understanding of data science workflows
  6. Tableau Bootcamp 12 hours

    Learn how to use Tableau, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. This course will teach you how to connect to datasets, analyze and structure data, customize visualizations, and publish your work.

    • Connect to datasets in various formats and clean, filter, and structure the data for visual storytelling
    • Create a variety of visualizations, including bar charts, line charts, treemaps, heat maps, and dual-axis charts
    • Use Tableau's calculation tools to build custom fields, apply aggregates, and enhance data analysis
    • Format charts with labels, tooltips, colors, and axes to improve clarity and visual impact
    • Work with geographic data to build interactive map visualizations, including choropleths and proportional-symbol maps
    • Customize dashboards and stories for different audiences and devices using Tableau's interactivity tools
    • Integrate external map services and use advanced visualization types such as spider maps and alluvial diagrams
    • Publish your work to Tableau Cloud and export dashboards for professional sharing and collaboration
  7. Financial Accounting Bootcamp 12 hours

    Learn key skills and concepts for financial accounting in this beginner-friendly course, from the basics of accounting statements to complex topics like investments and securities.

    • Work with financial accounting fundamentals like GAAP and accrual accounting.
    • Write and maintain income statement line items, balance sheets, and cash flow statements.
    • Tie different kinds of financial statements together to prepare for complex accounting tasks.
    • Handle advanced accounting statements, unusual items, and intercompany investments.
    • Understand the basics of debt accounting, deferred taxes, and tax journal entries.
  8. PowerPoint Level I 6 hours

    Learn the essentials of PowerPoint in this introductory course. Create dynamic presentations, add text, images, shapes, transitions, and more. Suitable for beginners or those looking to enhance their skills. Become a more effective PowerPoint user.

    • Build new presentations from templates and customize layouts, themes, and content structure
    • Add and edit text, bullets, and numbered lists using Outline View and various formatting tools
    • Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
    • 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
  9. PowerPoint Level II 6 hours

    In this advanced PowerPoint class, you’ll learn how to create reusable PowerPoint themes and templates to control the design of entire presentations using Slide Master. Add excitement to your presentations with animations, gain greater control over charts and tables, and much more.

    • Create and manage Slide Master layouts to ensure 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, and 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
  10. Google Ads Bootcamp 12 hours

    Learn how to develop and manage successful Google Ads campaigns, generate leads and sales, track conversions, and improve your search engine ranking with this comprehensive workshop. Perfect for anyone looking to expand their brand awareness through effective paid advertising techniques.

    • Introduction to Google Ads
    • How to set up and manage a Google Ads account
    • Keyword strategies
    • How to use match types to control who sees your ads
    • Bidding strategies
    • How the Google Ads auction works
    • How to create ads that convert
    • Landing page best practices
    • How to set up call and conversion tracking
    • Navigating the Google Ads interface
    • Optimizing your campaign for maximum results
    • Remarketing for Search and Display
    • Campaign automation
    • Display advertising with Google Ads

What's included

  • Free course retake within one year to refresh the material and gain practice.
  • 6 one-on-one mentoring sessions
  • Class recordings

Stated by the provider. Confirm what your tuition covers before enrolling.

Live classes

Choose dates and book your instructor-led class on nobledesktop.com.

Book live on Noble Desktop
  • In-person or live online

    Sun

    10:00–17:00 · America/New_York (EDT/EST)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EDT/EST)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EST)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EST/EDT)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EDT)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EDT)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EDT)

  • In-person or live online

    Tue, Wed, Thu, Fri, Mon

    10:00–17:00 · America/New_York (EDT)

  • In-person or live online

    Tue, Wed, Thu, Mon, Fri

    10:00–17:00 · America/New_York (EST)

Confirm current dates and availability on Noble Desktop before booking.

Self-paced course

Learn through recorded lessons on your own schedule.

This program is available for 300 days. You can choose when to start your access period. Once you activate, you will have 300 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.

Book self-paced on Noble Desktop
Tuition
$2,995
Course length
63 hours
Schedule
On your schedule

This self-paced certificate program equips you with practical skills in Excel, SQL, Python, and Tableau to analyze data and communicate insights effectively. Start with data management in Excel, mastering everything from basic functions and formulas to advanced techniques like Pivot Tables and macros for managing large datasets. You'll then move on to SQL, learning how to query, manipulate data, and use PostgreSQL to generate clear, reliable insights.

The program also covers Python for data analysis, focusing on cleaning and structuring datasets with Pandas, and creating visualizations with Matplotlib. You'll then dive into Tableau, learning to design interactive dashboards and compelling visual stories. To complement the core training, you can also explore elective courses in financial accounting, PowerPoint, and Google Ads, enhancing your business knowledge and skills.

Self-paced curriculum

What you'll learn self-paced

  • Organize, clean, and analyze large datasets using Excel functions, formulas, Pivot Tables, and macros.
  • Write SQL queries to retrieve, filter, group, and join data from relational databases.
  • Use Python with libraries like Pandas and Matplotlib to manipulate data and create visualizations.
  • Build interactive dashboards and engaging visualizations in Tableau for various audiences.
  • Apply statistical and analytical techniques to uncover insights and drive data-driven decisions.
  • Present complex data in clear, concise formats that support business strategies and solutions.

Self-paced course outline

  1. Excel Level I: Fundamentals Course Online (Self-Paced) 6 hours

    Join us for a beginner Excel workshop where you'll 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
  2. Excel Level II: Intermediate Course Online (Self-Paced) 6 hours

    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, apply data validation, and create named ranges
    • Use database functions such as VLOOKUP and HLOOKUP
    • Write logical formulas using AND, OR, and IF functions
    • Create Pivot Tables to efficiently summarize and analyze large datasets
    • Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
    • Build advanced combo charts by combining multiple chart types
    • Reinforce key concepts through a guided final project
  3. Excel Level III: Advanced Course Online (Self-Paced) 6 hours

    Learn advanced 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
  4. SQL Course Online (Self-Paced) 18 hours

    Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.

    • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app)
    • Write SQL queries to retrieve data from tables in a database
    • Combine information from multiple tables with JOIN statements
    • Filter data, group it, and sort it to extract the specific info you need
    • Learn advanced techniques like subqueries, string functions, and IF‑ELSE logic with CASE
    • Learn how to use views and functions with parameters instead of directly querying tables
  5. Python for Data Science Course Online (Self-Paced) 30 hours

    Unlock the power of Python for data-driven decision-making as you master Python programming fundamentals and dive into data analysis. Acquire essential skills to clean and manipulate data, create insightful visualizations, and perform statistical analysis, all through hands-on projects with real-world datasets.

    • Foundational programming concepts, including loops, functions, and objects
    • Handle different types of data such as integers, floats, and strings
    • Control the flow of your programs with conditional statements
    • Reuse and simplify code with object-oriented programming
    • Analyze tabular data with NumPy and Pandas
    • Create graphs and visualizations with Matplotlib
    • Make predictions with linear regression, using scikit-learn
  6. Tableau Course Online (Self-Paced) 12 hours

    Learn how to use Tableau, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. This course will teach you how to connect to datasets, analyze and structure data, customize visualizations, and publish your work.

    • Connect to datasets in various formats, then clean, filter, and structure the data for effective visual storytelling
    • Create a range of visualizations, including bar charts, line charts, treemaps, heat maps, and dual-axis charts
    • Use Tableau’s calculation tools to create custom fields, apply aggregates, and deepen your data analysis
    • Format charts using labels, tooltips, color, and axis adjustments to improve clarity and impact
    • Work with geographic data to create interactive map visualizations such as choropleths and proportional symbol maps
    • Customize dashboards and stories for various audiences and screen sizes using Tableau’s interactivity tools
    • Integrate external mapping services and explore advanced visualization types like spider maps and alluvial diagrams
    • Publish your work to Tableau Cloud and export dashboards for professional sharing and team collaboration
  7. Financial Accounting Bootcamp (Self-Paced) 12 hours

    Master essential financial accounting skills in this beginner-friendly course, covering everything from basic accounting statements to advanced topics like investments and securities.

    • Master financial accounting fundamentals, including GAAP and accrual accounting.
    • Create and manage income statement line items, balance sheets, and cash flow statements.
    • Connect various financial statements to tackle complex accounting tasks.
    • Handle advanced accounting statements, unusual items, and intercompany investments.
    • Learn the basics of debt accounting, deferred taxes, and tax journal entries.
  8. PowerPoint Level I (Self-Paced) 6 hours

    Explore PowerPoint fundamentals through this self-paced course. Build engaging presentations by adding text, graphics, shapes, and transitions, and enhance your skills as an effective presenter. Perfect for beginners or those refreshing their knowledge.

    • Create presentations from templates and customize layouts, themes, and content structure
    • Edit text, bullets, and numbered lists using Outline View and formatting tools
    • Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
    • Create and format tables, add connector lines, and import Excel charts to display data
    • Apply transitions, manage presenter notes, and utilize tools for live or virtual presentations
    • Save, print, and export presentations to PDF, with professional-use options
  9. PowerPoint Level II (Self-Paced) 6 hours

    Explore the fundamentals of PowerPoint at your own pace in this introductory course. Learn to build dynamic presentations with text, images, shapes, transitions, and more. Ideal for beginners or those looking to enhance their presentation skills and efficiency.

    • Create presentations from templates and customize layouts, themes, and content structure
    • Edit text, bullets, and numbered lists with Outline View and advanced formatting tools
    • Insert and enhance images, SmartArt, and shapes using effects, cropping, and alignment options
    • Format tables, add connector lines, and import Excel charts to display data
    • Apply transitions, manage presenter notes, and use tools for live or virtual presentations
    • Save, print, and export presentations to PDF with professional-use options
  10. Google Ads Bootcamp (Self-Paced) 12 hours

    Learn how to develop and manage successful Google Ads campaigns, generate leads and sales, track conversions, and improve your search engine ranking with this comprehensive workshop. Perfect for anyone looking to expand their brand awareness through paid advertising techniques.

    • How to set up and manage a Google Ads account
    • Keyword strategy, match types, and bidding tactics
    • How the Google Ads auction works
    • Creating high-converting ads and landing pages
    • Call and conversion tracking setup
    • Navigating and optimizing campaigns in Google Ads
    • Remarketing for Search and Display
    • Campaign automation and Display advertising

What's included with self-paced

  • Self-paced video lessons

Self-paced lessons

Watch free previews and explore the lessons included with enrollment at Noble Desktop.

Excel Level I: Fundamentals Course Online (Self-Paced)

  • Interface

    Lesson 1: Introduction

    8:26

    Explore the Microsoft Excel user interface, including the Quick Access Toolbar, Ribbon tabs and groups, Review tab features, Insert Function button, Zoom slider, Sheet Selector buttons, and the expansive rows and columns.

  • Enrollment required

    Rows and Columns

    Lesson 1: Introduction

    6:02

    Insert, delete, hide, and group rows and columns using ribbon commands, right-click menus, keyboard shortcuts, and grouping buttons.

    View enrollment options at Noble Desktop
  • Autofill

    Lesson 2: Formulas

    9:07

    Use Excel's autofill and flash fill features to efficiently complete patterns and replicate data across cells.

  • Enrollment required

    Data Entry

    Lesson 2: Formulas

    5:13

    Learn techniques for efficient data entry, editing, copying, pasting, and cutting in spreadsheets.

    View enrollment options at Noble Desktop
  • Enrollment required

    Calculations

    Lesson 2: Formulas

    10:16

    Learn to perform basic calculations in Excel using formulas, cell references, and functions like AVERAGE while considering the order of operations (PEMDAS).

    View enrollment options at Noble Desktop
  • Enrollment required

    Autosum Functions

    Lesson 2: Formulas

    9:58

    Use Excel's AutoSum functions to quickly calculate Sum, Average, Max, Min, and Count in tables.

    View enrollment options at Noble Desktop
  • Enrollment required

    Text Functions

    Lesson 2: Formulas

    8:04

    Use text functions like PROPER, UPPER, LOWER, and TRIM in Excel to efficiently adjust text casing and remove extra spaces.

    View enrollment options at Noble Desktop
  • Enrollment required

    True False

    Lesson 2: Formulas

    7:14

    Verify statements in Excel as true or false using comparison operators.

    View enrollment options at Noble Desktop
  • Enrollment required

    Absolute Cell References

    Lesson 2: Formulas

    10:07

    Utilize absolute cell references in Excel formulas to fix a specific cell while autofilling calculations, preventing unwanted shifts in cell references.

    View enrollment options at Noble Desktop
  • Enrollment required

    Multi Input Functions

    Lesson 2: Formulas

    12:37

    Learn to use multi-input Excel functions like LEFT, RIGHT, SUMPRODUCT, and ROUND for extracting data, calculating totals, and managing rounding errors efficiently.

    View enrollment options at Noble Desktop
  • Enrollment required

    Formatting

    Lesson 3: Formatting

    14:04

    Explore various Excel formatting tools to enhance cell appearance, including changing colors, fonts, alignment, number formats, and merging cells.

    View enrollment options at Noble Desktop
  • Enrollment required

    Conditional Formatting

    Lesson 3: Formatting

    9:30

    Use conditional formatting to visually highlight and differentiate data based on set criteria within Excel.

    View enrollment options at Noble Desktop
  • Line Chart

    Lesson 4: Charts & Tables

    5:34

    Create a basic line chart in Excel by selecting a single cell in your data, using the insert tab to choose a line chart, and customizing it with quick layout, color, and style options.

  • Enrollment required

    Column Chart

    Lesson 4: Charts & Tables

    7:53

    Create a column chart by selecting data, inserting it from the Insert tab, and customizing elements like axis titles, data labels, and grid lines through the Chart Design tab.

    View enrollment options at Noble Desktop
  • Enrollment required

    Trendlines

    Lesson 4: Charts & Tables

    3:05

    Apply trend lines to charts by selecting the desired type (linear, exponential, linear forecast, or moving average) in the chart design options.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pie Chart

    Lesson 4: Charts & Tables

    7:27

    Create and customize pie charts by selecting data, converting between 2D, 3D, and donut styles, and isolating specific slices for emphasis.

    View enrollment options at Noble Desktop
  • Enrollment required

    Tables

    Lesson 4: Charts & Tables

    13:52

    Learn to create and use Excel tables for efficient data management and analysis.

    View enrollment options at Noble Desktop
  • Printing

    Lesson 5: Workbook Management

    10:00

    Explore and adjust printing options in Excel by utilizing the Page Layout tab to control margins, orientation, print area, page breaks, print titles, scale to fit, and gridlines, while adding headers and footers through the Insert tab for enhanced page setup and layout management.

  • Enrollment required

    Worksheets

    Lesson 5: Workbook Management

    7:04

    Manage Excel worksheets by inserting, deleting, hiding, moving, copying, and renaming them using right-click options or the ribbon menu.

    View enrollment options at Noble Desktop
  • Enrollment required

    Freeze Panes

    Lesson 5: Workbook Management

    5:03

    Freeze panes by selecting the desired row or column below or to the right of where you want the freeze, then choose "Freeze Panes" from the View tab.

    View enrollment options at Noble Desktop
  • Enrollment required

    Excel Tricks

    Lesson 5: Workbook Management

    9:14

    Explore Excel tricks like repeating commands with F4, applying multiple formats using Format Painter, inserting comments and links, and capturing screenshots directly into your spreadsheet.

    View enrollment options at Noble Desktop

Excel Level II: Intermediate Course Online (Self-Paced)

  • Enrollment required

    Tips and Fundamentals

    Lesson 5: Workbook Management

    10:24

    Review and apply Excel's autosum functions and formula auditing tools to calculate totals, averages, and high scores, detect and fix errors, and ensure correct formula dependencies.

    View enrollment options at Noble Desktop
  • Navigation

    Lesson 1: Worksheet Management

    6:58

    Navigate and select cells in a spreadsheet using keyboard shortcuts like arrow keys, control, shift, and page up/down for efficient data management.

  • Enrollment required

    Paste Special

    Lesson 2: Working with Text

    8:55

    Use paste special in Excel to apply formats, perform calculations, and change data orientation.

    View enrollment options at Noble Desktop
  • Enrollment required

    Paste Special Values

    Lesson 2: Working with Text

    3:14

    Use "paste special values" to copy and paste only the results of formulas as text without including the formulas themselves.

    View enrollment options at Noble Desktop
  • Enrollment required

    Splitting Text

    Lesson 2: Working with Text

    5:08

    Use text-to-columns to split data in a spreadsheet into separate columns based on delimiters like commas or spaces.

    View enrollment options at Noble Desktop
  • Enrollment required

    Joining Text

    Lesson 2: Working with Text

    5:06

    Join text using either the concatenate function or the ampersand method to combine cells with specified separators like spaces or dashes.

    View enrollment options at Noble Desktop
  • Enrollment required

    Named Ranges

    Lesson 3: Cell Ranges

    3:56

    Create named ranges for assets, liabilities, and equity to simplify referencing them in calculations.

    View enrollment options at Noble Desktop
  • Data Validation

    Lesson 4: Database Functions

    7:35

    Use data validation in Excel to create drop-down lists that restrict cell input to specified numerical or text values, with options to customize error alerts and input messages.

  • Enrollment required

    Remove Duplicates

    Lesson 4: Database Functions

    3:51

    Remove duplicates by selecting a cell in the data, going to the Data tab, clicking Remove Duplicates, and confirming the selection.

    View enrollment options at Noble Desktop
  • Enrollment required

    VLOOKUP

    Lesson 4: Database Functions

    10:06

    Use VLOOKUP to find information in a table by specifying a lookup value, table array, column index number, and choose between exact or approximate match.

    View enrollment options at Noble Desktop
  • Enrollment required

    HLOOKUP

    Lesson 4: Database Functions

    2:58

    Use HLOOKUP to find a lookup value horizontally in a row by selecting the row index number instead of the column index number.

    View enrollment options at Noble Desktop
  • Enrollment required

    Sort and Filter

    Lesson 4: Database Functions

    15:53

    Sort and filter data using Excel's home or data tab, create subtotals for grouped data, and practice these skills through specific tasks like multi-level sorting, filtering, and applying subtotals.

    View enrollment options at Noble Desktop
  • Pivot Tables New

    Lesson 5: Pivot Tables

    10:00

    Create a basic pivot table by converting your data into an Excel table, then use the pivot table options to summarize and filter the data, remembering to refresh for updates.

  • Enrollment required

    Pivot Grouping Timelines

    Lesson 5: Pivot Tables

    5:16

    Group and filter pivot table data by time periods using the group and insert timeline features.

    View enrollment options at Noble Desktop
  • Enrollment required

    Multiple Pivot Tables

    Lesson 5: Pivot Tables

    11:40

    Explore pivot tables by inserting fields multiple times, using value field settings for different calculations, employing slicers for easy filtering, and connecting slicers to multiple pivot tables for synchronized filtering.

    View enrollment options at Noble Desktop
  • If Statements

    Lesson 6: Logical Functions

    8:30

    Explain how to use if statements and if error functions in Excel for logical testing and error handling.

  • Enrollment required

    And Or

    Lesson 6: Logical Functions

    6:17

    Use AND to ensure all criteria are true and OR to check if at least one criterion is true when evaluating conditions.

    View enrollment options at Noble Desktop
  • COUNTIFS and SUMIFS

    Lesson 7: Statistical Functions

    9:46

    Count and sum data based on conditions using COUNTIFS and SUMIFS functions in Excel, which act as filters for specified criteria across multiple columns.

  • Enrollment required

    Combo Charts

    Lesson 8: Advanced Charts

    5:01

    Create a combo chart with a secondary axis for better comparison, and format it by adjusting bar colors, background, border, and adding effects.

    View enrollment options at Noble Desktop

Excel Level III: Advanced Course Online (Self-Paced)

  • Advanced Cell Lock

    Lesson 1: Cell Management

    10:00

    Lock cells in Excel by using mixed referencing to maintain specific row or column values when autofilling formulas.

  • Enrollment required

    Hot Keys

    Lesson 1: Cell Management

    7:14

    Utilize the Alt key on a PC to access Excel's ribbon commands and create custom keyboard shortcuts for efficient navigation and task execution.

    View enrollment options at Noble Desktop
  • Enrollment required

    Go To Special

    Lesson 1: Cell Management

    8:51

    Use "Go To Special" in Excel to quickly select specific cell types, such as constants, blanks, or visible cells, for efficient data management and editing.

    View enrollment options at Noble Desktop
  • Date Functions

    Lesson 2: Special Formatting

    7:29

    Calculate future dates, days between dates, workdays, week numbers, and month ends using Excel's DAYS, NETWORKDAYS, WEEKNUM, EOMONTH, and EDATE functions.

  • Enrollment required

    Adv Conditional Formatting

    Lesson 2: Special Formatting

    9:35

    Apply advanced conditional formatting using formulas to format cells based on criteria in different columns.

    View enrollment options at Noble Desktop
  • Enrollment required

    Nested IFs

    Lesson 2: Special Formatting

    9:37

    Nest multiple if statements to evaluate more conditions and provide different responses based on the evaluated criteria.

    View enrollment options at Noble Desktop
  • If AND OR

    Lesson 3: Advanced Functions

    7:43

    Combine the IF statement with AND or OR functions to evaluate multiple conditions and return specific results based on whether those conditions are true or false.

  • Enrollment required

    Goal Seek

    Lesson 4: What If Analysis

    4:18

    Use Goal Seek in Excel to determine the required growth rate or exam score needed to reach a specific target value by adjusting a related variable.

    View enrollment options at Noble Desktop
  • Enrollment required

    Data Tables

    Lesson 4: What If Analysis

    7:32

    Create data tables in Excel to analyze the impact of different variables on a formula.

    View enrollment options at Noble Desktop
  • Conditional Sumproduct

    Lesson 5: Advanced Analytical Tools

    9:48

    Use conditional sum product to calculate totals or averages by applying criteria to filter specific data subsets.

  • Enrollment required

    Pivot Table Variances

    Lesson 5: Advanced Analytical Tools

    6:17

    Create a pivot table, group data by quarters and years, and use "difference from" and "percentage difference from" calculations to show variances between years.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pivot Calculations

    Lesson 5: Advanced Analytical Tools

    10:22

    Perform calculations within pivot tables using calculated fields and items for efficient data analysis.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pivot Charts

    Lesson 5: Advanced Analytical Tools

    6:05

    Create dynamic graphical representations of pivot table data using pivot charts in Excel.

    View enrollment options at Noble Desktop
  • Match Function

    Lesson 6: Advanced Database Functions

    4:25

    Find the relative position of a lookup value within a single column or row using the match function.

  • Enrollment required

    Vlookup Match

    Lesson 6: Advanced Database Functions

    8:08

    Enhance VLOOKUP accuracy by using the MATCH function to dynamically determine the column index number, allowing for more efficient data retrieval with mixed referencing.

    View enrollment options at Noble Desktop
  • Enrollment required

    Index Match

    Lesson 6: Advanced Database Functions

    7:02

    Combine INDEX and MATCH functions to efficiently locate a value in a row or column, allowing lookups in either direction.

    View enrollment options at Noble Desktop
  • Enrollment required

    Index Double Match

    Lesson 6: Advanced Database Functions

    7:07

    Utilize the Index Double Match function to perform a two-way lookup by identifying both row and column positions for retrieving specific data from a table.

    View enrollment options at Noble Desktop
  • Enrollment required

    Windows

    Lesson 6: Advanced Database Functions

    6:56

    Learn to use keyboard shortcuts and commands in Windows to efficiently navigate and arrange Excel windows for better multitasking.

    View enrollment options at Noble Desktop
  • Enrollment required

    Working Across Sheets

    Lesson 6: Advanced Database Functions

    4:38

    Apply formatting and summarize calculations across multiple sheets by selecting ranges while holding the shift key and using functions like SUM and autofill for common cells.

    View enrollment options at Noble Desktop
  • Macros

    Lesson 7: Introduction to Macros

    8:29

    Automate Excel tasks by creating and running macros using the developer tab, keyboard shortcuts, buttons, and the quick access toolbar to efficiently repeat actions like entering data.

  • Enrollment required

    MacrosReport

    Lesson 7: Introduction to Macros

    6:14

    Create a macro to automate daily report formatting tasks, reducing a two-minute manual process to under a second.

    View enrollment options at Noble Desktop
  • Enrollment required

    Consolidation

    Lesson 8: Dynamic Arrays

    5:10

    Use the consolidate function to sum values across multiple sheets into a summary worksheet and enable automatic updates when source data changes.

    View enrollment options at Noble Desktop

SQL Course Online (Self-Paced)

  • Benefits of Learning SQL

    Lesson 1: Setting Up the Work Environment

    Download the PDF workbook and class files, and install the free dBeaver Community Edition to practice SQL querying without modifying databases.

  • Enrollment required

    Connecting to Our Database

    Lesson 1: Setting Up the Work Environment

    14:06

    Set up a database connection in dBeaver using the provided credentials, test connectivity, and review available tables.

    View enrollment options at Noble Desktop
  • Getting Started & Your First Query

    Lesson 2: Let's Start Learning SQL Code

    7:29

    Navigate databases in dBeaver by adjusting preferences, exploring schemas, and running practice queries to build familiarity.

  • Enrollment required

    Learning the SQL Language

    Lesson 2: Let's Start Learning SQL Code

    14:10

    Review SQL syntax through slides, live demos, and exercises focused on SELECT, FROM, ORDER BY, DISTINCT, execution order, and result limits.

    View enrollment options at Noble Desktop
  • Enrollment required

    Coding Exercise PostgreSQL

    Lesson 2: Let's Start Learning SQL Code

    18:29

    Connect to the correct database environment and complete Exercise 1C by writing and executing SQL queries.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution PostgreSQL Challenge

    Lesson 2: Let's Start Learning SQL Code

    15:11

    Query users and orders tables to view, filter, sort, and remove duplicate records.

    View enrollment options at Noble Desktop
  • Data Types and Filtering Results

    Lesson 3: Working with Characters & Numbers

    4:44

    Differentiate database data types to query text and numeric values correctly, applying quotes and comparison logic appropriately.

  • Enrollment required

    Coding Exercise Filtering with WHERE

    Lesson 3: Working with Characters & Numbers

    5:34

    Define the active data source to enable code hints when querying product data based on price conditions.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Filtering with WHERE

    Lesson 3: Working with Characters & Numbers

    22:42

    Refine queries to filter specific records, sort results, perform calculations, handle data types accurately, and eliminate duplicates.

    View enrollment options at Noble Desktop
  • Pattern Matching

    Lesson 4: Using SQL Wildcards

    4:46

    Apply wildcard characters such as percent signs and underscores with LIKE and ILIKE to identify data patterns.

  • Enrollment required

    Combining Filters and Aliases

    Lesson 4: Using SQL Wildcards

    4:32

    Combine conditions using AND, OR, and NOT, perform calculations, and assign column aliases for clearer result sets.

    View enrollment options at Noble Desktop
  • Enrollment required

    Coding Exercise Like and Wildcards

    Lesson 4: Using SQL Wildcards

    12:31

    Practice filtering records using LIKE, ILIKE, and NOT to control query results precisely.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Like and Wildcards

    Lesson 4: Using SQL Wildcards

    23:49

    Explore table structures and ER diagrams to understand relationships and safely query data such as email domains or state-based orders.

    View enrollment options at Noble Desktop
  • Database Terminology and Primary & Foreign Keys

    Lesson 5: Indentifying Rows & Connecting Tables

    6:44

    Connect related tables by identifying primary and foreign keys to manage relationships and avoid duplication.

  • Enrollment required

    Joins Combining Data from Multiple Tables

    Lesson 5: Indentifying Rows & Connecting Tables

    12:28

    Perform inner joins by matching common columns and using table aliases to simplify query syntax.

    View enrollment options at Noble Desktop
  • Enrollment required

    Exercise Inner Join

    Lesson 5: Indentifying Rows & Connecting Tables

    18:40

    Reinforce inner join logic by combining tables, filtering shared data, and presenting unified results.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Inner Join

    Lesson 5: Indentifying Rows & Connecting Tables

    10:36

    Join users, orders, and line items to identify high-value purchases and return distinct customer details.

    View enrollment options at Noble Desktop
  • Inner vs. Outer Joins

    Lesson 6: Inner vs. Outer Joins

    9:45

    Compare inner joins with left, right, and full outer joins to understand how non-matching rows are handled.

  • Enrollment required

    Exercise Outer Join and NULL

    Lesson 6: Inner vs. Outer Joins

    23:37

    Open the designated file, review warm-up exercises, and complete challenge problems to reinforce learning.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Outer Join and NULL

    Lesson 6: Inner vs. Outer Joins

    34:12

    Analyze database relationships to uncover insights such as unsold products or specific purchasing behaviors, then export results as CSV files.

    View enrollment options at Noble Desktop
  • Cast

    Lesson 7: Changing Data Types

    7:07

    Convert data types within queries using CAST without altering the underlying database structure.

  • Enrollment required

    Aggregate Functions

    Lesson 7: Changing Data Types

    6:33

    Apply aggregate functions to calculate totals, counts, minimums, maximums, and averages for analysis.

    View enrollment options at Noble Desktop
  • Enrollment required

    Exercise Aggregate Function and ROUND

    Lesson 7: Changing Data Types

    27:56

    Manipulate aggregated results using rounding functions and column aliases for readable output.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Aggregate Function and ROUND

    Lesson 7: Changing Data Types

    19:00

    Build aggregate queries incrementally, validating intermediate results before final execution.

    View enrollment options at Noble Desktop
  • Date Functions

    Lesson 8: Working with Dates

    2:20

    Work with date and time functions to retrieve current timestamps, extract components, and convert data types.

  • Enrollment required

    Exercise 2.0 Date Functions

    Lesson 8: Working with Dates

    19:52

    Extract, format, filter, and convert date values using date_part, to_char, CAST, and range-based conditions.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution 2.0 Date Functions

    Lesson 8: Working with Dates

    17:40

    Analyze account creation data to determine user age, creation year, weekend sign-ups, and date-range activity.

    View enrollment options at Noble Desktop
  • Grouping Data

    Lesson 9: Organizing Statistical Results Into Categories

    8:18

    Group records using GROUP BY to apply aggregate functions across defined categories.

  • Enrollment required

    Subqueries

    Lesson 10: Subqueries

    27:41

    Nest subqueries within main queries to process intermediate results before final selection.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Subqueries

    Lesson 10: Subqueries

    24:51

    Prefer joins over subqueries when appropriate to improve clarity and performance.

    View enrollment options at Noble Desktop
  • Enrollment required

    Aggregate Window Functions

    Lesson 11: Aggregate Window Functions

    23:01

    Use window functions to add aggregate insights while preserving row-level detail.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution WIndow Functions

    Lesson 11: Aggregate Window Functions

    9:34

    Apply PARTITION BY within window functions to analyze grouped metrics without collapsing results.

    View enrollment options at Noble Desktop
  • Enrollment required

    Conditionals

    Lesson 12: Conditionals

    18:26

    Create conditional logic with CASE statements to classify, transform, or correct query output.

    View enrollment options at Noble Desktop
  • Enrollment required

    CASE Exercise

    Lesson 12: Conditionals

    14:36

    Categorize data into regions or groups, calculate order counts, and manage joins for broader analysis.

    View enrollment options at Noble Desktop
  • Enrollment required

    Views

    Lesson 13: Views

    18:50

    Save reusable queries as views to simplify access, enhance security, and streamline workflows.

    View enrollment options at Noble Desktop
  • Enrollment required

    Views Solution

    Lesson 13: Views

    0:46

    Summarize and filter user spending patterns using flexible query criteria.

    View enrollment options at Noble Desktop
  • String Functions

    Lesson 14: String Functions

    4:34

    Manipulate text data with string functions to change case, extract substrings, split values, and evaluate length.

  • Enrollment required

    Learning Resources

    Lesson 15: Additional Resources

    3:24

    Reinforce skills through external SQL resources, practice platforms, cheat sheets, and coding challenges.

    View enrollment options at Noble Desktop
  • Enrollment required

    Finding Datasets

    Lesson 15: Additional Resources

    2:04

    Source datasets from Kaggle and convert them into usable databases with guided setup support.

    View enrollment options at Noble Desktop
  • AI and SQL

    Lesson 16: AI and SQL

    11:06

    Use AI tools such as ChatGPT to explain, refine, and generate SQL queries while validating results independently.

  • Enrollment required

    Challenge AI and SQL

    Lesson 16: AI and SQL

    5:13

    Generate SQL queries from database visuals using tools like Chat2BT, specifying structure and dialect requirements.

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution AI and SQL

    Lesson 16: AI and SQL

    14:13

    Apply best practices for using AI-generated SQL by providing clear requirements, verifying accuracy, and learning from explanations.

    View enrollment options at Noble Desktop

Python for Data Science Course Online (Self-Paced)

  • Introduction to Python for Data Science

    Lesson 1: Python for Data Science Fundamentals

    9:06

    Download, unzip, and upload course files to Google Drive, then open and edit copies in Google Colab with AI assistance turned off and line numbers enabled to support hands-on coding practice.

  • Enrollment required

    Variables

    Lesson 1: Python for Data Science Fundamentals

    21:19

    Explain how variables, data types, and string operations function in Python programming.

    View enrollment options at Noble Desktop
  • Enrollment required

    Integer and Decimal

    Lesson 1: Python for Data Science Fundamentals

    20:07

    Differentiate integers and decimals, apply math operators, convert between strings and numeric types, and manage string concatenation in Python.

    View enrollment options at Noble Desktop
  • Enrollment required

    Input Function

    Lesson 1: Python for Data Science Fundamentals

    8:30

    Capture user input with the input function, convert values to integers or floats, apply the correct order of operations, and use modulus to convert total minutes into hours and minutes.

    View enrollment options at Noble Desktop
  • Enrollment required

    Input Function Part 2

    Lesson 1: Python for Data Science Fundamentals

    4:39

    Apply the modulus operator to format movie duration by separating hours from remaining minutes.

    View enrollment options at Noble Desktop
  • Enrollment required

    Round Function

    Lesson 1: Python for Data Science Fundamentals

    6:00

    Process numerical input by converting strings to floats, rounding values, and calculating percentages in practical scenarios such as billing.

    View enrollment options at Noble Desktop
  • Enrollment required

    Cafe Bill Challenge Solution

    Lesson 1: Python for Data Science Fundamentals

    14:12

    Calculate a café bill by collecting food, beverage, and tip inputs, computing subtotals, tax, and tip amounts separately, formatting currency values, and presenting a final total.

    View enrollment options at Noble Desktop
  • Enrollment required

    Boolean

    Lesson 1: Python for Data Science Fundamentals

    5:32

    Explain Boolean values and comparison operators, and how they evaluate conditions as true or false.

    View enrollment options at Noble Desktop
  • Enrollment required

    List Data Type

    Lesson 1: Python for Data Science Fundamentals

    15:52

    Describe how lists work in Python, including creation, indexing, slicing, and accessing nested lists.

    View enrollment options at Noble Desktop
  • Enrollment required

    Methods Functions

    Lesson 1: Python for Data Science Fundamentals

    18:45

    Explain object methods with a focus on list methods such as append, pop, sort, and extend, and distinguish methods from standalone functions.

    View enrollment options at Noble Desktop
  • Enrollment required

    Set & Vector Operation

    Lesson 1: Python for Data Science Fundamentals

    14:37

    Use sets to manage unique values, remove duplicates from lists, and perform basic set and list operations.

    View enrollment options at Noble Desktop
  • If Else Logic

    Lesson 2: Boolean Conditions

    4:43

    Apply if, elif, and else statements with Boolean logic to control program flow based on conditions.

  • Enrollment required

    If Else Logic Challenge Solution

    Lesson 2: Boolean Conditions

    16:35

    Write Python code that uses conditional logic to evaluate prices and manipulate lists using logical operators such as and and or.

    View enrollment options at Noble Desktop
  • Datetime Part 1

    Lesson 3: Datetime & Random

    10:28

    Summarize Python modules and demonstrate importing libraries to extend functionality, including random number generation and timezone handling with datetime and pytz.

  • Enrollment required

    Datetime Part 2

    Lesson 3: Datetime & Random

    11:35

    Convert and format time values into military and AM/PM formats and generate conditional greetings based on the current hour.

    View enrollment options at Noble Desktop
  • Enrollment required

    Random Module

    Lesson 3: Datetime & Random

    20:22

    Use the random module to generate numbers, sample unique values, shuffle lists, and complete exercises involving scores, dates, and lottery selections.

    View enrollment options at Noble Desktop
  • Loops

    Lesson 4: Loops & Strings

    4:29

    Explore loops by iterating over lists and ranges with for loops while avoiding infinite loops.

  • Enrollment required

    Loop the Nums List Challenge

    Lesson 4: Loops & Strings

    9:17

    Loop through numbers one through ten, square even numbers, cube odd numbers, and print the results.

    View enrollment options at Noble Desktop
  • Enrollment required

    List Methods Review Part 1

    Lesson 4: Loops & Strings

    13:11

    Practice list manipulation by extending lists, inserting and removing elements, popping by index, removing duplicates, and rearranging items without sorting.

    View enrollment options at Noble Desktop
  • Enrollment required

    List Methods Review Part 2

    Lesson 4: Loops & Strings

    9:03

    Insert specific elements into a list, remove items at given indices, deduplicate values using sets, sort lists, and maintain alphabetical order through targeted insertion.

    View enrollment options at Noble Desktop
  • Enrollment required

    Loop Method Exercise

    Lesson 4: Loops & Strings

    10:23

    Loop through a list to create transformed values, store results in a new list, and selectively print items while skipping defined positions.

    View enrollment options at Noble Desktop
  • Enrollment required

    Loop Challenges

    Lesson 4: Loops & Strings

    9:37

    Apply conditional logic to generate different outputs based on string length or other criteria, such as creating jelly beans, popsicles, jams, or lollipops.

    View enrollment options at Noble Desktop
  • Enrollment required

    In and Not In Operators

    Lesson 4: Loops & Strings

    16:23

    Use in and not in operators to test membership in strings and lists, and apply conditional logic to categorize items based on starting or ending characters.

    View enrollment options at Noble Desktop
  • Enrollment required

    String Methods

    Lesson 4: Loops & Strings

    34:06

    Manipulate strings using methods such as lower, upper, capitalize, replace, and split, while creating modified copies since strings are immutable.

    View enrollment options at Noble Desktop
  • Enrollment required

    Nested Loop

    Lesson 4: Loops & Strings

    11:01

    Create and shuffle a standard 52-card deck using nested loops and simulate dealing hands in a blackjack-style game.

    View enrollment options at Noble Desktop
  • Dictionaries Part 1

    Lesson 5: Dictionaries

    10:16

    Explore Python dictionaries by working with key-value pairs, nested structures, and list data within dictionaries.

  • Enrollment required

    Dictionaries Part 2

    Lesson 5: Dictionaries

    10:39

    Add, update, rename, and delete dictionary keys and values, and iterate through dictionary contents.

    View enrollment options at Noble Desktop
  • Enrollment required

    Dictionaries Scrabble Exercise

    Lesson 5: Dictionaries

    13:11

    Build a Scrabble score calculator that converts user input to uppercase, looks up letter values in a dictionary, accumulates points, and outputs a final score.

    View enrollment options at Noble Desktop
  • Numpy

    Lesson 6: Numpy

    4:33

    Introduce NumPy by importing it as np and using it to convert lists into multi-dimensional arrays for advanced data manipulation.

  • Enrollment required

    Numpy Array

    Lesson 6: Numpy

    18:34

    Transform lists into NumPy arrays to enable reshaping, transposing, and other array-based operations.

    View enrollment options at Noble Desktop
  • Enrollment required

    2D Selections with Numpy Array

    Lesson 6: Numpy

    18:27

    Perform two-dimensional selection and slicing in NumPy arrays, including creating matrices and extracting subarrays.

    View enrollment options at Noble Desktop
  • Pandas Dataframes Part 1

    Lesson 7: Pandas Dataframes

    5:21

    Create and analyze pandas DataFrames by converting lists and dictionaries into tabular structures for data analysis.

  • Enrollment required

    Pandas Dataframes Part 2

    Lesson 7: Pandas Dataframes

    10:18

    Load external images and display structured data such as a chessboard using pandas DataFrames with customized rows and columns.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 3

    Lesson 7: Pandas Dataframes

    14:01

    Select specific rows and columns from a DataFrame using the iloc method.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 4

    Lesson 7: Pandas Dataframes

    12:21

    Manipulate DataFrame sections to model chessboard layouts by slicing rows and columns and assigning pieces through indexing.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 5

    Lesson 7: Pandas Dataframes

    6:51

    Arrange structured data, such as chess pieces or food items, into DataFrames with associated attributes.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 6

    Lesson 7: Pandas Dataframes

    12:17

    Create DataFrames by defining column names and value lists of equal length to ensure proper row alignment.

    View enrollment options at Noble Desktop
  • Enrollment required

    Dataframes Location

    Lesson 7: Pandas Dataframes

    16:20

    Access and modify DataFrame data using loc for labels and iloc for integer-based indexing.

    View enrollment options at Noble Desktop
  • Enrollment required

    Select Rows by Condition

    Lesson 7: Pandas Dataframes

    24:16

    Filter DataFrames with Boolean conditions, update or remove rows and columns, and use describe to generate statistical summaries.

    View enrollment options at Noble Desktop
  • Enrollment required

    AT & IAT

    Lesson 7: Pandas Dataframes

    13:29

    Use at and iat for efficient scalar value assignment, apply string filtering with str.contains, and clean text data with str.replace.

    View enrollment options at Noble Desktop
  • Enrollment required

    Dataframes from Dictionary

    Lesson 7: Pandas Dataframes

    25:15

    Create DataFrames from dictionaries, concatenate multiple DataFrames, clean mismatched columns, and manage indices appropriately.

    View enrollment options at Noble Desktop
  • Enrollment required

    Dataframes Challenges

    Lesson 7: Pandas Dataframes

    6:28

    Add new rows to a DataFrame, then create filtered DataFrames based on calorie limits or multi-word names.

    View enrollment options at Noble Desktop
  • Enrollment required

    String Split

    Lesson 7: Pandas Dataframes

    12:39

    Split strings into lists using delimiters, remove file extensions, and manipulate string components with list operations.

    View enrollment options at Noble Desktop
  • Enrollment required

    Select and Filter by Condition

    Lesson 7: Pandas Dataframes

    21:09

    Filter and update DataFrames using multiple logical conditions and create new columns based on calculated values.

    View enrollment options at Noble Desktop
  • Enrollment required

    Vector Operations

    Lesson 7: Pandas Dataframes

    9:16

    Perform vectorized operations on DataFrame columns, sort and rename columns, and rearrange column order using pop and insert.

    View enrollment options at Noble Desktop
  • Introduction to Matplotlib

    Lesson 8: Bar Charts with Matplotlib

    14:46

    Use Matplotlib to create charts and visualizations, load CSV data into pandas, connect to Google Drive, and calculate summary statistics.

  • Enrollment required

    Python Data Selection

    Lesson 8: Bar Charts with Matplotlib

    18:01

    Review slicing techniques with loc and iloc, shuffle and split datasets, and group and sort data by defined criteria.

    View enrollment options at Noble Desktop
  • Enrollment required

    Data Visualization with Matplotlib

    Lesson 8: Bar Charts with Matplotlib

    21:21

    Create bar charts with Matplotlib, label bars clearly, sort data by multiple criteria, and adjust visual presentation.

    View enrollment options at Noble Desktop
  • Line and Scatter Charts with MatPlotlib

    Lesson 9: Line & Scatter Charts with Matplotlib

    13:56

    Plot scatter and line charts with Matplotlib, add regression lines, and highlight minimum and maximum values.

  • Enrollment required

    Linear Regression with Matplotlib

    Lesson 9: Line & Scatter Charts with Matplotlib

    26:39

    Apply NumPy and Matplotlib together to perform linear regression, visualize scatter data, and calculate best-fit lines for analysis.

    View enrollment options at Noble Desktop
  • Pivot, Plot, Animate

    Lesson 10: Pivot Population Data & Charts

    9:59

    Pivot datasets, generate pie charts and bar chart races, and manage missing data in data science workflows.

  • Enrollment required

    Data Cleaning

    Lesson 10: Pivot Population Data & Charts

    27:01

    Handle missing data by dropping, filling with averages, removing sparse columns, and exporting clean DataFrames to CSV files.

    View enrollment options at Noble Desktop
  • Enrollment required

    Two Different Ways to Make a Bar Chart

    Lesson 10: Pivot Population Data & Charts

    18:52

    Create bar charts by extracting and indexing country population data for accurate labeling.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pivoting the Data

    Lesson 10: Pivot Population Data & Charts

    16:20

    Pivot population data to restructure years and countries, then visualize trends with line and bar charts.

    View enrollment options at Noble Desktop
  • Enrollment required

    There is Always Time for Pie (Charts)

    Lesson 10: Pivot Population Data & Charts

    10:54

    Generate a pie chart illustrating population shares of selected countries and save the visualization as an image file.

    View enrollment options at Noble Desktop
  • Enrollment required

    Animated Bar Chart Race

    Lesson 10: Pivot Population Data & Charts

    13:10

    Install and configure the bar chart race library and generate an animated visualization showing population changes over time.

    View enrollment options at Noble Desktop

Tableau Course Online (Self-Paced)

  • Requirements & Getting Started

    Lesson 1: Getting Started With Tableau

    9:58

    Download and extract the class zip folder, install Tableau Public, and access the provided datasets, images, and presentations to follow along with day one of the Tableau training.

  • Enrollment required

    Introduction to Tableau

    Lesson 1: Getting Started With Tableau

    8:26

    Demonstrate how to access, sign into, and use both the Tableau Desktop and Tableau Public online versions to create and manage visualizations.

    View enrollment options at Noble Desktop
  • Enrollment required

    Understanding Data

    Lesson 1: Getting Started With Tableau

    14:47

    Learn key data concepts, explore chart types and visualization principles, understand Tableau features and dashboards, distinguish data types, evaluate data sources, and practice using vetted datasets for effective visual analysis.

    View enrollment options at Noble Desktop
  • Enrollment required

    Foundations for Building Data Visualizations

    Lesson 1: Getting Started With Tableau

    6:13

    Understand key skills for effective Tableau visualizations—statistics, storytelling, graphic design—and align data, questions, and visuals while using appropriate Tableau tools based on privacy and functionality needs.

    View enrollment options at Noble Desktop
  • Enrollment required

    Tableau Versions

    Lesson 1: Getting Started With Tableau

    7:06

    Understand Tableau’s user roles—Creators build content, Explorers analyze it, Viewers interact with it—while noting pricing, feature differences between Tableau Desktop and Public, and comparisons to Power BI in workflow and accessibility.

    View enrollment options at Noble Desktop
  • Enrollment required

    Workflow & Chart Types

    Lesson 1: Getting Started With Tableau

    4:57

    Follow the Tableau workflow by connecting data sources, formatting data, creating and editing visualizations in worksheets, building dashboards, and publishing results, while understanding chart types, and distinguishing dimensions (qualitative) from measures (quantitative).

    View enrollment options at Noble Desktop
  • Working with your Data

    Lesson 1: Getting Started With Tableau

    7:52

    Connect and structure clean, well-formatted data (like Superstore Sales) in Tableau Public, avoiding unstructured or mislabeled datasets that require correction with limited tools like Data Interpreter.

  • Enrollment required

    Creating your First Visualization

    Lesson 1: Getting Started With Tableau

    6:14

    Connect to your data by dragging and dropping the file into Tableau to quickly establish a connection without modifying the original data.

    View enrollment options at Noble Desktop
  • Enrollment required

    Previewing your Data in the Source Menu

    Lesson 1: Getting Started With Tableau

    9:25

    Connect and preview your data in Tableau by importing the main Orders table first, then add People and Returns to build relationships based on matching fields, verify data types, hide unnecessary fields, and ensure dimensions and measures are correctly identified by color.

    View enrollment options at Noble Desktop
  • Enrollment required

    Quickly Creating a Visualization

    Lesson 2: Creating Visualizations

    8:44

    Create a quick category-region report in Tableau using drag-and-drop fields, apply color scales for sales, quantity, and profit, adjust view to entire sheet, and add text labels with one click.

    View enrollment options at Noble Desktop
  • Enrollment required

    Data Visualization Basics

    Lesson 2: Creating Visualizations

    10:29

    Learn how to simplify complex data using visual tools like charts, colors, and sorting to make insights easy to understand at a glance.

    View enrollment options at Noble Desktop
  • Enrollment required

    The Tableau Interface

    Lesson 2: Creating Visualizations

    16:35

    Explore the Tableau interface by navigating the data source area, data sidebar, marks card, shelves, view pane, and menu options to build, format, and manage visualizations.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Pie Chart

    Lesson 2: Creating Visualizations

    13:33

    Create a pie chart using the Show Me panel by selecting one dimension (e.g., Person) and one measure (e.g., Sales), then customize it using the Marks card to add labels, percentages, adjust size and layout, and format text and colors as needed.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Bar or Column Chart

    Lesson 2: Creating Visualizations

    10:32

    Create bar or column charts by dragging dimensions (e.g., Subcategory) to Rows and measures (e.g., Sales) to Columns, adjust formatting using right-click or dropdown options, apply labels with the T button, set default currency formatting via Default Properties, and customize chart appearance through Format options including shading, borders, and axis scaling.

    View enrollment options at Noble Desktop
  • Swap Rows and Columns

    Lesson 2: Creating Visualizations

    3:59

    Swap rows and columns using the swap button, drag fields to rearrange positions, sort data alphabetically or by field values, reset to original data source order, and adjust view using the fit menu options.

  • Enrollment required

    Adding a Sub Category

    Lesson 2: Creating Visualizations

    5:54

    Add dimensions like subcategory and product to your chart to display hierarchical data and explore levels of detail, using the "Describe" option to assess member counts for practicality.

    View enrollment options at Noble Desktop
  • Enrollment required

    Sorting and Saving

    Lesson 2: Creating Visualizations

    3:07

    Summarize sorting options, explain saving methods including Save and Save As with TWB and TWX formats, clarify that Ctrl-S publishes to Tableau Public, and outline how to rename or hide sheet titles.

    View enrollment options at Noble Desktop
  • Organizing the Data Sidebar

    Lesson 3: Organizing Data

    6:53

    Create hierarchies in Tableau by grouping related fields (like country, state, city, zip) to organize the sidebar and simplify visualizations.

  • Enrollment required

    Sets

    Lesson 3: Organizing Data

    15:39

    Create a set to filter subcategories where total sales are greater than or equal to 100,000, enable "Show Members in Set," and optionally filter by year using a single value list for dynamic reporting across worksheets.

    View enrollment options at Noble Desktop
  • Enrollment required

    Groups

    Lesson 3: Organizing Data

    14:14

    Create manual groupings within a dimension to categorize data (e.g., electrical vs. non-electrical) by selecting and assigning values, similar to organizing breakout rooms.

    View enrollment options at Noble Desktop
  • Enrollment required

    Labels

    Lesson 3: Organizing Data

    5:50

    Adjust labels, tooltips, alignment, and formatting settings to customize data visualization display.

    View enrollment options at Noble Desktop
  • Enrollment required

    Tool Tips

    Lesson 3: Organizing Data

    12:22

    Edit axes to customize scale, tick marks, and labels; modify and reset tooltips to control displayed data and insert other worksheets for detailed hover views.

    View enrollment options at Noble Desktop
  • Enrollment required

    Measures

    Lesson 3: Organizing Data

    7:29

    Change measure aggregations (e.g., sum to average) and chart types (e.g., bar to line) by adjusting settings and using available controls in Tableau.

    View enrollment options at Noble Desktop
  • Enrollment required

    Marks Card

    Lesson 3: Organizing Data

    5:49

    Format sheets, rows, columns, fonts, alignment, shading, borders, and colors using the formatting sidebar or right-click options.

    View enrollment options at Noble Desktop
  • Tableau Calculations

    Lesson 4: Calculations and Dashboards

    8:37

    Create a calculated field for profit margin by dividing SUM(Profit) by SUM(Sales), then format it as a percentage and add it to the view using label or tooltip as needed.

  • Enrollment required

    Pages

    Lesson 4: Calculations and Dashboards

    8:21

    Use the Pages feature in Tableau with "Show History" enabled to overlay and animate year-by-year data changes in a single worksheet.

    View enrollment options at Noble Desktop
  • Enrollment required

    Dashboards Part 1

    Lesson 4: Calculations and Dashboards

    14:05

    Create a responsive Tableau dashboard by selecting "New Dashboard," setting the size to "Automatic," dragging in sheets and objects like text boxes, containers, and images, arranging them using floating or tiled layouts, customizing layout and appearance, and adding navigation buttons to link multiple dashboards for interactive navigation.

    View enrollment options at Noble Desktop
  • Enrollment required

    Dashboards Part 2

    Lesson 4: Calculations and Dashboards

    8:25

    Demonstrate how to create interactive Tableau dashboards with filters, navigation buttons, and publish them to Tableau Public for user interaction.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating Stories

    Lesson 4: Calculations and Dashboards

    2:54

    Create a story by dragging dashboards or charts onto blank pages, customizing layout with captions or numbers, adjusting size settings, and navigating in presentation mode.

    View enrollment options at Noble Desktop
  • Data Interpreter

    Lesson 5: Data Interpreter

    10:00

    Use Tableau's Data Interpreter to automatically detect and clean common spreadsheet issues like extra headers, footers, and multiple tables before importing the data.

  • Enrollment required

    Life Expectancy Exercise

    Lesson 5: Data Interpreter

    8:42

    Recreate the initial poor visualization in Tableau using the cleaned data, then improve it by applying best practices demonstrated through Excel's Power Query and pivot table features.

    View enrollment options at Noble Desktop
  • Enrollment required

    Life Expectancy Exercise Solution

    Lesson 5: Data Interpreter

    7:34

    Create a filtered area chart in Tableau showing the top 10 countries by life expectancy using summed values to handle missing data and improve visual clarity.

    View enrollment options at Noble Desktop
  • Creating Multi Chart Worksheets

    Lesson 6: Multi-Chart Worksheets

    10:00

    Create a multi-chart worksheet by dragging multiple measures into the rows or columns shelf, customizing each chart independently using individual marks cards.

  • Enrollment required

    Dual Axis & Combo Chart

    Lesson 6: Multi-Chart Worksheets

    8:50

    Create a dual-axis combo chart by placing two measures on Rows, assigning distinct chart types (e.g., bar for Sales, line for Profit), setting each to a non-automatic type, then selecting Dual Axis from the right-side measure’s dropdown, aligning scales with Synchronize Axis, and customizing colors as needed.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Better Line Chart

    Lesson 6: Multi-Chart Worksheets

    17:50

    Create a better line chart by overlaying two synchronized charts—one as a line and one as customizable circles or shapes—using dual axis in Tableau.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Butterfly Chart Part 1

    Lesson 6: Multi-Chart Worksheets

    8:48

    Create a basic butterfly chart by reversing the axis on one bar chart in a side-by-side layout to visualize opposing data categories.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Butterfly Chart Part 2

    Lesson 6: Multi-Chart Worksheets

    10:58

    Duplicate the basic butterfly chart, insert a zero-value calculated field between the two measures to place category labels in the center, change its mark type to text, clean up axes and gridlines, and adjust label formatting for a cleaner intermediate butterfly chart layout.

    View enrollment options at Noble Desktop
  • Enrollment required

    Formatting the Butterfly Chart

    Lesson 6: Multi-Chart Worksheets

    13:57

    Create an advanced butterfly chart with centered subcategory text by duplicating axes, synchronizing scales, layering dual-axis text fields, and adjusting formatting and colors for clarity.

    View enrollment options at Noble Desktop
  • Creating State Selector

    Lesson 7: Parameters and Filtering

    10:00

    Create a parameter called "state selector" from the State field, set its default value to New York, then connect it to a calculation, filter, or set to enable interactive map navigation.

  • Enrollment required

    Creating a Calculated Field

    Lesson 7: Parameters and Filtering

    15:26

    Create a calculated field called "State Focus" that filters data to a selected state or all states using a parameter.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Parameter to Control a Filter

    Lesson 7: Parameters and Filtering

    11:06

    Demonstrate how to create a parameter to dynamically control a top N filter for subcategories in a bar chart, enabling user input to adjust the number of displayed items (e.g., top 5, top 10), which is not possible using basic filters alone.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating an International Map Part 1

    Lesson 7: Parameters and Filtering

    12:12

    Troubleshoot and clean data in Tableau by fixing date formats, correcting city name misspellings with aliases, and resolving unrecognized international locations to create accurate visualizations.

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating an International Map Part 2

    Lesson 7: Parameters and Filtering

    8:18

    Exclude "MLS" from city filter, create a calculated field for "country" using an IF statement to assign Canadian cities to "Canada" and others to "US", change its data type to geographic role "country", drag it to the detail mark, and verify all locations appear on the map.

    View enrollment options at Noble Desktop
  • Enrollment required

    More Chart Types

    Lesson 7: Parameters and Filtering

    12:13

    Explore various Tableau chart types—including heat maps, density maps, highlight tables, pie and donut charts, stacked bars, scatter plots, histograms, box plots, Gantt charts, bullet graphs, and flow maps—with brief creation steps and usage tips.

    View enrollment options at Noble Desktop

Google Ads Bootcamp (Self-Paced)

  • History of Google Ads

    Lesson 1: Google Ads Foundations

    10:00

    Trace the evolution of Google Ads from AdWords to today’s AI-driven platform and how CPC pricing and ad innovations reshaped performance marketing.

  • Google Ads Overview

    Lesson 1: Google Ads Foundations

    10:00

    Explain core Google Ads terminology, campaign structure, and metrics, including how intent and quality score drive paid search success.

  • Enrollment required

    How Paid Search Works

    Lesson 1: Google Ads Foundations

    13:21

    Break down the paid search workflow from keyword selection to auctions, ad ranking, and ongoing optimization.

    View enrollment options at Noble Desktop
  • Enrollment required

    Pillars of Successful Ads

    Lesson 1: Google Ads Foundations

    4:43

    Identify the key pillars of Google Ads performance, including keywords, ad copy, landing pages, targeting, testing, and AI optimization.

    View enrollment options at Noble Desktop
  • Keywords

    Lesson 2: Keywords & Research Strategy

    9:53

    Define keyword types in Google Ads and connect search intent to each stage of the customer journey.

  • Enrollment required

    Keyword Research

    Lesson 2: Keywords & Research Strategy

    5:24

    Explain the role of keyword research and introduce a process for uncovering intent, competition, and conversion opportunities.

    View enrollment options at Noble Desktop
  • Enrollment required

    Finding the Right Keywords

    Lesson 2: Keywords & Research Strategy

    16:22

    Demonstrate how to use Keyword Planner and third-party tools to evaluate search volume, trends, intent, and cost data.

    View enrollment options at Noble Desktop
  • Ad Campaign Overview

    Lesson 3: Campaign Setup & Structure

    10:00

    Explain how Google Ads campaigns are structured, including objectives, bidding strategies, budgets, and targeting decisions.

  • Enrollment required

    Match Types

    Lesson 3: Campaign Setup & Structure

    7:38

    Clarify how match types control when ads appear and how to balance reach, relevance, and cost

    View enrollment options at Noble Desktop
  • Ad Creation

    Lesson 4: Ad Creation & Compliance

    10:00

    Learn how search ads are built and optimized using headlines, descriptions, extensions, and testing best practices.

  • Enrollment required

    Creating a Google Text Ad

    Lesson 4: Ad Creation & Compliance

    18:40

    Gain insight into how to create and manage responsive search ads directly in Google Ads Manager.

    View enrollment options at Noble Desktop
  • Ad Rank & Quality Score

    Lesson 5: Quality, Landing Pages & Conversion Tracking

    10:00

    Explain how ad rank and quality score determine placement, visibility, and cost per click in Google Ads auctions.

  • Enrollment required

    Landing pages

    Lesson 5: Quality, Landing Pages & Conversion Tracking

    14:43

    Define landing pages and outline best practices for designing mobile-optimized pages that drive conversions.

    View enrollment options at Noble Desktop
  • Enrollment required

    Conversion Tracking

    Lesson 5: Quality, Landing Pages & Conversion Tracking

    8:28

    Learn what conversions are and how tracking them enables performance measurement and campaign optimization.

    View enrollment options at Noble Desktop
  • Understanding Reports in Google Ads

    Lesson 6: Reporting & Optimization

    10:00

    Walk through key Google Ads reports and show how to interpret metrics to improve campaign strategy.

  • Enrollment required

    Analyzing & Optimizing Campaign Performance

    Lesson 6: Reporting & Optimization

    7:10

    Apply data-driven analysis techniques to optimize keywords, ads, bids, budgets, and landing pages

    View enrollment options at Noble Desktop
  • Audience Targeting

    Lesson 7: Audience Expansion & Scaling

    10:00

    Explore audience targeting options and how they improve relevance in Google Ads campaigns

  • Enrollment required

    Remarketing with Google Ads

    Lesson 7: Audience Expansion & Scaling

    9:24

    Explain how remarketing re-engages past visitors using segmented audiences and personalized messaging

    View enrollment options at Noble Desktop
  • Enrollment required

    Display Advertising with Google Ads

    Lesson 7: Audience Expansion & Scaling

    13:43

    A look at display advertising and the Google Display Network, comparing formats and targeting strategies beyond search.

    View enrollment options at Noble Desktop

Course Reviews

No reviews yet

Be the first to share your experience with this course

Write the First Review

Find the path that fits your
career goals

Sign up for bootcamp advice

Enter your email to join our newsletter community.

By submitting this form, you agree to receive email marketing from Course Report.