Skip to main content

“MBA” Business Certificate (NYC or Online)

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

Choose how you learn

Compare formats, then explore the details for your choice.

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

Book live on Noble Desktop

Summary

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.

Explore format options

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

  1. 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
  2. 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)
  3. 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
  4. 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
  5. 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.
  6. 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.
  7. 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.
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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.
  18. 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.
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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.

Book live on Noble Desktop
  • 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.

Book self-paced on Noble Desktop
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

  1. 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
  2. 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)
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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.
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • Budgets and Costs

    Lesson 2: Budgets & Costs

    8:19

    Understand key project cost components, including resources, risk reserves, and quality-related expenses.

  • 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.

  • 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.

  • 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.

  • 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.

  • Enrollment required

    Rows and Columns

    Lesson 1: Introduction

    6:02

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

    View enrollment options at Noble Desktop
  • Autofill

    Lesson 2: Formulas

    9:07

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

  • Enrollment required

    Data Entry

    Lesson 2: Formulas

    5:13

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Calculations

    Lesson 2: Formulas

    10:16

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Autosum Functions

    Lesson 2: Formulas

    9:58

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Text Functions

    Lesson 2: Formulas

    8:04

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

    View enrollment options at Noble Desktop
  • Enrollment required

    True False

    Lesson 2: Formulas

    7:14

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Absolute Cell References

    Lesson 2: Formulas

    10:07

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Multi Input Functions

    Lesson 2: Formulas

    12:37

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Formatting

    Lesson 3: Formatting

    14:04

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Conditional Formatting

    Lesson 3: Formatting

    9:30

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

    View enrollment options at Noble Desktop
  • Line Chart

    Lesson 4: Charts & Tables

    5:34

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

  • Enrollment required

    Column Chart

    Lesson 4: Charts & Tables

    7:53

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Trendlines

    Lesson 4: Charts & Tables

    3:05

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pie Chart

    Lesson 4: Charts & Tables

    7:27

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Tables

    Lesson 4: Charts & Tables

    13:52

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

    View enrollment options at Noble Desktop
  • Printing

    Lesson 5: Workbook Management

    10:00

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

  • Enrollment required

    Worksheets

    Lesson 5: Workbook Management

    7:04

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Freeze Panes

    Lesson 5: Workbook Management

    5:03

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Excel Tricks

    Lesson 5: Workbook Management

    9:14

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

    View enrollment options at Noble Desktop

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

  • Enrollment required

    Tips and Fundamentals

    Lesson 5: Workbook Management

    10:24

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

    View enrollment options at Noble Desktop
  • Navigation

    Lesson 1: Worksheet Management

    6:58

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

  • Enrollment required

    Paste Special

    Lesson 2: Working with Text

    8:55

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Paste Special Values

    Lesson 2: Working with Text

    3:14

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Splitting Text

    Lesson 2: Working with Text

    5:08

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Joining Text

    Lesson 2: Working with Text

    5:06

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Named Ranges

    Lesson 3: Cell Ranges

    3:56

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

    View enrollment options at Noble Desktop
  • Data Validation

    Lesson 4: Database Functions

    7:35

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

  • Enrollment required

    Remove Duplicates

    Lesson 4: Database Functions

    3:51

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

    View enrollment options at Noble Desktop
  • Enrollment required

    VLOOKUP

    Lesson 4: Database Functions

    10:06

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

    View enrollment options at Noble Desktop
  • Enrollment required

    HLOOKUP

    Lesson 4: Database Functions

    2:58

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Sort and Filter

    Lesson 4: Database Functions

    15:53

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

    View enrollment options at Noble Desktop
  • Pivot Tables New

    Lesson 5: Pivot Tables

    10:00

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

  • Enrollment required

    Pivot Grouping Timelines

    Lesson 5: Pivot Tables

    5:16

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Multiple Pivot Tables

    Lesson 5: Pivot Tables

    11:40

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

    View enrollment options at Noble Desktop
  • If Statements

    Lesson 6: Logical Functions

    8:30

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

  • Enrollment required

    And Or

    Lesson 6: Logical Functions

    6:17

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

    View enrollment options at Noble Desktop
  • COUNTIFS and SUMIFS

    Lesson 7: Statistical Functions

    9:46

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

  • Enrollment required

    Combo Charts

    Lesson 8: Advanced Charts

    5:01

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

    View enrollment options at Noble Desktop

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

  • Advanced Cell Lock

    Lesson 1: Cell Management

    10:00

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

  • Enrollment required

    Hot Keys

    Lesson 1: Cell Management

    7:14

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Go To Special

    Lesson 1: Cell Management

    8:51

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

    View enrollment options at Noble Desktop
  • Date Functions

    Lesson 2: Special Formatting

    7:29

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

  • Enrollment required

    Adv Conditional Formatting

    Lesson 2: Special Formatting

    9:35

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Nested IFs

    Lesson 2: Special Formatting

    9:37

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

    View enrollment options at Noble Desktop
  • If AND OR

    Lesson 3: Advanced Functions

    7:43

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

  • Enrollment required

    Goal Seek

    Lesson 4: What If Analysis

    4:18

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Data Tables

    Lesson 4: What If Analysis

    7:32

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

    View enrollment options at Noble Desktop
  • Conditional Sumproduct

    Lesson 5: Advanced Analytical Tools

    9:48

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

  • Enrollment required

    Pivot Table Variances

    Lesson 5: Advanced Analytical Tools

    6:17

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pivot Calculations

    Lesson 5: Advanced Analytical Tools

    10:22

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pivot Charts

    Lesson 5: Advanced Analytical Tools

    6:05

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

    View enrollment options at Noble Desktop
  • Match Function

    Lesson 6: Advanced Database Functions

    4:25

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

  • Enrollment required

    Vlookup Match

    Lesson 6: Advanced Database Functions

    8:08

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Index Match

    Lesson 6: Advanced Database Functions

    7:02

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Index Double Match

    Lesson 6: Advanced Database Functions

    7:07

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Windows

    Lesson 6: Advanced Database Functions

    6:56

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Working Across Sheets

    Lesson 6: Advanced Database Functions

    4:38

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

    View enrollment options at Noble Desktop
  • Macros

    Lesson 7: Introduction to Macros

    8:29

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

  • Enrollment required

    MacrosReport

    Lesson 7: Introduction to Macros

    6:14

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Consolidation

    Lesson 8: Dynamic Arrays

    5:10

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

    View enrollment options at Noble Desktop

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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • Enrollment required

    Variables

    Lesson 1: Python for Data Science Fundamentals

    21:19

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Integer and Decimal

    Lesson 1: Python for Data Science Fundamentals

    20:07

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Input Function

    Lesson 1: Python for Data Science Fundamentals

    8:30

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Input Function Part 2

    Lesson 1: Python for Data Science Fundamentals

    4:39

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Round Function

    Lesson 1: Python for Data Science Fundamentals

    6:00

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Cafe Bill Challenge Solution

    Lesson 1: Python for Data Science Fundamentals

    14:12

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Boolean

    Lesson 1: Python for Data Science Fundamentals

    5:32

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

    View enrollment options at Noble Desktop
  • Enrollment required

    List Data Type

    Lesson 1: Python for Data Science Fundamentals

    15:52

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Methods Functions

    Lesson 1: Python for Data Science Fundamentals

    18:45

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Set & Vector Operation

    Lesson 1: Python for Data Science Fundamentals

    14:37

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

    View enrollment options at Noble Desktop
  • If Else Logic

    Lesson 2: Boolean Conditions

    4:43

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

  • Enrollment required

    If Else Logic Challenge Solution

    Lesson 2: Boolean Conditions

    16:35

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

    View enrollment options at Noble Desktop
  • Datetime Part 1

    Lesson 3: Datetime & Random

    10:28

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

  • Enrollment required

    Datetime Part 2

    Lesson 3: Datetime & Random

    11:35

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Random Module

    Lesson 3: Datetime & Random

    20:22

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

    View enrollment options at Noble Desktop
  • Loops

    Lesson 4: Loops & Strings

    4:29

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

  • Enrollment required

    Loop the Nums List Challenge

    Lesson 4: Loops & Strings

    9:17

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

    View enrollment options at Noble Desktop
  • Enrollment required

    List Methods Review Part 1

    Lesson 4: Loops & Strings

    13:11

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

    View enrollment options at Noble Desktop
  • Enrollment required

    List Methods Review Part 2

    Lesson 4: Loops & Strings

    9:03

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Loop Method Exercise

    Lesson 4: Loops & Strings

    10:23

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Loop Challenges

    Lesson 4: Loops & Strings

    9:37

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

    View enrollment options at Noble Desktop
  • Enrollment required

    In and Not In Operators

    Lesson 4: Loops & Strings

    16:23

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

    View enrollment options at Noble Desktop
  • Enrollment required

    String Methods

    Lesson 4: Loops & Strings

    34:06

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Nested Loop

    Lesson 4: Loops & Strings

    11:01

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

    View enrollment options at Noble Desktop
  • Dictionaries Part 1

    Lesson 5: Dictionaries

    10:16

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

  • Enrollment required

    Dictionaries Part 2

    Lesson 5: Dictionaries

    10:39

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Dictionaries Scrabble Exercise

    Lesson 5: Dictionaries

    13:11

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

    View enrollment options at Noble Desktop
  • Numpy

    Lesson 6: Numpy

    4:33

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

  • Enrollment required

    Numpy Array

    Lesson 6: Numpy

    18:34

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

    View enrollment options at Noble Desktop
  • Enrollment required

    2D Selections with Numpy Array

    Lesson 6: Numpy

    18:27

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

    View enrollment options at Noble Desktop
  • Pandas Dataframes Part 1

    Lesson 7: Pandas Dataframes

    5:21

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

  • Enrollment required

    Pandas Dataframes Part 2

    Lesson 7: Pandas Dataframes

    10:18

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 3

    Lesson 7: Pandas Dataframes

    14:01

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 4

    Lesson 7: Pandas Dataframes

    12:21

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 5

    Lesson 7: Pandas Dataframes

    6:51

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pandas Dataframes Part 6

    Lesson 7: Pandas Dataframes

    12:17

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Dataframes Location

    Lesson 7: Pandas Dataframes

    16:20

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Select Rows by Condition

    Lesson 7: Pandas Dataframes

    24:16

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

    View enrollment options at Noble Desktop
  • Enrollment required

    AT & IAT

    Lesson 7: Pandas Dataframes

    13:29

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Dataframes from Dictionary

    Lesson 7: Pandas Dataframes

    25:15

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Dataframes Challenges

    Lesson 7: Pandas Dataframes

    6:28

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

    View enrollment options at Noble Desktop
  • Enrollment required

    String Split

    Lesson 7: Pandas Dataframes

    12:39

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Select and Filter by Condition

    Lesson 7: Pandas Dataframes

    21:09

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Vector Operations

    Lesson 7: Pandas Dataframes

    9:16

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

    View enrollment options at Noble Desktop
  • Introduction to Matplotlib

    Lesson 8: Bar Charts with Matplotlib

    14:46

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

  • Enrollment required

    Python Data Selection

    Lesson 8: Bar Charts with Matplotlib

    18:01

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Data Visualization with Matplotlib

    Lesson 8: Bar Charts with Matplotlib

    21:21

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

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

    Lesson 9: Line & Scatter Charts with Matplotlib

    13:56

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

  • Enrollment required

    Linear Regression with Matplotlib

    Lesson 9: Line & Scatter Charts with Matplotlib

    26:39

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

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

    Lesson 10: Pivot Population Data & Charts

    9:59

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

  • Enrollment required

    Data Cleaning

    Lesson 10: Pivot Population Data & Charts

    27:01

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Two Different Ways to Make a Bar Chart

    Lesson 10: Pivot Population Data & Charts

    18:52

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Pivoting the Data

    Lesson 10: Pivot Population Data & Charts

    16:20

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

    View enrollment options at Noble Desktop
  • Enrollment required

    There is Always Time for Pie (Charts)

    Lesson 10: Pivot Population Data & Charts

    10:54

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Animated Bar Chart Race

    Lesson 10: Pivot Population Data & Charts

    13:10

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

    View enrollment options at Noble Desktop

