Business Analyst Certificate (NYC or Online)
- 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 DesktopSummary
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.
Topics included
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
-
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.
-
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.
-
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.
-
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
-
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
-
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
-
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.
-
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
-
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
-
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.
-
–
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.
- 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
-
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
-
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
-
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
-
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
-
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
-
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
-
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.
-
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
-
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
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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.
This preview is temporarily unavailable. Please try again later.
-
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
This preview is temporarily unavailable. Please try again later.
-
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