“MBA” Business 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
Become a well-rounded business professional in this hands-on program. Developed by graduates of top business schools, our program will equip professionals with essential tools and concepts needed to thrive in today's competitive business environment, including some of the skills taught in MBA programs. (Note: this certificate is an "MBA-style" course, not an MBA degree.)
This program covers a range of critical subjects, from project management and key financial processes to marketing strategies and data analysis using Microsoft Excel. By mastering these areas, you will gain a robust understanding of financial accounting, corporate finance fundamentals, and the necessary skills to manage projects and promote your business or organization.
Additionally, the certificate program delves into the practical applications of generative AI, empowering participants to enhance workplace productivity. With the option to choose electives tailored to specific interests, learners can further refine their expertise and take their business acumen to the next level. This program is ideal for professionals seeking to elevate their careers and drive success in their organizations.
Topics included
Curriculum
What you'll learn
- Master the critical tools and concepts to succeed in the business world.
- Build skills in project management.
- Learn key financial processes, including financial accounting and corporate finance fundamentals.
- Develop marketing strategies to promote your business.
- Use Microsoft Excel to manage and analyze data.
- Leverage generative AI to become more productive in the workplace.
- Take your business acumen to the next level with electives in your area of focus.
Course outline
-
Project Management Level I 6 hours
Learn the strategies, methods, and terminology commonly used in project management. Develop a practical understanding of the five stages of project management, focusing on the Initiation and Planning phases, and gain insight into the skills and responsibilities of a successful Project Manager.
- Learn about the five phases of project management, focusing on the first two: Initiation and Planning
- Understand important foundational concepts and project management terms
- Learn about selecting projects, defining/planning/scheduling activities, managing resources, and much more
- Become familiar with the various duties and qualities of a Project Manager
-
Project Management Level II 6 hours
Learn advanced project management techniques, including execution, monitoring, and closing phases. Learn to manage budgets, resources, and risks. Discover Agile Project Management and popular frameworks like Scrum, Kanban, and XP.
- Continue learning about the five phases of project management, focusing on the last three: Execution, Monitoring, and Closing
- Understand project costs and budgeting
- Learn how to manage resources
- Manage risk, changes, and uncertainty
- Get an overview of Agile Project Management frameworks: Scrum, Kanban, and Extreme Programming (XP)
-
Intro to Financial Accounting & Financial Statements 6 hours
Learn how to analyze financial statements and reports, including income statements, balance sheets, and cash flow statements, and understand essential financial accounting principles and metrics. This course offers hands-on exercises using real-life examples from well-known companies like Facebook, Amazon, and Apple to demonstrate practical application.
- Financial accounting fundamentals, including cash versus accrual accounting and GAAP
- Income statement line items and financial metrics
- Balance sheet: Assets = Liabilities + Shareholders' Equity
- Cash Flow Statement: Cash flows from operating, investing, and financing activities
- How the financial statements tie together
-
Intermediate Financial Accounting 6 hours
Build your knowledge of investments, securities, debt accounting, and other complex financial accounting concepts in this class.
- Prepare for complex accounting tasks
- Learn advanced income statement processes
- Handle unusual items and EPS
- Work with deferred taxes and tax journal entries
- Manage intercompany investments
- Understand how debt accounting works
-
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.
-
Data Analytics Foundations 12 hours
Learn the fundamentals of data analytics, including descriptive and inferential statistics, and how different industries and organizations use data for forecasting and decision-making. Explore statistical analysis and modeling, including statistical algorithms, theorems, and models.
- Understand core statistical concepts such as measures of central tendency, data dispersion, and the normal distribution
- Explore descriptive and inferential statistics, including probability distributions such as binomial and Poisson
- Learn to analyze and forecast data using correlation, linear regression, and multiple regression models
- Apply predictive analytics using tools such as trendlines, moving averages, and scenario modeling
- Create clear data visualizations with charts, histograms, icon sets, color scales, sparklines, and pivot tables
- Discover prescriptive analytics methods like Solver and linear programming to support optimized decision-making
-
Marketing Strategy 12 hours
Learn the fundamentals of successful marketing to help you achieve your business goals in this one-day class.
- Understand the foundational principles of marketing
- Learn how to conduct market research to identify target audiences, understand their needs, and analyze market trends
- Discover how to create an effective marketing plan, including setting clear objectives, defining strategies, and outlining actionable steps
- Gain an introduction to digital marketing channels and learn how to leverage them in your strategy
- Learn how to track and measure the success of your marketing efforts using key performance indicators (KPIs) and analytics tools
-
Generative AI with ChatGPT 6 hours
Harness the creative power of AI with this hands-on workshop. Explore the cutting-edge world of artificial intelligence and learn how to generate text, ideas, and more with the innovative technology of ChatGPT.
- Explore generative AI and ChatGPT to understand what’s possible and how you can use it
- Learn how to write prompts that generate useful responses
- Discover real-world applications of ChatGPT
-
AI for Workplace Productivity with Microsoft Copilot 6 hours
Learn how to use Microsoft Copilot and its integration into Office apps (365 apps such as Excel, Word, PowerPoint, Outlook, Teams, and OneDrive) to expand your capabilities, save time, and make you more creative/professional.
- Understand the fundamentals of artificial intelligence and how large language models (LLMs), like Copilot, work
- Learn how to write effective prompts and refine Copilot's responses across different workplace scenarios
- Explore how to use Copilot with Microsoft 365 apps, including Word, Excel, PowerPoint, Outlook, Teams, and OneDrive
- Automate and enhance everyday tasks, such as email writing, meeting notes, data analysis, and document summarization
- Create AI-generated images and graphics, and understand the limitations, as well as best practices, of generative AI
- Compare Copilot with ChatGPT and GitHub Copilot and identify when to use each for maximum productivity
- Stay up-to-date with the latest AI tools and mobile apps to extend your workflow beyond the desktop
-
Applied Leadership & Management Skills 12 hours
Learn how to become an effective leader and manager in a business setting. This class covers different leadership and communication styles and techniques for managing a team with confidence.
- Explore different leadership styles and when to apply them effectively
- Learn techniques for clear, persuasive, and motivational communication
- Understand how to build, manage, and motivate high-performing teams
- Gain strategies for resolving conflicts and fostering a collaborative environment
-
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
-
Financial Modeling Bootcamp 18 hours
Join our financial modeling class to learn essential finance and accounting concepts, build a discounted cash flow (DCF) model in Excel, acquire advanced Excel skills, explore corporate finance and valuation, and create a financial model on a real company. This hands-on course will teach you practical financial skills.
- Financial concepts, market capitalization, and enterprise value
- Financial accounting, including accrual versus cash accounting
- Discounted cash flow (DCF) modeling: assumptions, projecting cash flows, sensitivities, auditing
- Excel techniques, including Data Validation, CHOOSE, Data Tables, and Goal Seek
- Leveraged buyout (LBO) modeling
- Real company analysis
- Setting up the financial model and model projections
- Corporate valuation and how to derive a value per share
- How to analyze the model output
-
AI for Marketing Course 18 hours
Learn how to incorporate AI in your marketing strategy with this in-depth course. Explore how to use AI-driven tools to help your SEO, SEM, social media marketing, analytics tracking, paid advertising, and more.
- Leverage AI-driven strategy in your marketing campaigns
- Integrate AI into SEO, SEM, content, advertising, and analytics
- Measure the real-world impact of your AI marketing efforts
- Complete a capstone project to showcase your work
-
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
-
Business Writing Bootcamp 18 hours
Join our Business Writing Bootcamp to improve your writing skills. Learn grammar essentials, effective business writing skills, and advanced communication techniques. Gain practical strategies to create complex business documents confidently.
- Practical strategies to sharpen your writing skills from idea to final draft.
- Essential grammar rules.
- How to prepare complex multi-page business documents.
-
PowerPoint Bootcamp 12 hours
Take your PowerPoint skills to the next level with our accelerated course. Learn everything from the basics of creating presentations to more advanced features like custom themes, animations, and managing large presentations.
- Create new presentations using appropriate layouts, text formatting, and visual content like photos, shapes, and SmartArt.
- Design tables and charts and integrate data to communicate complex information clearly.
- Apply transitions and run slide shows, refining your presentations for clarity and engagement.
- Build custom themes and templates with branded fonts, colors, and layouts for reusable, consistent design.
- Use animations and video to enhance audience engagement and storytelling.
- Manage large presentations with sections, hidden slides, and custom shows for smooth delivery.
- Collaborate with others using comments and feedback tools within PowerPoint.
- Customize and animate charts and tables, including those imported from Excel, for dynamic data visuals.
-
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
-
Intro to Corporate Finance 6 hours
Learn the essentials of corporate finance, from capital allocation to corporate valuation, initial public offerings, financial instruments, and mergers and acquisitions. Throughout the class, we will use real-world case studies of recent deals and examine live pricing of various securities.
- Corporate finance fundamentals, including NPV and IRR
- Roles of corporate finance professionals and investment bankers
- Financial instruments: stocks, bonds, and options
- Initial Public Offerings
- Bonds, yields, and credit ratings
- Dividends versus share buybacks
- Mergers and acquisitions
- How leverage increases risk and returns, and corporate valuation
-
Power BI Bootcamp 12 hours
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
- Import data from Excel worksheets, CSV, and many more
- Transform/clean your data using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
-
Figma Bootcamp 12 hours
Start learning Figma for UI/UX design. Gain a solid understanding of its capabilities, from creating files, to designing on a grid, working with text/photos/colors, creating components, building prototypes, exporting assets, sharing files, creating animations, and more.
- Create UI (user interface) and UX (user experience) designs for websites, apps, and more
- Design finished layouts that are optimized for mobile, tablet, and desktop screens
- Design on grids, extract image assets, share designs with clients/developers, and more
- Build interactive prototypes
- Make animations using smart animate
- Use components (including variants) to make updating your designs easier
- Work with Team libraries to share style and design components
-
SEO Bootcamp 12 hours
Gain a competitive advantage with hands-on lessons in Search Engine Optimization (SEO) and competitive keyword analysis. Learn advanced SEO strategies and launch your website to the top in this practical bootcamp.
- Understand how search engines work and why SEO is essential for business growth
- Conduct effective keyword research using tools like Semrush to discover high-impact search terms
- Conduct competitive analysis to uncover your competitors' strategies and refine your keyword targeting
- Create SEO-friendly content tailored to the customer's buying journey and user search intent
- Implement on-page SEO techniques, including meta tag optimization, sitemaps, and internal linking
- Explore off-page SEO practices like backlink building and content promotion strategies
- Design websites with SEO in mind, including structured navigation, rich snippets, and mobile optimization
- Optimize video content for platforms like YouTube and conduct SEO audits to measure and improve performance
-
Google Analytics Bootcamp 12 hours
Learn how to use Google Analytics and its applications for marketing, including tracking data, interpreting reports, and optimizing performance. Discover GA4 and its new features.
- Understand the fundamentals of web analytics and the role of Google Analytics in the buyer’s journey
- Set up and configure Google Analytics accounts, filters, goals, and ecommerce tracking
- Navigate the GA4 dashboard and learn how to interpret audience, acquisition, behavior, and conversion reports
- Build and interpret measurement plans to track KPIs that align with your business objectives
- Create and customize dashboards, shortcuts, and shared reports to streamline data access
- Implement UTM parameters to track marketing campaign performance across platforms
- Learn retargeting strategies and build remarketing lists using Google Analytics data
- Apply best practices for leveraging data insights to optimize marketing and user engagement
-
Stock Market Investing 6 hours
Gain a comprehensive understanding of stock investing, valuation, and stock movements in this course. Learn about essential valuation techniques, financial statements, and the fundamentals of stock investing, as well as the factors that influence stock prices and how to analyze them.
- Learn the fundamentals of stock investing, including indices, dividends, and exchange-traded funds (ETFs)
- Analyze companies using valuation techniques like P/E ratios, EV/EBITDA multiples, and DCF modeling
- Understand key financial indicators such as market capitalization, enterprise value, and cost of capital
- Explore the impact of earnings releases, interest rates, and Federal Reserve policy on stock movements
- Receive an introduction to bond investing, including bond types, yields, spreads, and credit risk assessment
- Delve into real estate investing topics like REITs, capitalization rates, and the effect of leverage
- Examine stock options, hedging strategies, and the Black-Scholes pricing model for options trading
- Investigate the causes and impact of the 2008 financial crisis, including mortgage-backed securities and credit default swaps
What's included
- Free course retake within one year to refresh the material and gain practice.
- 8 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
Mon, Tue, Wed, Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Thu, Fri, Mon, Tue, Wed
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Thu, Fri, Mon, Tue, Wed
10:00–17:00 · America/New_York (EST/EDT)
-
–
In-person or live online
Thu, Fri, Tue, Wed, Mon
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Thu, Fri, Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Wed, Thu, Mon, Tue, Fri
10:00–17:00 · America/New_York (EDT/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 390 days. You can choose when to start your access period. Once you activate, you will have 390 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
- $3,495
- Course length
- 132 hours
- Schedule
- On your schedule
Build well-rounded business skills at your own pace in this MBA-style certificate program. Developed by graduates of top business schools, this program covers key concepts in finance, marketing, project management, Excel for data analysis, and productivity with generative AI. (Note: this certificate is an "MBA-style" course, not an MBA degree.)
You’ll gain practical tools for managing projects, understanding financial processes, promoting a business or organization, and strengthening workplace productivity. Optional electives allow you to tailor the program to your professional goals.
Self-paced curriculum
What you'll learn self-paced
- Master the critical tools and concepts to succeed in the business world.
- Build skills in project management.
- Learn key financial processes, including financial accounting and corporate finance fundamentals.
- Develop marketing strategies to promote your business.
- Use Microsoft Excel to manage and analyze data.
- Leverage generative AI to become more productive in the workplace.
- Take your business acumen to the next level with electives in your area of focus.
Self-paced course outline
-
Project Management Level I (Self-Paced) 6 hours
Learn the strategies, methods, and terminology commonly used in project management. Develop a practical understanding of the five stages of project management, focusing on the Initiation and Planning phases, and gain insight into the skills and responsibilities of a successful Project Manager.
- Learn about the five phases of project management, focusing on the first two: Initiation and Planning
- Understand important foundational concepts and project management terms
- Learn about selecting projects, defining/planning/scheduling activities, managing resources, and much more
- Become familiar with the various duties and qualities of a Project Manager
-
Project Management Level II (Self-Paced) 6 hours
Learn advanced project management techniques, including execution, monitoring, and closing phases. Learn to manage budgets, resources, and risks. Discover Agile Project Management and popular frameworks like Scrum, Kanban, and XP.
- Continue learning about the five phases of project management, focusing on the last three: Execution, Monitoring, and Closing
- Understand project costs and budgeting
- Learn how to manage resources
- Manage risk, changes, and uncertainty
- Get an overview of Agile Project Management frameworks: Scrum, Kanban, and Extreme Programming (XP)
-
Intro to Financial Accounting & Financial Statements (Self-Paced) 6 hours
Learn to interpret and analyze financial statements, such as income statements, balance sheets, and cash flow statements, while grasping essential accounting principles and metrics. This course features hands-on exercises using real-world data from companies like Facebook, Amazon, and Apple to showcase practical applications.
- Gain a solid understanding of financial accounting fundamentals, including cash vs. accrual accounting and GAAP
- Break down income statement line items and key financial ratios
- Master the balance sheet equation: Assets = Liabilities + Shareholders' Equity
- Understand cash flow statements, covering operations, investing, and financing activities
- Learn how to connect and interpret financial statements together
-
Intermediate Financial Accounting (Self-Paced) 6 hours
Enhance your understanding of investments, securities, debt accounting, and other advanced financial accounting concepts in this course.
- Prepare for advanced accounting tasks
- Learn intricate income statement processes
- Manage unusual items and earnings per share (EPS)
- Work with deferred taxes and tax journal entries
- Navigate intercompany investments
- Understand the complexities of debt accounting
-
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
-
Data Analytics Foundations Course Online (Self-Paced) 12 hours
Learn the fundamentals of data analytics, including descriptive and inferential statistics, and how different industries and organizations use data for forecasting and decision-making. Explore statistical analysis and modeling, including statistical algorithms, theorems, and models.
- Understand core statistical concepts including measures of central tendency, data dispersion, and the normal curve
- Explore descriptive and inferential statistics, including probability distributions like binomial and Poisson
- Learn to analyze and forecast data using correlation, linear regression, and multiple regression techniques
- Apply predictive analytics with tools like trendlines, moving averages, and scenario modeling
- Create clear data visualizations using charts, histograms, icon sets, color scales, sparklines, and pivot tables
- Discover prescriptive analytics techniques such as Solver and linear programming to optimize decision-making
-
Marketing Strategy (Self-Paced) 12 hours
Learn the fundamentals of successful marketing to help you achieve your business goals in this self-paced class.
- Understand the foundational principles of marketing
- Learn how to conduct market research to identify target audiences, understand their needs, and analyze market trends
- Discover how to create an effective marketing plan, including setting clear objectives, defining strategies, and outlining actionable steps
- Gain an introduction to digital marketing channels and learn how to leverage them in your strategy
- Learn how to track and measure the success of your marketing efforts using key performance indicators (KPIs) and analytics tools
-
Generative AI with ChatGPT Online (Self-Paced) 6 hours
Harness the creative power of AI with this hands-on workshop. Explore the cutting-edge world of artificial intelligence and learn how to generate text, ideas, and more with the innovative technology of ChatGPT.
- Explore the capabilities of generative AI and ChatGPT, and learn how to apply them
- Master prompt writing techniques to generate accurate, relevant responses
- Uncover real-world applications of ChatGPT across creative and professional workflows
-
AI for Productivity with Copilot Online (Self-Paced) 6 hours
Learn how to use Microsoft Copilot and its integration into Office apps (365 apps such as Excel, Word, PowerPoint, Outlook, Teams, and OneDrive) to expand your capabilities, save time, and make you more creative/professional.
- Learn the core concepts of artificial intelligence and how large language models (LLMs) like Copilot function
- Write prompts and fine-tune Copilot’s responses for a variety of real-world workplace scenarios
- Integrate Copilot with Microsoft 365 apps, including Word, Excel, PowerPoint, Outlook, Teams, and OneDrive
- Streamline routine tasks like writing emails, summarizing documents, capturing meeting notes, and analyzing data
- Generate AI-powered images and visuals while understanding the limitations and best practices of generative AI
- Compare Copilot with ChatGPT and GitHub Copilot to determine the best tool for each task
- Discover emerging AI tools and mobile apps that can expand your workflow beyond traditional desktop use
-
Applied Leadership & Management Skills (Self-Paced) 12 hours
Learn how to lead and manage with confidence in a business setting. This self-paced course covers leadership styles, communication techniques, and practical strategies for managing a team effectively.
- Explore different leadership styles and when to apply them effectively
- Learn techniques for clear, persuasive, and motivational communication
- Understand how to build, manage, and motivate high-performing teams
- Gain strategies for resolving conflicts and fostering a collaborative environment
-
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
-
Financial Modeling Bootcamp (Self-Paced) 18 hours
Take this self-paced financial modeling class to learn core finance and accounting concepts, build a discounted cash flow model in Excel, strengthen advanced Excel skills, and explore corporate finance and valuation using real company data. The course focuses on practical, job-ready financial modeling skills you can apply at your own pace.
- Core financial concepts, including market capitalization and enterprise value
- Financial accounting fundamentals, with a focus on accrual versus cash accounting
- Discounted cash flow modeling, covering assumptions, cash flow projections, sensitivity analysis, and model auditing
- Advanced Excel techniques such as Data Validation, CHOOSE, Data Tables, and Goal Seek
- Leveraged buyout modeling and valuation fundamentals
- Real company financial analysis using practical data
- Structuring financial models and building clear, reliable projections
- Corporate valuation methods and how to calculate value per share
- Interpreting and evaluating model outputs for accuracy and decision-making
-
AI for Marketing Course (Self-Paced) 18 hours
Learn how to incorporate AI in your marketing strategy with this in-depth course. Explore how to use AI-driven tools to help your SEO, SEM, social media marketing, analytics tracking, paid advertising, and more.
- Leverage AI-driven strategy in your marketing campaigns
- Integrate AI into SEO, SEM, content, advertising, and analytics
- Measure the real-world impact of your AI marketing efforts
- Complete a capstone project to showcase your work
-
Business Writing Bootcamp (Self-Paced) 18 hours
Join our Business Writing Bootcamp to strengthen your writing skills. You'll cover grammar essentials, effective business writing skills, and advanced communication techniques. Walk away with practical strategies to create complex business documents confidently.
- Practical strategies to sharpen your writing skills from idea to final draft
- Essential grammar rules
- How to prepare complex, multi page business documents
- Become a more effective communicator
-
PowerPoint Bootcamp (Self-Paced) 12 hours
Take your PowerPoint skills to the next level with this accelerated self-paced course. You’ll build from core presentation fundamentals to advanced features such as custom themes, animations, and tools for managing large, complex presentations.
- Create new presentations at your own pace using appropriate layouts, text formatting, and visual content such as photos, shapes, and SmartArt.
- Design tables and charts and integrate data to clearly communicate complex information.
- Apply transitions and run slide shows, refining presentations for clarity and engagement.
- Build custom themes and templates with branded fonts, colors, and layouts for reusable, consistent design.
- Use animations and video to enhance audience engagement and storytelling.
- Manage large presentations using sections, hidden slides, and custom shows for smooth delivery.
- Collaborate with others through comments and feedback tools within PowerPoint.
- Customize and animate charts and tables, including those imported from Excel, for dynamic data visuals.
-
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
-
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
-
Intro to Corporate Finance (Self-Paced) 6 hours
Learn the essentials of corporate finance at your own pace, including capital allocation, corporate valuation, initial public offerings, financial instruments, and mergers and acquisitions. Real-world case studies and live pricing examples help connect these concepts to practical finance scenarios.
- Corporate finance fundamentals, including NPV and IRR
- Roles of corporate finance professionals and investment bankers
- Financial instruments: stocks, bonds, and options
- Initial Public Offerings
- Bonds, yields, and credit ratings
- Dividends versus share buybacks
- Mergers and acquisitions
- How leverage increases risk and returns, and corporate valuation
-
Power BI Bootcamp (Self-Paced) 12 hours
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
- Import and clean data from multiple sources, including Excel, CSV, and online databases, using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service, including exporting, commenting, and app integration
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
-
Figma Bootcamp (Self-Paced) 12 hours
Start learning Figma for UI/UX design. Gain a solid understanding of its capabilities, from creating files, to designing on a grid, working with text/photos/colors, creating components, building prototypes, exporting assets, sharing files, creating animations, and more.
- Create UI (user interface) and UX (user experience) designs for websites, apps, and more
- Design finished layouts that are optimized for mobile, tablet, and desktop screens
- Design on grids, extract image assets, share designs with clients/developers, and more
- Build interactive prototypes
- Make animations using smart animate
- Use components (including variants) to make updating your designs easier
- Work with Team libraries to share style and design components
-
SEO Bootcamp (Self-Paced) 12 hours
Gain a competitive advantage with hands-on lessons in Search Engine Optimization (SEO) and competitive keyword analysis. Learn advanced SEO strategies and launch your website to the top in this practical bootcamp.
- Understand how search engines work and why SEO is essential for business growth
- Conduct effective keyword research using tools like Semrush to discover high-impact search terms
- Conduct competitive analysis to uncover your competitors' strategies and refine your keyword targeting
- Create SEO-friendly content tailored to the customer's buying journey and user search intent
- Implement on-page SEO techniques, including meta tag optimization, sitemaps, and internal linking
- Explore off-page SEO practices like backlink building and content promotion strategies
- Design websites with SEO in mind, including structured navigation, rich snippets, and mobile optimization
- Optimize video content for platforms like YouTube and conduct SEO audits to measure and improve performance
-
Google Analytics Bootcamp (Self-Paced) 12 hours
Learn how to use Google Analytics and its applications for marketing, including tracking data, interpreting reports, and optimizing performance. Discover GA4 and its new features.
- Understand the fundamentals of web analytics and the role of Google Analytics in the buyer’s journey
- Set up and configure Google Analytics accounts, filters, goals, and ecommerce tracking
- Navigate the GA4 dashboard and learn how to interpret audience, acquisition, behavior, and conversion reports
- Build and interpret measurement plans to track KPIs that align with your business objectives
- Create and customize dashboards, shortcuts, and shared reports to streamline data access
- Implement UTM parameters to track marketing campaign performance across platforms
- Learn retargeting strategies and build remarketing lists using Google Analytics data
- Apply best practices for leveraging data insights to optimize marketing and user engagement
-
Stock Market Investing (Self-Paced) 6 hours
Develop a well rounded understanding of stock investing, valuation, and stock movements in this course. You'll learn essential valuation techniques, work through financial statements, and cover the fundamentals of stock investing, plus explore the factors that influence stock prices and how to analyze them.
- Get grounded in the fundamentals of stock investing, including indices, dividends, and exchange traded funds (ETFs)
- Analyze companies using valuation techniques such as P/E ratios, EV/EBITDA multiples, and DCF modeling
- Understand key financial indicators like market capitalization, enterprise value, and cost of capital
- Explore how earnings releases, interest rates, and Federal Reserve policy shape stock movements
- Get an introduction to bond investing, covering bond types, yields, spreads, and credit risk assessment
- Dive into real estate investing topics like REITs, capitalization rates, and how leverage comes into play
- Examine stock options, hedging strategies, and the Black Scholes pricing model for options trading
- Investigate what caused the 2008 financial crisis and its impact, including mortgage backed securities and credit default swaps
What's included with self-paced
- 8 one-on-one mentoring sessions
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Project Management Level I (Self-Paced)
-
Course Overview & Setup
Lesson 1: Project Management Fundamentals
1:31
Learn core project management practices to plan, execute, and deliver successful projects of any size.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Course Topics and Projects vs Routine Work
Lesson 1: Project Management Fundamentals
8:07
Understand how projects differ from routine work by defining their temporary, unique, and goal-driven nature.
View enrollment options at Noble Desktop -
Enrollment required
Project Management Methodologies
Lesson 1: Project Management Fundamentals
24:23
Compare project management methodologies such as Waterfall, Critical Path, Scrum, and Kanban, and determine when each is appropriate.
View enrollment options at Noble Desktop -
Enrollment required
Project Management Fundamentals
Lesson 1: Project Management Fundamentals
19:42
Learn foundational concepts, including scope, cost, time, quality, and the project manager’s role across the lifecycle.
View enrollment options at Noble Desktop -
The Initiation Phase Project Identification & Selection
Lesson 2: The Initiation Process
6:23
Understand how organizations identify, evaluate, and prioritize projects based on value, risk, and strategic alignment.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
The Initiation Phase Project Charter
Lesson 2: The Initiation Process
23:41
Define the purpose and components of a project charter, including objectives, deliverables, risks, and approvals.
View enrollment options at Noble Desktop -
Project Scope & Work Breakdown Structure (WBS)
Lesson 3: The Planning Phase
10:00
Define project scope and use a Work Breakdown Structure (WBS) to break deliverables into manageable tasks.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Task Responsibility
Lesson 3: The Planning Phase
6:35
Assign task ownership using RACI to clarify responsibility, accountability, consultation, and communication.
View enrollment options at Noble Desktop -
Enrollment required
Sequencing Activities
Lesson 3: The Planning Phase
19:42
Sequence project tasks using dependencies and network diagrams, accounting for resource constraints.
View enrollment options at Noble Desktop -
Enrollment required
Activity Resources
Lesson 3: The Planning Phase
8:44
Plan project resources by identifying people, equipment, materials, and services needed for execution.
View enrollment options at Noble Desktop -
Enrollment required
Start & Finish Times, Critical Path, & Slack or Float
Lesson 3: The Planning Phase
16:41
Analyze schedules using critical path, float, and dependency relationships to determine project duration.
View enrollment options at Noble Desktop -
That Project Management Game
Lesson 4: Project Management Responsibilities & Delegation
6:05
Apply project concepts through a simulation that demonstrates scheduling, budgeting, tradeoffs, and delays.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Project Manager Responsibilities
Lesson 4: Project Management Responsibilities & Delegation
10:37
Understand the project manager’s leadership responsibilities, including planning, communication, and decision-making.
View enrollment options at Noble Desktop -
Enrollment required
Delegation
Lesson 4: Project Management Responsibilities & Delegation
11:11
Develop effective delegation skills to empower teams, build trust, and avoid micromanagement.
View enrollment options at Noble Desktop
Project Management Level II (Self-Paced)
-
Project Team & Project Kickoff Meeting
Lesson 1: The Project Team
10:00
Learn how project teams form and align through kickoff meetings and early collaboration.
This preview is temporarily unavailable. Please try again later.
-
Budgets and Costs
Lesson 2: Budgets & Costs
8:19
Understand key project cost components, including resources, risk reserves, and quality-related expenses.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Determining Activity Costs
Lesson 2: Budgets & Costs
5:58
Estimate activity-level costs by accounting for labor, materials, equipment, travel, and risk buffers.
View enrollment options at Noble Desktop -
Enrollment required
Determining Project Budget
Lesson 2: Budgets & Costs
7:00
Build a time-phased project budget to establish a financial baseline for tracking and forecasting.
View enrollment options at Noble Desktop -
Enrollment required
Execution Phase Actual Costs
Lesson 2: Budgets & Costs
7:00
Track actual and committed costs against the budget to identify variances early.
View enrollment options at Noble Desktop -
Enrollment required
Value of Work Performed & Forecasted Cost at Completion
Lesson 2: Budgets & Costs
18:21
Measure project performance using earned value to assess cost efficiency and progress.
View enrollment options at Noble Desktop -
Enrollment required
Controlling Costs & Corrective Action
Lesson 2: Budgets & Costs
11:46
Identify and correct cost overruns through variance analysis and corrective actions.
View enrollment options at Noble Desktop -
Limited Resources Resource Smoothing and Leveling
Lesson 3: Resources & Risk Management
9:57
Optimize schedules using resource leveling and smoothing when constraints exist.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Risk Management
Lesson 3: Resources & Risk Management
26:03
Identify and prioritize project risks using probability and impact analysis with mitigation plans.
View enrollment options at Noble Desktop -
Project Communication Meetings
Lesson 4: Project Communication
6:01
Differentiate common project meetings and understand how meeting structure supports progress.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Project Communication Reports
Lesson 4: Project Communication
6:48
Use project reports to communicate status, performance, and outcomes without meetings.
View enrollment options at Noble Desktop -
Enrollment required
Project Communication Plans
Lesson 4: Project Communication
3:34
Establish communication and document control plans to ensure consistent, up-to-date information.
View enrollment options at Noble Desktop -
Enrollment required
The Closing Phase
Lesson 5: The Closing Phase
9:24
Close projects by finalizing payments, evaluating performance, and documenting lessons learned.
View enrollment options at Noble Desktop -
Enrollment required
Agile Project Management
Lesson 06: Agile Project Management
15:37
Compare Agile and traditional approaches to determine when adaptability is required.
View enrollment options at Noble Desktop -
Project Management Certifications & Associations
Lesson 07: Project Management Certifications & Project Apps
2:46
Review project management certifications and professional organizations for career development.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Project Management Apps
Lesson 07: Project Management Certifications & Project Apps
1:47
Evaluate project management tools and software for planning, tracking, and collaboration.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 07: Project Management Certifications & Project Apps
0:10
Apply project management skills to future work for improved outcomes and career growth.
View enrollment options 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
Data Analytics Foundations Course Online (Self-Paced)
-
Central Tendency
Lesson 1: Basic Data Analysis
10:00
Explain measures of central tendency, including mean, median, mode, and mid-range, using examples and Excel functions to analyze data distribution.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Mixed Reference
Lesson 1: Basic Data Analysis
5:50
Use mixed cell referencing to efficiently apply formulas across multiple cells by locking either columns or rows, enabling quick calculations in spreadsheets.
View enrollment options at Noble Desktop -
Enrollment required
Position
Lesson 1: Basic Data Analysis
15:05
Compare data using percentiles to rank positions and quartiles to divide data into four equal parts, visualizing results with box-and-whisker charts for risk assessment.
View enrollment options at Noble Desktop -
Enrollment required
Dispersion
Lesson 1: Basic Data Analysis
15:26
Explain measures of dispersion by using standard deviation and variance to describe how far data points fall from the mean.
View enrollment options at Noble Desktop -
Enrollment required
Normal Curve
Lesson 1: Basic Data Analysis
17:38
Create a bell curve using the normal distribution function by calculating the mean and standard deviation, and use z-scores to determine standard deviations from the mean.
View enrollment options at Noble Desktop -
Enrollment required
Descriptive Statistics
Lesson 1: Basic Data Analysis
13:46
Summarize descriptive statistics concepts such as skewness, kurtosis, and standard error, and demonstrate how to use Excel's analysis tool pack to generate relevant statistical calculations.
View enrollment options at Noble Desktop -
T Test
Lesson 2: Predictive Analytics I
10:00
Run a paired T-Test using the Data Analysis Toolpak in Excel to determine the significance of performance changes by comparing t-stat and p-values before and after an intervention.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Correlation
Lesson 2: Predictive Analytics I
16:28
Examine linear relationships between variables by calculating correlation coefficients, recognizing that correlation does not imply causation.
View enrollment options at Noble Desktop -
Enrollment required
Series Forecast
Lesson 2: Predictive Analytics I
6:09
Forecast future values using Excel's fill series tool for linear or exponential growth patterns.
View enrollment options at Noble Desktop -
Enrollment required
Forecasting
Lesson 2: Predictive Analytics I
17:23
Explore forecasting in Excel using methods like least sum of squares, exponential smoothing, and confidence intervals to predict future data based on historical trends.
View enrollment options at Noble Desktop -
Enrollment required
Regression
Lesson 2: Predictive Analytics I
8:41
Explain how to use linear regression and Excel tools to model and predict relationships between dependent and independent variables.
View enrollment options at Noble Desktop -
Enrollment required
Regression Analysis
Lesson 2: Predictive Analytics I
9:24
Calculate regression analysis using linear regression, predict future outcomes, and evaluate correlation strength with R-squared.
View enrollment options at Noble Desktop -
Enrollment required
Simple Linear Regression
Lesson 2: Predictive Analytics I
9:17
Estimate the relationship between variables using Excel's analysis tool pack to determine the least sum of squares regression equation, assess its predictive accuracy, and calculate the independent variable's contribution.
View enrollment options at Noble Desktop -
Enrollment required
Multiple Regression
Lesson 2: Predictive Analytics I
6:36
Perform a multiple regression analysis using the data analysis tool pack to identify the impact of employees, products, and advertising expenses on company revenue.
View enrollment options at Noble Desktop -
Histogram
Lesson 3: Data Visualization I
10:00
Create histograms by using the analysis tool pack to group data into intervals and visualize frequency distributions for categories and seniority levels.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Moving Averages
Lesson 3: Data Visualization I
7:40
Calculate different types of moving averages to smooth data and assess recent trends, including simple, weighted, and exponential methods.
View enrollment options at Noble Desktop -
Enrollment required
Charts
Lesson 3: Data Visualization I
7:53
Transform data into visual insights using stacked column, area, tree map, funnel, and pie charts for clear representation of values and relationships.
View enrollment options at Noble Desktop -
Probability 1
Lesson 4: Probability
10:00
Summarize the key points about probability, including concepts like zero to one range, law of large numbers, calculating probabilities using Excel's RAND function, and applications in games like card drawing and craps.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Probability 2
Lesson 4: Probability
13:34
Calculate probabilities and analyze independent versus dependent events, expected values, fair prices, and conditional probability.
View enrollment options at Noble Desktop -
Enrollment required
Binominal
Lesson 4: Probability
14:18
Calculate the probability of a specific number of successes in a fixed number of independent binary (success/failure) trials using binomial distribution.
View enrollment options at Noble Desktop -
Enrollment required
Poisson Distribution
Lesson 4: Probability
11:11
Calculate the probability of a specific number of events occurring within a fixed interval using the Poisson distribution.
View enrollment options at Noble Desktop -
Enrollment required
Monte Carlo
Lesson 4: Probability
12:25
Use Monte Carlo simulation to assess the likelihood of achieving a profit over $10,000 by modeling revenue and costs with variable distributions and calculating outcomes over 300 scenarios.
View enrollment options at Noble Desktop -
Enrollment required
Resampling
Lesson 4: Probability
12:15
Resample data by using techniques like RANDBETWEEN and VLOOKUP to fill in missing information and make statistical inferences, allowing for comparison and analysis despite incomplete data.
View enrollment options at Noble Desktop -
Enrollment required
Statistics
Lesson 4: Probability
9:30
Calculate weighted averages and total salaries with conditions using the SUMPRODUCT function alongside SUMIF as needed.
View enrollment options at Noble Desktop -
Scenario Manager
Lesson 5: Prescriptive Analytics I
10:00
Use Excel's Scenario Manager to create, edit, and summarize different financial scenarios, such as base, best-case, and worst-case scenarios, for revenue growth, profit margin, and price per earnings, and generate a summary report to compare their impacts on projected revenues and values.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Scenario Manager 2
Lesson 5: Prescriptive Analytics I
10:20
Use the Scenario Manager in Excel to create and analyze multiple hiring scenarios, summarizing the financial impact of hiring up to five new employees on company benefits.
View enrollment options at Noble Desktop -
Enrollment required
Solver 1
Lesson 5: Prescriptive Analytics I
11:46
Install Solver through Excel's add-ins, set objective and constraints, and use it to determine optimal production quantities for maximum profit.
View enrollment options at Noble Desktop -
Enrollment required
Solver 2
Lesson 5: Prescriptive Analytics I
4:29
Use Solver to abandon Project B to maximize net present value while keeping capital usage within available limits.
View enrollment options at Noble Desktop -
Enrollment required
Solver 3
Lesson 5: Prescriptive Analytics I
9:07
Attempt to use Excel Solver to optimize the route between cities for minimal travel distance, potentially reducing total miles from 18,275 to a lower value using GRG nonlinear or evolutionary techniques.
View enrollment options at Noble Desktop -
Pivot Tables
Lesson 6: Data Visualization II
10:00
Create and analyze pivot tables to summarize data, perform calculations, and visualize information using pivot charts and slicers for efficient data manipulation and interpretation.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Sparklines
Lesson 6: Data Visualization II
7:55
Visualize data trends using sparklines by inserting miniature, single-cell charts like lines, columns, or win/loss indicators to represent changes and highlight high or low points.
View enrollment options at Noble Desktop -
Enrollment required
Color Scales
Lesson 6: Data Visualization II
8:28
Apply color scales and icon sets to format cells based on their values, sort data in ascending or descending order, and use the percentile function to determine threshold values for conditional formatting.
View enrollment options at Noble Desktop
Generative AI with ChatGPT Online (Self-Paced)
-
Technology Fundamentals
Lesson 1: Fundamentals of Generative AI and ChatGPT
10:00
Explore how AI can act as a co-pilot to boost productivity, automate tasks, and enhance creativity through real-world examples like automation and problem solving.
This preview is temporarily unavailable. Please try again later.
-
Starting Your First Chat
Lesson 1: Fundamentals of Generative AI and ChatGPT
10:00
Set up an account, navigate the ChatGPT interface, and begin interacting with AI while understanding how responses are generated and saved.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Not Satisfied with Response
Lesson 1: Fundamentals of Generative AI and ChatGPT
5:20
Adjust outputs by using follow-ups, regenerating responses, and editing prompts to better control results and keep conversations organized.
View enrollment options at Noble Desktop -
Enrollment required
AI Models, Pricing Plans, and Disabling Training
Lesson 1: Fundamentals of Generative AI and ChatGPT
17:31
Compare AI models and pricing plans to understand how speed, complexity, and features impact performance and usage.
View enrollment options at Noble Desktop -
Ideas for How to Use ChatGPT
Lesson 2: Ideas for How You Can Use AI
10:00
Apply ChatGPT to tasks like writing, research, brainstorming, summarizing, and problem solving to improve efficiency in real-world scenarios.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Using Canvas
Lesson 2: Ideas for How You Can Use AI
7:14
Use Canvas to co-write and edit content with AI by combining direct editing with AI-assisted revisions in a flexible workspace.
View enrollment options at Noble Desktop -
Prompt Frameworks Prompt Engineering
Lesson 3: Prompt Engineering and What to Watch Out For
10:00
Structure prompts using frameworks like role, instruction, context, and constraints to generate more accurate and useful outputs.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Things to Watch Out For Copyright & Legal Implications
Lesson 3: Prompt Engineering and What to Watch Out For
17:16
Recognize issues like hallucinations, bias, and copyright concerns while learning when to verify AI-generated content.
View enrollment options at Noble Desktop -
Data Analysis
Lesson 4: Data Analysis with ChatGPT
10:00
Upload datasets, generate insights, and create visualizations while understanding how AI uses tools like Python for accurate analysis.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Image Generation
Lesson 5: Creating Images with AI
19:24
Generate and refine images by writing detailed prompts and iterating on outputs to achieve more precise visual results.
View enrollment options at Noble Desktop -
Use ChatGPT to Improve Your Prompts
Lesson 6: Smarter Prompts, Personalization, and Using AI in Your Job
8:07
Strengthen prompt quality by having ChatGPT act as a prompt engineer, asking clarifying questions and refining inputs to produce more consistent and effective results.
This preview is temporarily unavailable. Please try again later.
-
Using AI in Your Job
Lesson 6: Smarter Prompts, Personalization, and Using AI in Your Job
2:08
Analyze daily tasks and workflows by describing your role in detail and using ChatGPT to generate tailored ideas for improving efficiency and solving real job-specific challenges.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Personalize ChatGPT & Memory
Lesson 6: Smarter Prompts, Personalization, and Using AI in Your Job
12:45
Configure custom instructions, preferences, and memory settings to tailor responses, reduce repetitive prompting, and create a more personalized AI experience over time.
View enrollment options at Noble Desktop -
Enrollment required
Voice and Vision
Lesson 6: Smarter Prompts, Personalization, and Using AI in Your Job
7:47
Interact with ChatGPT using voice and camera features to enable hands-free conversations, real-time problem solving, and visual recognition for more dynamic workflows.
View enrollment options at Noble Desktop -
Enrollment required
Course Conclusion
Lesson 6: Smarter Prompts, Personalization, and Using AI in Your Job
10:16
Adopt a strategic mindset by treating AI as a co-pilot, focusing on critical thinking, evaluation, and creativity to maximize impact while avoiding over-reliance.
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
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
Power BI Bootcamp (Self-Paced)
-
Course Overview & Setup
Lesson 1: Getting Started with Power BI
0:55
Introduces the structure of the Power BI course and explains how to use class files, PDFs, and step-by-step guides to build skills progressively.
This preview is temporarily unavailable. Please try again later.
-
Overview of Power BI
Lesson 1: Getting Started with Power BI
10:00
Explains what Power BI is, how it’s used for business intelligence, and how it compares to Excel, including an overview of Desktop, Service, and mobile access.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Installing the Power BI Desktop app
Lesson 1: Getting Started with Power BI
1:14
Walks through installing Power BI Desktop via the Microsoft Store, explaining update cycles and how to launch the application.
View enrollment options at Noble Desktop -
Enrollment required
Create our First Visualization
Lesson 1: Getting Started with Power BI
16:02
Demonstrates importing data and creating basic visuals like tables and column charts while explaining data types and automatic visual suggestions.
View enrollment options at Noble Desktop -
Enrollment required
Publishing and Sharing Reports
Lesson 1: Getting Started with Power BI
10:35
Covers publishing reports to the Power BI Service, including workspaces, sharing options, licensing, and browser-based access.
View enrollment options at Noble Desktop -
Enrollment required
Managing Links to Data Source Files & Refreshing Data
Lesson 1: Getting Started with Power BI
2:15
Explains how Power BI connects to external data sources rather than embedding files and how to manage paths and refresh data.
View enrollment options at Noble Desktop -
Transforming Data
Lesson 2: Transforming Data Using Power Query
10:00
Introduces Power Query for data transformation, including cleaning data, handling missing values, and improving performance through upstream changes.
This preview is temporarily unavailable. Please try again later.
-
Merge Queries
Lesson 2: Transforming Data Using Power Query
10:00
Explains merging tables in Power Query to combine related data and introduces normalized data concepts and lookup tables.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Append Queries
Lesson 2: Transforming Data Using Power Query
8:13
Demonstrates appending queries to combine multiple tables with the same structure into a single dataset.
View enrollment options at Noble Desktop -
Enrollment required
Fill and Transpose
Lesson 2: Transforming Data Using Power Query
5:16
Covers advanced transformations such as fill down and transpose to correct poorly structured data.
View enrollment options at Noble Desktop -
Enrollment required
Unpivot & Merge Columns
Lesson 2: Transforming Data Using Power Query
10:26
Demonstrates unpivoting data, combining date fields, assigning correct data types, and preparing datasets for time-based analysis.
View enrollment options at Noble Desktop -
Enrollment required
Query Dependencies
Lesson 2: Transforming Data Using Power Query
1:43
Explores Query Dependencies to visualize how data sources and transformations connect and to troubleshoot complex models.
View enrollment options at Noble Desktop -
Enrollment required
Getting Data from Multiple Files in a Folder (Appending from Folder)
Lesson 2: Transforming Data Using Power Query
4:59
Demonstrates importing and automatically appending files from a folder to support scalable data updates.
View enrollment options at Noble Desktop -
Relationships
Lesson 3: Building the Adventure Works Report
10:00
Explains creating relationships between fact and dimension tables and introduces star schema modeling.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Importing Data and Building Relationships
Lesson 3: Building the Adventure Works Report
10:00
Walks through building a relational model using AdventureWorks data and validating automatically detected relationships.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Designing and Building the Report
Lesson 3: Building the Adventure Works Report
7:20
Focuses on report design using text boxes, images, alignment tools, and layout best practices for professional presentations.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works Intro to DAX Adding the Current Date
Lesson 3: Building the Adventure Works Report
7:22
Introduces DAX by creating a simple date measure and explains the difference between measures and calculated columns.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works DAX Calculated Columns Profit or Loss
Lesson 3: Building the Adventure Works Report
14:04
Demonstrates creating calculated columns with DAX and using relationships and the RELATED function across tables.
View enrollment options at Noble Desktop -
Adventure Works Removing the Default White Background from VIsuals by editing the Theme
Lesson 4: Visuals, Slicers, and More
2:00
Shows how to customize Power BI themes to remove default styling and apply consistent global design changes.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Adding more visuals
Lesson 4: Visuals, Slicers, and More
3:17
Builds additional visuals to analyze sales by customer attributes while demonstrating interactive filtering.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Slicers
Lesson 4: Visuals, Slicers, and More
20:24
Introduces slicers as interactive filters and demonstrates layout improvements and user-friendly labeling.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works SUM vs SUMX
Lesson 4: Visuals, Slicers, and More
12:01
Explains the difference between SUM and SUMX in DAX and why iterator functions are needed for row-level calculations.
View enrollment options at Noble Desktop -
Enrollment required
Adjusting a Desktop Report for Mobile Devices
Lesson 4: Visuals, Slicers, and More
2:58
Demonstrates optimizing reports for mobile using the mobile layout view and adjusting visuals for smaller screens.
View enrollment options at Noble Desktop -
Global Superstore Import Data, Define Relationships, and Create Visuals
Lesson 5: Building the Global Superstore Report
10:00
Walks through importing and modeling Global Superstore data to reinforce ETL and star schema concepts.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore Intro to Filters
Lesson 5: Building the Global Superstore Report
10:00
Introduces visual-, page-, and report-level filters and explains when filters are preferable to slicers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Top N Filter and Filter Across All Pages
Lesson 5: Building the Global Superstore Report
7:00
Demonstrates Top N filters to highlight best- and worst-performing items and explains how ties affect results.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Sales by Country Page
Lesson 5: Building the Global Superstore Report
9:27
Builds a multi-page report analyzing sales by country using slicers and geographic comparisons.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Edit Interactions
Lesson 5: Building the Global Superstore Report
4:16
Explains how to control visual interactions to compare filtered values against unfiltered totals.
View enrollment options at Noble Desktop -
Global Superstore Controlling Filtering with SUM and SUMX
Lesson 6: Diving Deeper into DAX
8:46
Demonstrates using SUM and SUMX to control whether calculations respect or ignore filters.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore CONCATENATEX, COUNT, and COUNTX
Lesson 6: Diving Deeper into DAX
7:42
Introduces CONCATENATEX, COUNT, and COUNTX for advanced aggregations and dynamic titles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore CALCULATE
Lesson 6: Diving Deeper into DAX
5:03
Explains how CALCULATE applies filters within DAX expressions to create reusable measures.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Matrix Visual with Conditional Formatting Icons and Data Bars
Lesson 6: Diving Deeper into DAX
4:10
Builds a matrix visual with conditional formatting to highlight performance trends at a glance.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Quick Measures
Lesson 6: Diving Deeper into DAX
7:21
Uses Quick Measures to generate common DAX calculations like YTD and YoY while keeping measures organized.
View enrollment options at Noble Desktop -
Global Superstore Maps
Lesson 7: Maps, Drill Down, and Drill Through
6:14
Creates map visuals with Azure Maps and explains data categorization and geographic field requirements.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Drill Down
Lesson 7: Maps, Drill Down, and Drill Through
10:41
Demonstrates drill-down using hierarchies to move between summary and detailed views.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Drill Through
Lesson 7: Maps, Drill Down, and Drill Through
6:21
Builds drill-through navigation between report pages while preserving filter context.
View enrollment options at Noble Desktop -
Global Superstore Scheduling Data Refreshes and Getting Data
Lesson 8: Refreshing Data, Dashboards & Databases
Explains local refresh versus scheduled refresh in the Power BI Service using OneDrive and shared models.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dashboards
Lesson 8: Refreshing Data, Dashboards & Databases
4:02
Explains how Power BI dashboards aggregate pinned visuals while linking back to underlying reports.
View enrollment options at Noble Desktop -
Enrollment required
Connecting to a Database
Lesson 8: Refreshing Data, Dashboards & Databases
4:00
Demonstrates connecting Power BI to databases like SQL Server and compares Import and DirectQuery modes.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 8: Refreshing Data, Dashboards & Databases
0:13
Encourages continued practice to improve efficiency, confidence, and the ability to build original Power BI reports.
View enrollment options at Noble Desktop
Figma Bootcamp (Self-Paced)
-
Overview & Setup
Lesson 1: Figma Fundamentals
1:10
Discover what this Figma design course covers and how to get the most out of the training videos and exercises.
This preview is temporarily unavailable. Please try again later.
-
Getting Started with Figma
Lesson 1: Figma Fundamentals
10:00
Learn how to create a Figma account and navigate the interface using either the browser or desktop app.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Designing on Grids & Layout Fundamentals
Lesson 1: Figma Fundamentals
29:43
Master grid-based design principles to keep content equally sized and consistently spaced across pages.
View enrollment options at Noble Desktop -
Enrollment required
Working with Photos & Pixel Based Graphics
Lesson 1: Figma Fundamentals
27:16
Import photos and pixel-based images into your Figma designs using prepared layout files.
View enrollment options at Noble Desktop -
Enrollment required
Vector Graphics, Colors & Effects
Lesson 1: Figma Fundamentals
30:11
Bring in vector graphics and apply colors, color styles, and effects like drop shadows to enhance your layouts.
View enrollment options at Noble Desktop -
Introduction to Components & Auto Layout
Lesson 2: Components & Prototyping
10:00
Explore Figma's component system and get an introductory look at auto layout for reusable design elements.
This preview is temporarily unavailable. Please try again later.
-
Prototyping Interactive Designs
Lesson 2: Components & Prototyping
10:00
Turn static designs into clickable, interactive prototypes that simulate real user experiences.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Sharing, Exporting & Collaboration
Lesson 2: Components & Prototyping
29:42
Share finished designs with teammates, stakeholders, and developers using Figma's collaboration features.
View enrollment options at Noble Desktop -
Understanding Auto Layout
Lesson 3: Deep Dives
10:00
Dive deeper into auto layout to understand how automatic sizing and spacing work in Figma.
This preview is temporarily unavailable. Please try again later.
-
Advanced Auto Layout Techniques
Lesson 3: Deep Dives
10:00
Master nested auto layout frames with different directions, padding, and spacing settings for complex layouts.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Prototype Scrolling & Hyperlinks
Lesson 3: Deep Dives
18:54
Configure vertical and horizontal scrolling within prototypes for long pages and scrollable sections.
View enrollment options at Noble Desktop -
Enrollment required
Typography Styles & Sketch File Import
Lesson 3: Deep Dives
13:58
Create and manage reusable type styles to maintain consistent typography across your designs.
View enrollment options at Noble Desktop -
Component Properties & Design Systems
Lesson 4: Advanced Features
10:00
Leverage component properties to build flexible, reusable elements that scale into a design system.
This preview is temporarily unavailable. Please try again later.
-
Hover States, Overlays & Smart Animate
Lesson 4: Advanced Features
10:00
Design hover effects and overlay interactions for desktop interfaces using Figma's prototyping tools.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Team Libraries & Shared Design Systems
Lesson 4: Advanced Features
20:23
Set up team libraries to share styles and components across multiple files and users in your organization.
View enrollment options at Noble Desktop -
Enrollment required
Wrap Up & Next Steps
Lesson 4: Advanced Features
0:12
Review key takeaways from the Figma course and get encouragement to continue practicing.
View enrollment options at Noble Desktop
SEO Bootcamp (Self-Paced)
-
SEO Basics
Lesson 1: SEO Foundations & Search Engines
5:57
Define SEO and understand how it improves website visibility through content, technical optimization, and authority. Explore how search engines evolved and why modern SEO focuses on relevance and user experience.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Search Engines & SEO Pillars
Lesson 1: SEO Foundations & Search Engines
9:54
Identify the major search engines and understand why Google dominates. Break down the three pillars of SEO and connect them to rankings, traffic, and business results.
View enrollment options at Noble Desktop -
Types of Keywords
Lesson 2: Keyword Research & Strategy
10:00
Define keywords and explore key types including short-tail, long-tail, branded, and transactional terms. Understand how each type supports search visibility and conversion potential.
This preview is temporarily unavailable. Please try again later.
-
Search Intent & Keyword Strategy
Lesson 2: Keyword Research & Strategy
9:09
Analyze user intent and connect it to keyword selection for stronger SEO results. Build a keyword strategy by researching audiences, competitors, and relevant search topics.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Using Google Tools for Keyword Research
Lesson 2: Keyword Research & Strategy
5:59
Explore Google Search Console and Google Trends to identify search queries, track keyword performance, and analyze trends across regions and time.
View enrollment options at Noble Desktop -
Enrollment required
Keyword Research with SEMrush
Lesson 2: Keyword Research & Strategy
11:44
Use SEMrush to discover keyword variations, analyze search volume and difficulty, and evaluate opportunities based on intent and competition.
View enrollment options at Noble Desktop -
Competitive Analysis Basics
Lesson 3: Competitive SEO Analysis
9:18
Identify key competitors and evaluate their websites, content, and positioning to uncover opportunities for differentiation and keyword strategy. Use frameworks to assess strengths, weaknesses, and market roles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Keyword Gap Analysis with SEMrush
Lesson 3: Competitive SEO Analysis
8:37
Compare your keyword profile with competitors using SEMrush to identify shared, missing, and high-value keywords. Analyze rankings, difficulty, and opportunities to improve search performance.
View enrollment options at Noble Desktop -
What is SEO Content?
Lesson 4: SEO Content Strategy
10:00
Define SEO content and explore how optimized, user-friendly content improves search rankings and engagement. Identify key content types and best practices for structure, relevance, and performance.
This preview is temporarily unavailable. Please try again later.
-
Creating SEO Content
Lesson 4: SEO Content Strategy
8:00
Understand your audience, apply keyword research, and create high-quality content that meets user needs and drives engagement. Optimize on-page elements and use performance data to refine content strategy.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Content & the Customer Journey
Lesson 4: SEO Content Strategy
9:45
Connect SEO content to each stage of the customer journey, from awareness to conversion and beyond. Use targeted content to guide users, build trust, and encourage long-term engagement.
View enrollment options at Noble Desktop -
Enrollment required
SEO Content Planning Exercise
Lesson 4: SEO Content Strategy
5:34
Apply keyword research to develop a structured blog outline and plan optimized content. Use tools and AI to generate ideas while guiding the process with clear strategy and intent.
View enrollment options at Noble Desktop -
On Page SEO Fundamentals
Lesson 5: On-Page SEO Optimization
4:03
Define on-page SEO and understand key elements like heading tags, title tags, and page structure. Use these components to improve content relevance and search performance.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Meta Descriptions & SERP Optimization
Lesson 5: On-Page SEO Optimization
4:31
Understand how meta descriptions influence click-through rates and search visibility. Write summaries that align with user intent and encourage engagement across search and social platforms.
View enrollment options at Noble Desktop -
Enrollment required
Optimizing Metadata & Site Maps
Lesson 5: On-Page SEO Optimization
9:51
Create effective metadata using keywords, length guidelines, and clear value propositions. Use sitemaps and structured page elements to improve indexing and overall site performance.
View enrollment options at Noble Desktop -
Off Page SEO & Backlinks
Lesson 6: Off-Page SEO & Link Building
9:50
Define off-page SEO and understand how backlinks, authority, and external signals impact search rankings. Apply best practices for building high-quality, relevant links that improve credibility and visibility.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Backlink Tools & Analysis
Lesson 6: Off-Page SEO & Link Building
5:38
Use tools like Google Search Console and SEMrush to track backlinks, measure authority, and identify link-building opportunities. Analyze competitor strategies to strengthen your own backlink profile.
View enrollment options at Noble Desktop -
Website Structure & SEO
Lesson 7: Technical SEO Essentials
5:11
Organize website structure to improve crawling, indexing, and user experience. Apply best practices for hierarchy, navigation, and accessibility to support stronger search performance.
This preview is temporarily unavailable. Please try again later.
-
Designing User Friendly Navigation
Lesson 7: Technical SEO Essentials
5:35
Create intuitive navigation by aligning content with user needs and simplifying structure. Use mobile-friendly layouts, clear hierarchy, and visual cues to improve usability.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Rich Snippets & Search Results
Lesson 7: Technical SEO Essentials
10:15
Enhance visibility with rich search results like reviews, images, and local listings. Understand how these features improve click-through rates and user engagement.
View enrollment options at Noble Desktop -
Enrollment required
Structured Data Fundamentals
Lesson 7: Technical SEO Essentials
13:12
Implement structured data to help search engines better understand and display content. Use schema markup to increase eligibility for rich results and improve search relevance.
View enrollment options at Noble Desktop -
Enrollment required
Creating Google Search Ads
Lesson 7: Technical SEO Essentials
14:04
Build effective Google text ads by selecting keywords, writing headlines, and structuring ad components. Use platform tools and AI suggestions to improve performance.
View enrollment options at Noble Desktop -
Enrollment required
Ad Policies & Best Practices
Lesson 7: Technical SEO Essentials
4:01
Follow advertising policies to ensure compliance and maintain account performance. Avoid deceptive practices and apply guidelines for targeting, content, and user experience.
View enrollment options at Noble Desktop -
Enrollment required
Mobile SEO & Optimization
Lesson 8: Mobile SEO Optimization
11:05
Understand why mobile SEO is essential and how responsive design, speed, and user experience impact rankings and conversions. Apply best practices to create mobile-friendly content and improve performance across devices.
View enrollment options at Noble Desktop -
Video SEO Fundamentals
Lesson 9: Video SEO & Optimization
8:09
Define video optimization and understand how content quality, metadata, and engagement impact rankings on platforms like YouTube. Analyze key performance factors such as watch time, thumbnails, and distribution.
This preview is temporarily unavailable. Please try again later.
-
Optimizing YouTube Videos
Lesson 9: Video SEO & Optimization
5:07
Apply keyword research to titles, descriptions, and tags while creating engaging thumbnails and content. Use playlists, captions, and engagement strategies to improve visibility and rankings.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Types of Video Content
Lesson 9: Video SEO & Optimization
7:00
Identify high-performing video formats such as tutorials, product demos, interviews, and testimonials. Align content with audience needs to build engagement and support different stages of the customer journey.
View enrollment options at Noble Desktop -
Enrollment required
Promoting & Analyzing Videos
Lesson 9: Video SEO & Optimization
6:37
Promote videos through social media, collaborations, and paid strategies while tracking performance with analytics. Use insights like click-through rate, watch time, and audience behavior to refine content.
View enrollment options at Noble Desktop -
SEO Audit Fundamentals
Lesson 10: SEO Audits & Analysis
10:00
Define SEO audits and analyze key areas like performance, indexing, user experience, and search queries using Google Search Console. Identify opportunities to improve click-through rates, rankings, and site health.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Using SEMrush for SEO Audits
Lesson 10: SEO Audits & Analysis
10:54
Conduct a comprehensive SEO audit using SEMrush to evaluate on-page, off-page, and technical performance. Interpret scores, identify critical issues, and apply recommendations to improve rankings and authority.
View enrollment options at Noble Desktop -
SEO KPIs & Metrics
Lesson 11: SEO Reporting & Performance
4:57
Track key SEO metrics such as organic traffic, keyword rankings, click-through rates, and bounce rate to evaluate performance. Use data over time to identify trends and measure the impact of optimization efforts.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Reading SEO Reports
Lesson 11: SEO Reporting & Performance
13:24
Interpret SEO reports by analyzing audience behavior, traffic sources, and keyword performance. Use insights from tools like Google Analytics to understand trends and refine strategy.
View enrollment options at Noble Desktop
Google Analytics Bootcamp (Self-Paced)
-
Introduction to Web Analytics and Google Analytics
Lesson 1: Introduction to Google Analytics
9:09
Gain a clear understanding of web analytics by exploring how website data is collected and analyzed, and discover how Google Analytics transforms this data into insights.
This preview is temporarily unavailable. Please try again later.
-
Using Google Analytics to Understand Visitor Behavior
Lesson 1: Introduction to Google Analytics
9:13
Explore the key questions Google Analytics can answer while learning how these insights connect to each stage of the buyer’s journey, including driving awareness, guiding consideration, improving conversions, and strengthening customer retention.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Creating a Google Analytics Measurement Plan
Lesson 2: Developing a Google Analytics Strategy
8:50
Learn the essentials of creating a Google Analytics measurement plan, including defining business objectives, identifying key performance indicators (KPIs), and selecting the right metrics and data sources.
View enrollment options at Noble Desktop -
Enrollment required
Aligning Business Objectives with Google Analytics Goals
Lesson 2: Developing a Google Analytics Strategy
11:34
Explore the roles different teams play in developing a measurement plan, from business leadership and marketing teams to IT specialists and compliance officers.
View enrollment options at Noble Desktop -
Enrollment required
Setting Up Your Google Analytics Account
Lesson 3: Best Practices for Setting Up a Google Analytics Account
11:38
Learn the step-by-step process of setting up a Google Analytics account, from creating an account to adding properties and configuring data streams, setting business objectives, selecting the appropriate platform, and implementing tracking codes to begin collecting data.
View enrollment options at Noble Desktop -
Best Practices for Configuring Google Analytics
Lesson 3: Best Practices for Setting Up a Google Analytics Account
10:00
Explore best practices for configuring and managing Google Analytics accounts, including user roles, data collection settings, and key configurations.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Implementing Filters in Google Analytics for Clean Data
Lesson 4: Introduction to Filters
7:03
Learn how to use filters in Google Analytics to exclude irrelevant traffic, such as internal or developer visits, create different types of filters, exclude specific IP addresses, and customize filters for tracking specific sections of a website or subdomains.
View enrollment options at Noble Desktop -
Enrollment required
Understanding Dimensions and Metrics in Google Analytics
Lesson 5: Dimensions and Metrics
7:23
Discover the fundamental concepts of dimensions and metrics in Google Analytics and learn how to combine qualitative and quantitative data to analyze user behavior, traffic sources, engagement, and conversions.
View enrollment options at Noble Desktop -
Enrollment required
Building Audiences in Google Analytics
Lesson 6: Creating Audiences
7:50
Learn how to create and use audiences in Google Analytics for targeting and remarketing, understand the differences between audiences and segments, and define custom audiences based on behavior, demographics, and traffic sources.
View enrollment options at Noble Desktop -
Enrollment required
Using Google Ads Audiences for Remarketing
Lesson 6: Creating Audiences
13:13
Dive deeper into creating audiences for marketing campaigns and remarketing using Google Ads, including building audiences from scratch, modifying templates, and selecting suggested audiences.
View enrollment options at Noble Desktop -
Enrollment required
Tracking Key Events in Google Analytics
Lesson 7: Key Event Tracking
7:24
Learn about key event tracking in Google Analytics for monitoring important user actions such as conversions, form submissions, video views, ecommerce transactions, app installations, and content interactions.
View enrollment options at Noble Desktop -
Enrollment required
Creating Custom Key Events in Google Analytics
Lesson 7: Key Event Tracking
9:06
Dive into creating custom key events in Google Analytics by defining specific actions such as downloads or form completions, setting parameters, and marking events correctly for accurate reporting.
View enrollment options at Noble Desktop -
Enrollment required
Navigating the Google Analytics Dashboard
Lesson 8: Google Analytics Reporting
11:15
Learn how to navigate the Google Analytics dashboard as a central hub for accessing key metrics and reports.
View enrollment options at Noble Desktop -
Understanding Audience Reports in Google Analytics
Lesson 8: Google Analytics Reporting
10:00
Explore audience reports in Google Analytics to analyze sessions, page views, bounce rates, engagement, demographic data, geographic insights, and behavioral trends.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Acquisition Reports: Where Are Your Visitors Coming From?
Lesson 8: Google Analytics Reporting
7:52
Examine acquisition reports to understand how visitors arrive at a website, including organic search, paid search, social media, direct traffic, and referrals.
View enrollment options at Noble Desktop -
Enrollment required
Behavior Reports: How Users Interact with Your Website
Lesson 8: Google Analytics Reporting
6:26
Gain insights into user behavior through behavioral reports by analyzing page views, time on site, bounce rate, and exit rate to identify high-performing pages and optimize user experience.
View enrollment options at Noble Desktop -
Enrollment required
Conversion Reports: Measuring Success on Your Website
Lesson 8: Google Analytics Reporting
10:18
Explore conversion reports that track website goals and key marketing objectives such as sales, form submissions, and other valuable user actions.
View enrollment options at Noble Desktop -
Enrollment required
Retention Reports: Keeping Users Engaged Over Time
Lesson 8: Google Analytics Reporting
10:32
Understand how retention reports provide insights into user engagement over time by analyzing cohorts based on first interactions and tracking behavior across set periods.
View enrollment options at Noble Desktop -
Enrollment required
Traffic Acquisition: Analyzing Sources and Campaign Effectiveness
Lesson 8: Google Analytics Reporting
9:07
Discover how to use detailed traffic acquisition reports to evaluate which channels and campaigns drive the most engagement and conversions, compare performance metrics, and optimize underperforming sources.
View enrollment options at Noble Desktop -
Introduction to UTM Tracking and Campaign Performance
Lesson 9: UTM Code Tracking
8:55
Discover how to use UTM parameters such as source, medium, campaign, term, and content to analyze marketing performance across channels and campaigns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Best Practices for Using UTM Parameters
Lesson 9: UTM Code Tracking
6:42
Explore best practices for using UTM parameters, including consistent naming conventions, avoiding overuse, and ensuring clear, reliable tracking data.
View enrollment options at Noble Desktop