Tableau Course Online (Self-Paced)

  • Requirements & Getting Started

    Lesson 1: Getting Started With Tableau

    9:58

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

  • Enrollment required

    Introduction to Tableau

    Lesson 1: Getting Started With Tableau

    8:26

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Understanding Data

    Lesson 1: Getting Started With Tableau

    14:47

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Foundations for Building Data Visualizations

    Lesson 1: Getting Started With Tableau

    6:13

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Tableau Versions

    Lesson 1: Getting Started With Tableau

    7:06

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Workflow & Chart Types

    Lesson 1: Getting Started With Tableau

    4:57

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

    View enrollment options at Noble Desktop
  • Working with your Data

    Lesson 1: Getting Started With Tableau

    7:52

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

  • Enrollment required

    Creating your First Visualization

    Lesson 1: Getting Started With Tableau

    6:14

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Previewing your Data in the Source Menu

    Lesson 1: Getting Started With Tableau

    9:25

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Quickly Creating a Visualization

    Lesson 2: Creating Visualizations

    8:44

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Data Visualization Basics

    Lesson 2: Creating Visualizations

    10:29

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

    View enrollment options at Noble Desktop
  • Enrollment required

    The Tableau Interface

    Lesson 2: Creating Visualizations

    16:35

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Pie Chart

    Lesson 2: Creating Visualizations

    13:33

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Bar or Column Chart

    Lesson 2: Creating Visualizations

    10:32

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

    View enrollment options at Noble Desktop
  • Swap Rows and Columns

    Lesson 2: Creating Visualizations

    3:59

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

  • Enrollment required

    Adding a Sub Category

    Lesson 2: Creating Visualizations

    5:54

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Sorting and Saving

    Lesson 2: Creating Visualizations

    3:07

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

    View enrollment options at Noble Desktop
  • Organizing the Data Sidebar

    Lesson 3: Organizing Data

    6:53

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

  • Enrollment required

    Sets

    Lesson 3: Organizing Data

    15:39

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Groups

    Lesson 3: Organizing Data

    14:14

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Labels

    Lesson 3: Organizing Data

    5:50

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Tool Tips

    Lesson 3: Organizing Data

    12:22

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Measures

    Lesson 3: Organizing Data

    7:29

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Marks Card

    Lesson 3: Organizing Data

    5:49

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

    View enrollment options at Noble Desktop
  • Tableau Calculations

    Lesson 4: Calculations and Dashboards

    8:37

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

  • Enrollment required

    Pages

    Lesson 4: Calculations and Dashboards

    8:21

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Dashboards Part 1

    Lesson 4: Calculations and Dashboards

    14:05

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Dashboards Part 2

    Lesson 4: Calculations and Dashboards

    8:25

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating Stories

    Lesson 4: Calculations and Dashboards

    2:54

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

    View enrollment options at Noble Desktop
  • Data Interpreter

    Lesson 5: Data Interpreter

    10:00

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

  • Enrollment required

    Life Expectancy Exercise

    Lesson 5: Data Interpreter

    8:42

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Life Expectancy Exercise Solution

    Lesson 5: Data Interpreter

    7:34

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

    View enrollment options at Noble Desktop
  • Creating Multi Chart Worksheets

    Lesson 6: Multi-Chart Worksheets

    10:00

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

  • Enrollment required

    Dual Axis & Combo Chart

    Lesson 6: Multi-Chart Worksheets

    8:50

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Better Line Chart

    Lesson 6: Multi-Chart Worksheets

    17:50

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Butterfly Chart Part 1

    Lesson 6: Multi-Chart Worksheets

    8:48

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Butterfly Chart Part 2

    Lesson 6: Multi-Chart Worksheets

    10:58

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Formatting the Butterfly Chart

    Lesson 6: Multi-Chart Worksheets

    13:57

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

    View enrollment options at Noble Desktop
  • Creating State Selector

    Lesson 7: Parameters and Filtering

    10:00

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

  • Enrollment required

    Creating a Calculated Field

    Lesson 7: Parameters and Filtering

    15:26

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating a Parameter to Control a Filter

    Lesson 7: Parameters and Filtering

    11:06

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating an International Map Part 1

    Lesson 7: Parameters and Filtering

    12:12

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Creating an International Map Part 2

    Lesson 7: Parameters and Filtering

    8:18

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

    View enrollment options at Noble Desktop
  • Enrollment required

    More Chart Types

    Lesson 7: Parameters and Filtering

    12:13

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

    View enrollment options at Noble Desktop

