Data Analytics Technologies Bootcamp
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
If you're looking to master the most in-demand data analytics tools, this program covers Excel, SQL, and Tableau in one comprehensive, affordable training. You'll learn how to organize, analyze, summarize, and visualize data so you can present clear, actionable insights with confidence. Classes are held at our business training school in Midtown Manhattan, and a PC with all the necessary software is provided for each course, so there's nothing extra you need to bring or install.
Throughout the program, you'll put your skills to work on real-world projects that reflect the kinds of challenges you'd face on the job. And if you ever feel like you need a refresher, a free retake is available for any course within six months of your original class date, giving you added flexibility as you build your expertise.
Curriculum
What you'll learn
- Aggregate and summarize your data in Excel using formulas and functions.
- Visualize data in Excel using Pivot Tables.
- Create charts and tables in Excel to interpret data.
- Use SQL to sort, filter, and summarize data from larger databases.
- Learn advanced SQL queries and procedures.
- Manipulate, format, and interpret data in Tableau.
- Present visualizations and create dashboards and stories in Tableau.
Course outline
-
Excel Level I: Fundamentals 6 hours
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
- Get comfortable with the Excel interface and learn multiple ways to enter and organize data in a worksheet.
- Work with rows, columns, and worksheets by inserting, deleting, hiding, grouping, and managing spreadsheet elements.
- Build foundational Excel skills with Autofill, basic calculations, AutoSum, and essential functions such as SUM, AVERAGE, MAX, MIN, and COUNT.
- Use formulas more effectively with absolute references, logical true/false tests, text functions, and multi-input functions.
- Format spreadsheets for clarity with cell formatting and conditional formatting that highlights data based on specific rules.
- Create visual reports with column charts, line charts, pie charts, sparklines, and Excel Tables.
- Manage workbooks more efficiently using Freeze Panes, printing tools, display options, templates, and essential keyboard shortcuts and Excel tips.
- Reinforce key concepts through end-of-class projects designed to review what you learned.
-
Excel Level II: Intermediate 6 hours
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
- Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells.
- Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand.
- Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations.
- Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data.
- Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet.
- Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results.
- Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project.
-
Excel Level III: Advanced 6 hours
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
- Use advanced navigation tools, Autofill techniques, Hot Keys, and Go To Special to move through worksheets and work more efficiently.
- Build stronger formulas with mixed references, cell auditing tools, date functions, and custom number formats.
- Create advanced logic with nested IF statements and IF formulas that incorporate AND/OR criteria for more flexible results.
- Perform What-If Analysis with Goal Seek and Data Tables to test variables and evaluate possible outcomes.
- Analyze data with advanced PivotTable tools, including base fields and sets, calculated fields, and Pivot Charts.
- Use XMATCH, INDEX-MATCH, macros, and dynamic arrays to create powerful lookups, automate tasks, and complete an end-of-class project reviewing key concepts.
-
SQL Level 1 6 hours
Learn the fundamentals of SQL and relational databases, including SQL syntax, database tables, and writing SQL queries. This course will also cover topics such as filtering results, using joins to combine data from multiple tables, and exploring databases with the SQL Server Management Studio app.
- Understand core database concepts, including tables, rows, columns, and various types of SQL
- Connect to databases and navigate SQL Server Management Studio using tools such as Object Explorer and Query Editor
- Write SELECT statements to retrieve data, specify columns, sort results, and remove duplicates
- Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
- Explore data types, comparison operators, and case sensitivity to refine queries with more control
- Learn how to join tables using INNER JOIN and understand relational database concepts with ER diagrams and table aliases
-
SQL Level 2 6 hours
Enhance your SQL skills by learning how to join, filter, group, and analyze data in this intermediate course. Discover techniques for outer joins, manipulating data types, working with dates and times, grouping data, and filtering grouped data. Gain the ability to extract and analyze specific data for actionable insights.
- Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
- Identify and work with NULL values to ensure complete and accurate data analysis
- Use the CAST function to convert data types and make your queries more flexible
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation
-
SQL Level 3 6 hours
This advanced course will take your SQL skills to the next level, where you will learn about subqueries, views, variables, functions, stored procedures, and more. Gain a deeper understanding of SQL techniques that will better prepare you for roles in data analysis, data science, and working with data in databases.
- Write subqueries to create layered queries using single-value, multi-value, and table-value structures
- Use window functions with OVER and PARTITION BY to apply aggregate logic across rows without grouping
- Implement conditional logic with CASE and IIF statements to dynamically transform query results
- Manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and more
- Apply self-joins to compare records within the same table and understand their unique structure and use cases
- Build and query views, user-defined functions, and stored procedures to modularize your SQL code
-
Tableau Level I 6 hours
In this course, you will learn the fundamentals of data visualization and how to use Tableau Public to create visually appealing and informative graphs, charts, and maps. Through hands-on exercises, you will gain the skills to connect, analyze, filter, and structure your data to create your desired visualizations.
- Understand the types, formats, and sources of data, and how to connect them to Tableau
- Create foundational visualizations such as bar charts, line graphs, and treemaps using the “Show Me” panel
- Use built-in functions and custom calculations to analyze and manipulate your data within visualizations
- Clean and organize raw data using tools like the Data Interpreter, pivot features, and filters
- Build interactive dashboards and stories that combine multiple views for dynamic storytelling
- Format and publish your visualizations to Tableau Cloud or export them for sharing and presentation
-
Tableau Level II 6 hours
Learn advanced Tableau skills and create custom charts in this course, where you will dive further into Tableau tools and customization of visualizations. You will also learn to create various maps, format geographic data for Tableau, and build actions to control your visualizations within your sheets and dashboards.
- Format geographic data and build a variety of interactive map types, including heat maps, spider maps, and choropleth maps
- Integrate custom visuals using background images, polygon data, and Mapbox maps for enhanced design and functionality
- Create advanced charts such as dual-axis (layered) maps, alluvial diagrams, ranking visuals, and circular area charts
- Add interactivity to dashboards through sheet swapping, filtering actions, and dynamic content controls
- Track and display time-based data trends spatially using map animations and proportional symbols
- Prepare and publish high-quality map visualizations for presentation, sharing, and Tableau Cloud distribution
What's included
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Tue, Wed, Thu, Mon
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Wed, Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Mon, Tue, Wed, Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu, Mon
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu, Mon
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Mon, Tue, Thu, Wed
10:00–17:00 · America/New_York (EST/EDT)
-
–
In-person or live online
Mon, Wed, Tue
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu, Mon
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Wed, Tue
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Thu, Wed, Fri, Mon
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Thu, Wed, Mon
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 240 days. You can choose when to start your access period. Once you activate, you will have 240 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $1,949
- Course length
- 51 hours
- Schedule
- On your schedule
If you're aiming to get comfortable with the most in-demand data analytics tools, this program covers Excel, SQL, and Tableau in one comprehensive, affordable package. You'll learn how to organize, analyze, summarize, and visualize data so you can present clear insights people can act on with confidence. The course content can be worked through at your own pace, and everything you need is provided, so there's nothing extra to bring or install.
Throughout the program, you'll put your skills to work on real-world projects that mirror the kinds of challenges you'd run into on the job. And if you ever feel like you need a refresher, a free retake is available for any course within six months of your original start date, giving you added flexibility as you build your expertise.
Self-paced curriculum
What you'll learn self-paced
- Aggregate and summarize your data in Excel using formulas and functions.
- Visualize data in Excel with Pivot Tables.
- Build charts and tables in Excel to make sense of your data.
- Use SQL to sort, filter, and summarize data drawn from larger databases.
- Pick up advanced SQL queries and procedures.
- Shape, format, and interpret data in Tableau.
- Present visualizations and build dashboards and stories in Tableau.
Self-paced course outline
-
Excel Level I: Fundamentals Course Online (Self-Paced) 6 hours
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
- Become familiar with the interface and data entry
- Learn essential formulas and functions
- Format and print your work
- Create charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Review key concepts in a final project
-
Excel Level II: Intermediate Course Online (Self-Paced) 6 hours
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
- Learn to split and join text, apply data validation, and create named ranges
- Use database functions such as VLOOKUP and HLOOKUP
- Write logical formulas using AND, OR, and IF functions
- Create Pivot Tables to efficiently summarize and analyze large datasets
- Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
- Build advanced combo charts by combining multiple chart types
- Reinforce key concepts through a guided final project
-
Excel Level III: Advanced Course Online (Self-Paced) 6 hours
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions such as nested IF statements
- Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
- Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Record macros and relative reference macros for ad hoc reporting
- Create a project that applies key concepts from the class
-
SQL Level I (Self-Paced) 6 hours
Learn the fundamentals of SQL and relational databases, including syntax, database tables, and query writing. This course covers filtering results, using joins to combine data, and exploring databases through SQL Server Management Studio.
- Understand core database concepts, including tables, rows, columns, and different types of SQL
- Connect to databases and navigate SQL Server Management Studio using tools like Object Explorer and Query Editor
- Write SELECT statements to retrieve data, specify columns, sort results, and remove duplicates
- Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
- Explore data types, comparison operators, and case sensitivity to refine queries with greater control
- Learn to join tables using INNER JOIN and understand relational database concepts through ER diagrams and table aliases
-
SQL Level II (Self-Paced) 6 hours
Enhance your SQL skills by learning how to join, filter, group, and analyze data in this intermediate course. Discover techniques for outer joins, manipulating data types, working with dates and times, grouping data, and filtering grouped data. Gain the ability to extract and analyze specific data for actionable insights.
- Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
- Identify and work with NULL values to ensure complete and accurate data analysis
- Use the CAST function to convert data types and make your queries more flexible
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation
-
SQL Level III (Self-Paced) 6 hours
Take your SQL skills to the next level in this advanced course, where you’ll explore subqueries, views, variables, functions, stored procedures, and more. Deepen your understanding of SQL techniques to prepare for roles in data analysis, data science, and database management.
- Write subqueries to create layered queries using single-value, multi-value, and table-value structures
- Use window functions with OVER and PARTITION BY to apply aggregate logic across rows without grouping
- Implement conditional logic with CASE and IIF statements to dynamically transform query results
- Manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and more
- Apply self-joins to compare records within the same table and understand their structure and use cases
- Build and query views, user-defined functions, and stored procedures to modularize your SQL code
-
Tableau Level I (Self-Paced) 6 hours
In this course, you’ll learn the basics of data visualization and how to use Tableau Public to create clear, engaging charts, graphs, and maps. Through hands-on exercises, you’ll build skills in connecting to data, analyzing and filtering it, and organizing information to produce effective visualizations.
- Understand common data types, formats, and sources, and learn how to connect them to Tableau
- Create essential visualizations such as bar charts, line charts, and treemaps using the Show Me panel
- Analyze data with built-in functions and custom calculations directly within your visualizations
- Clean and structure datasets using tools like the Data Interpreter, pivoting, and filters
- Design interactive dashboards and stories by combining multiple views for dynamic storytelling
- Format, publish, and share your work through Tableau Cloud or export visuals for presentations
-
Tableau Level II (Self-Paced) 6 hours
Build advanced Tableau skills in this course by creating custom charts and exploring deeper visualization tools and customization options. You’ll also learn how to work with maps, format geographic data, and add interactive actions that control how users experience your sheets and dashboards.
- Format geographic data and create interactive map types such as heat maps, spider maps, and choropleth maps
- Enhance visual design and functionality with background images, polygon data, and Mapbox maps
- Build advanced charts, including dual-axis maps, alluvial diagrams, ranking visuals, and circular area charts
- Add dashboard interactivity with sheet swapping, filtering actions, and dynamic controls
- Visualize time-based trends using map animations and proportional symbols
- Prepare and publish polished map visualizations for presentations, sharing, and Tableau Cloud
What's included with self-paced
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Excel Level I: Fundamentals Course Online (Self-Paced)
-
Interface
Lesson 1: Introduction
8:26
Explore the Microsoft Excel user interface, including the Quick Access Toolbar, Ribbon tabs and groups, Review tab features, Insert Function button, Zoom slider, Sheet Selector buttons, and the expansive rows and columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Rows and Columns
Lesson 1: Introduction
6:02
Insert, delete, hide, and group rows and columns using ribbon commands, right-click menus, keyboard shortcuts, and grouping buttons.
View enrollment options at Noble Desktop -
Autofill
Lesson 2: Formulas
9:07
Use Excel's autofill and flash fill features to efficiently complete patterns and replicate data across cells.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Entry
Lesson 2: Formulas
5:13
Learn techniques for efficient data entry, editing, copying, pasting, and cutting in spreadsheets.
View enrollment options at Noble Desktop -
Enrollment required
Calculations
Lesson 2: Formulas
10:16
Learn to perform basic calculations in Excel using formulas, cell references, and functions like AVERAGE while considering the order of operations (PEMDAS).
View enrollment options at Noble Desktop -
Enrollment required
Autosum Functions
Lesson 2: Formulas
9:58
Use Excel's AutoSum functions to quickly calculate Sum, Average, Max, Min, and Count in tables.
View enrollment options at Noble Desktop -
Enrollment required
Text Functions
Lesson 2: Formulas
8:04
Use text functions like PROPER, UPPER, LOWER, and TRIM in Excel to efficiently adjust text casing and remove extra spaces.
View enrollment options at Noble Desktop -
Enrollment required
True False
Lesson 2: Formulas
7:14
Verify statements in Excel as true or false using comparison operators.
View enrollment options at Noble Desktop -
Enrollment required
Absolute Cell References
Lesson 2: Formulas
10:07
Utilize absolute cell references in Excel formulas to fix a specific cell while autofilling calculations, preventing unwanted shifts in cell references.
View enrollment options at Noble Desktop -
Enrollment required
Multi Input Functions
Lesson 2: Formulas
12:37
Learn to use multi-input Excel functions like LEFT, RIGHT, SUMPRODUCT, and ROUND for extracting data, calculating totals, and managing rounding errors efficiently.
View enrollment options at Noble Desktop -
Enrollment required
Formatting
Lesson 3: Formatting
14:04
Explore various Excel formatting tools to enhance cell appearance, including changing colors, fonts, alignment, number formats, and merging cells.
View enrollment options at Noble Desktop -
Enrollment required
Conditional Formatting
Lesson 3: Formatting
9:30
Use conditional formatting to visually highlight and differentiate data based on set criteria within Excel.
View enrollment options at Noble Desktop -
Line Chart
Lesson 4: Charts & Tables
5:34
Create a basic line chart in Excel by selecting a single cell in your data, using the insert tab to choose a line chart, and customizing it with quick layout, color, and style options.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Column Chart
Lesson 4: Charts & Tables
7:53
Create a column chart by selecting data, inserting it from the Insert tab, and customizing elements like axis titles, data labels, and grid lines through the Chart Design tab.
View enrollment options at Noble Desktop -
Enrollment required
Trendlines
Lesson 4: Charts & Tables
3:05
Apply trend lines to charts by selecting the desired type (linear, exponential, linear forecast, or moving average) in the chart design options.
View enrollment options at Noble Desktop -
Enrollment required
Pie Chart
Lesson 4: Charts & Tables
7:27
Create and customize pie charts by selecting data, converting between 2D, 3D, and donut styles, and isolating specific slices for emphasis.
View enrollment options at Noble Desktop -
Enrollment required
Tables
Lesson 4: Charts & Tables
13:52
Learn to create and use Excel tables for efficient data management and analysis.
View enrollment options at Noble Desktop -
Printing
Lesson 5: Workbook Management
10:00
Explore and adjust printing options in Excel by utilizing the Page Layout tab to control margins, orientation, print area, page breaks, print titles, scale to fit, and gridlines, while adding headers and footers through the Insert tab for enhanced page setup and layout management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Worksheets
Lesson 5: Workbook Management
7:04
Manage Excel worksheets by inserting, deleting, hiding, moving, copying, and renaming them using right-click options or the ribbon menu.
View enrollment options at Noble Desktop -
Enrollment required
Freeze Panes
Lesson 5: Workbook Management
5:03
Freeze panes by selecting the desired row or column below or to the right of where you want the freeze, then choose "Freeze Panes" from the View tab.
View enrollment options at Noble Desktop -
Enrollment required
Excel Tricks
Lesson 5: Workbook Management
9:14
Explore Excel tricks like repeating commands with F4, applying multiple formats using Format Painter, inserting comments and links, and capturing screenshots directly into your spreadsheet.
View enrollment options at Noble Desktop
Excel Level II: Intermediate Course Online (Self-Paced)
-
Enrollment required
Tips and Fundamentals
Lesson 5: Workbook Management
10:24
Review and apply Excel's autosum functions and formula auditing tools to calculate totals, averages, and high scores, detect and fix errors, and ensure correct formula dependencies.
View enrollment options at Noble Desktop -
Navigation
Lesson 1: Worksheet Management
6:58
Navigate and select cells in a spreadsheet using keyboard shortcuts like arrow keys, control, shift, and page up/down for efficient data management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Paste Special
Lesson 2: Working with Text
8:55
Use paste special in Excel to apply formats, perform calculations, and change data orientation.
View enrollment options at Noble Desktop -
Enrollment required
Paste Special Values
Lesson 2: Working with Text
3:14
Use "paste special values" to copy and paste only the results of formulas as text without including the formulas themselves.
View enrollment options at Noble Desktop -
Enrollment required
Splitting Text
Lesson 2: Working with Text
5:08
Use text-to-columns to split data in a spreadsheet into separate columns based on delimiters like commas or spaces.
View enrollment options at Noble Desktop -
Enrollment required
Joining Text
Lesson 2: Working with Text
5:06
Join text using either the concatenate function or the ampersand method to combine cells with specified separators like spaces or dashes.
View enrollment options at Noble Desktop -
Enrollment required
Named Ranges
Lesson 3: Cell Ranges
3:56
Create named ranges for assets, liabilities, and equity to simplify referencing them in calculations.
View enrollment options at Noble Desktop -
Data Validation
Lesson 4: Database Functions
7:35
Use data validation in Excel to create drop-down lists that restrict cell input to specified numerical or text values, with options to customize error alerts and input messages.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Remove Duplicates
Lesson 4: Database Functions
3:51
Remove duplicates by selecting a cell in the data, going to the Data tab, clicking Remove Duplicates, and confirming the selection.
View enrollment options at Noble Desktop -
Enrollment required
VLOOKUP
Lesson 4: Database Functions
10:06
Use VLOOKUP to find information in a table by specifying a lookup value, table array, column index number, and choose between exact or approximate match.
View enrollment options at Noble Desktop -
Enrollment required
HLOOKUP
Lesson 4: Database Functions
2:58
Use HLOOKUP to find a lookup value horizontally in a row by selecting the row index number instead of the column index number.
View enrollment options at Noble Desktop -
Enrollment required
Sort and Filter
Lesson 4: Database Functions
15:53
Sort and filter data using Excel's home or data tab, create subtotals for grouped data, and practice these skills through specific tasks like multi-level sorting, filtering, and applying subtotals.
View enrollment options at Noble Desktop -
Pivot Tables New
Lesson 5: Pivot Tables
10:00
Create a basic pivot table by converting your data into an Excel table, then use the pivot table options to summarize and filter the data, remembering to refresh for updates.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Grouping Timelines
Lesson 5: Pivot Tables
5:16
Group and filter pivot table data by time periods using the group and insert timeline features.
View enrollment options at Noble Desktop -
Enrollment required
Multiple Pivot Tables
Lesson 5: Pivot Tables
11:40
Explore pivot tables by inserting fields multiple times, using value field settings for different calculations, employing slicers for easy filtering, and connecting slicers to multiple pivot tables for synchronized filtering.
View enrollment options at Noble Desktop -
If Statements
Lesson 6: Logical Functions
8:30
Explain how to use if statements and if error functions in Excel for logical testing and error handling.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
And Or
Lesson 6: Logical Functions
6:17
Use AND to ensure all criteria are true and OR to check if at least one criterion is true when evaluating conditions.
View enrollment options at Noble Desktop -
COUNTIFS and SUMIFS
Lesson 7: Statistical Functions
9:46
Count and sum data based on conditions using COUNTIFS and SUMIFS functions in Excel, which act as filters for specified criteria across multiple columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combo Charts
Lesson 8: Advanced Charts
5:01
Create a combo chart with a secondary axis for better comparison, and format it by adjusting bar colors, background, border, and adding effects.
View enrollment options at Noble Desktop
Excel Level III: Advanced Course Online (Self-Paced)
-
Advanced Cell Lock
Lesson 1: Cell Management
10:00
Lock cells in Excel by using mixed referencing to maintain specific row or column values when autofilling formulas.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Hot Keys
Lesson 1: Cell Management
7:14
Utilize the Alt key on a PC to access Excel's ribbon commands and create custom keyboard shortcuts for efficient navigation and task execution.
View enrollment options at Noble Desktop -
Enrollment required
Go To Special
Lesson 1: Cell Management
8:51
Use "Go To Special" in Excel to quickly select specific cell types, such as constants, blanks, or visible cells, for efficient data management and editing.
View enrollment options at Noble Desktop -
Date Functions
Lesson 2: Special Formatting
7:29
Calculate future dates, days between dates, workdays, week numbers, and month ends using Excel's DAYS, NETWORKDAYS, WEEKNUM, EOMONTH, and EDATE functions.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adv Conditional Formatting
Lesson 2: Special Formatting
9:35
Apply advanced conditional formatting using formulas to format cells based on criteria in different columns.
View enrollment options at Noble Desktop -
Enrollment required
Nested IFs
Lesson 2: Special Formatting
9:37
Nest multiple if statements to evaluate more conditions and provide different responses based on the evaluated criteria.
View enrollment options at Noble Desktop -
If AND OR
Lesson 3: Advanced Functions
7:43
Combine the IF statement with AND or OR functions to evaluate multiple conditions and return specific results based on whether those conditions are true or false.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Goal Seek
Lesson 4: What If Analysis
4:18
Use Goal Seek in Excel to determine the required growth rate or exam score needed to reach a specific target value by adjusting a related variable.
View enrollment options at Noble Desktop -
Enrollment required
Data Tables
Lesson 4: What If Analysis
7:32
Create data tables in Excel to analyze the impact of different variables on a formula.
View enrollment options at Noble Desktop -
Conditional Sumproduct
Lesson 5: Advanced Analytical Tools
9:48
Use conditional sum product to calculate totals or averages by applying criteria to filter specific data subsets.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Table Variances
Lesson 5: Advanced Analytical Tools
6:17
Create a pivot table, group data by quarters and years, and use "difference from" and "percentage difference from" calculations to show variances between years.
View enrollment options at Noble Desktop -
Enrollment required
Pivot Calculations
Lesson 5: Advanced Analytical Tools
10:22
Perform calculations within pivot tables using calculated fields and items for efficient data analysis.
View enrollment options at Noble Desktop -
Enrollment required
Pivot Charts
Lesson 5: Advanced Analytical Tools
6:05
Create dynamic graphical representations of pivot table data using pivot charts in Excel.
View enrollment options at Noble Desktop -
Match Function
Lesson 6: Advanced Database Functions
4:25
Find the relative position of a lookup value within a single column or row using the match function.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Vlookup Match
Lesson 6: Advanced Database Functions
8:08
Enhance VLOOKUP accuracy by using the MATCH function to dynamically determine the column index number, allowing for more efficient data retrieval with mixed referencing.
View enrollment options at Noble Desktop -
Enrollment required
Index Match
Lesson 6: Advanced Database Functions
7:02
Combine INDEX and MATCH functions to efficiently locate a value in a row or column, allowing lookups in either direction.
View enrollment options at Noble Desktop -
Enrollment required
Index Double Match
Lesson 6: Advanced Database Functions
7:07
Utilize the Index Double Match function to perform a two-way lookup by identifying both row and column positions for retrieving specific data from a table.
View enrollment options at Noble Desktop -
Enrollment required
Windows
Lesson 6: Advanced Database Functions
6:56
Learn to use keyboard shortcuts and commands in Windows to efficiently navigate and arrange Excel windows for better multitasking.
View enrollment options at Noble Desktop -
Enrollment required
Working Across Sheets
Lesson 6: Advanced Database Functions
4:38
Apply formatting and summarize calculations across multiple sheets by selecting ranges while holding the shift key and using functions like SUM and autofill for common cells.
View enrollment options at Noble Desktop -
Macros
Lesson 7: Introduction to Macros
8:29
Automate Excel tasks by creating and running macros using the developer tab, keyboard shortcuts, buttons, and the quick access toolbar to efficiently repeat actions like entering data.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
MacrosReport
Lesson 7: Introduction to Macros
6:14
Create a macro to automate daily report formatting tasks, reducing a two-minute manual process to under a second.
View enrollment options at Noble Desktop -
Enrollment required
Consolidation
Lesson 8: Dynamic Arrays
5:10
Use the consolidate function to sum values across multiple sheets into a summary worksheet and enable automatic updates when source data changes.
View enrollment options at Noble Desktop