SQL Course Online (Self-Paced)

  • Benefits of Learning SQL

    Lesson 1: Setting Up the Work Environment

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

  • Enrollment required

    Connecting to Our Database

    Lesson 1: Setting Up the Work Environment

    14:06

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

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

    Lesson 2: Let's Start Learning SQL Code

    7:29

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

  • Enrollment required

    Learning the SQL Language

    Lesson 2: Let's Start Learning SQL Code

    14:10

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Coding Exercise PostgreSQL

    Lesson 2: Let's Start Learning SQL Code

    18:29

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution PostgreSQL Challenge

    Lesson 2: Let's Start Learning SQL Code

    15:11

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

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

    Lesson 3: Working with Characters & Numbers

    4:44

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

  • Enrollment required

    Coding Exercise Filtering with WHERE

    Lesson 3: Working with Characters & Numbers

    5:34

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Filtering with WHERE

    Lesson 3: Working with Characters & Numbers

    22:42

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

    View enrollment options at Noble Desktop
  • Pattern Matching

    Lesson 4: Using SQL Wildcards

    4:46

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

  • Enrollment required

    Combining Filters and Aliases

    Lesson 4: Using SQL Wildcards

    4:32

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Coding Exercise Like and Wildcards

    Lesson 4: Using SQL Wildcards

    12:31

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Like and Wildcards

    Lesson 4: Using SQL Wildcards

    23:49

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

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

    Lesson 5: Indentifying Rows & Connecting Tables

    6:44

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

  • Enrollment required

    Joins Combining Data from Multiple Tables

    Lesson 5: Indentifying Rows & Connecting Tables

    12:28

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Exercise Inner Join

    Lesson 5: Indentifying Rows & Connecting Tables

    18:40

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Inner Join

    Lesson 5: Indentifying Rows & Connecting Tables

    10:36

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

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

    Lesson 6: Inner vs. Outer Joins

    9:45

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

  • Enrollment required

    Exercise Outer Join and NULL

    Lesson 6: Inner vs. Outer Joins

    23:37

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Outer Join and NULL

    Lesson 6: Inner vs. Outer Joins

    34:12

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

    View enrollment options at Noble Desktop
  • Cast

    Lesson 7: Changing Data Types

    7:07

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

  • Enrollment required

    Aggregate Functions

    Lesson 7: Changing Data Types

    6:33

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Exercise Aggregate Function and ROUND

    Lesson 7: Changing Data Types

    27:56

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Aggregate Function and ROUND

    Lesson 7: Changing Data Types

    19:00

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

    View enrollment options at Noble Desktop
  • Date Functions

    Lesson 8: Working with Dates

    2:20

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

  • Enrollment required

    Exercise 2.0 Date Functions

    Lesson 8: Working with Dates

    19:52

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution 2.0 Date Functions

    Lesson 8: Working with Dates

    17:40

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

    View enrollment options at Noble Desktop
  • Grouping Data

    Lesson 9: Organizing Statistical Results Into Categories

    8:18

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

  • Enrollment required

    Subqueries

    Lesson 10: Subqueries

    27:41

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution Subqueries

    Lesson 10: Subqueries

    24:51

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Aggregate Window Functions

    Lesson 11: Aggregate Window Functions

    23:01

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution WIndow Functions

    Lesson 11: Aggregate Window Functions

    9:34

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Conditionals

    Lesson 12: Conditionals

    18:26

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

    View enrollment options at Noble Desktop
  • Enrollment required

    CASE Exercise

    Lesson 12: Conditionals

    14:36

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Views

    Lesson 13: Views

    18:50

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Views Solution

    Lesson 13: Views

    0:46

    Summarize and filter user spending patterns using flexible query criteria.

    View enrollment options at Noble Desktop
  • String Functions

    Lesson 14: String Functions

    4:34

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

  • Enrollment required

    Learning Resources

    Lesson 15: Additional Resources

    3:24

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Finding Datasets

    Lesson 15: Additional Resources

    2:04

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

    View enrollment options at Noble Desktop
  • AI and SQL

    Lesson 16: AI and SQL

    11:06

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

  • Enrollment required

    Challenge AI and SQL

    Lesson 16: AI and SQL

    5:13

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

    View enrollment options at Noble Desktop
  • Enrollment required

    Solution AI and SQL

    Lesson 16: AI and SQL

    14:13

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

    View enrollment options at Noble Desktop

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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • Prototyping Interactive Designs

    Lesson 2: Components & Prototyping

    10:00

    Turn static designs into clickable, interactive prototypes that simulate real user experiences.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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

Course Reviews

No reviews yet

Be the first to share your experience with this course

Write the First Review

Find the path that fits your
career goals

Sign up for bootcamp advice

Enter your email to join our newsletter community.

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