Excel for Data Analytics
via Noble Desktop
Affiliated with Course Report
Improve your data analysis skills with this Excel class. Learn essential functions, formulas, and advanced techniques like PivotTables and VLOOKUP. Gain hands-on experience and optimize your workflow for efficient data analysis.
What's included with live classes
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Overview
Advance your spreadsheet skills with this three-part course, covering foundational techniques, intermediate tools, and advanced automation. Learn how to navigate Excel, use formulas and functions, format spreadsheets, and create charts to present data clearly and professionally.
Build on those skills by working with data validation, logical statements, PivotTables, and advanced combo charts to manage and analyze large datasets. Then master high-level tools including cell auditing, keyboard shortcuts, special date functions, and macro recording to boost productivity and streamline reporting.
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
- Live tuition
- $595
- Course length
- 18 hours
All class times are Eastern (ET).
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 6pm ET
Final session ends at 9pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 6pm ET
Final session ends at 9pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
–
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
Confirm current dates and availability on Noble Desktop before booking. Enrollment opens in a new tab.
Self-paced tuition & enrollment
Learn through recorded lessons on your own schedule.
- Tuition
- $595
- Course length
- 18 hours
- Format
- Self-paced online
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 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.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
Curriculum
What you'll learn
- Learn Excel functions and formulas to organize, calculate, and summarize data efficiently
- Create and customize visual charts, such as line, column, and pie charts, to present data clearly
- Use logical statements, database functions, and data validation to manage and filter large datasets
- Build and manipulate PivotTables to quickly summarize, sort, and group information
- Explore advanced tools like named ranges, date calculations, and macro recording for custom reporting
- Apply auditing techniques, cell locking, and Excel hot keys to optimize your spreadsheet workflow
Course syllabus
Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
Excel Level II: Intermediate
- Learn to split and join text, add data validation and named ranges
- Use database functions and logical statements
- Create PivotTables to quickly summarize large databases
- Create advanced combo charts from multiple charts
Excel Level III: Advanced
- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical tools
- Record macros and relative reference macros for ad hoc reporting
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 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.
View self-paced tuition & enrollmentApply Excel to Data Analytics
If you want to learn Excel and dive into data analytics, this is the class for you.
Build Skills with Hands-On Projects
To learn efficient data analysis, you'll complete projects under the guidance of an experienced instructor.
Learn Core Functions & Formulas
Learn advanced techniques to sort, filter, group, and visualize data in Excel.
Self-paced curriculum
What you'll learn self-paced
- Learn Excel functions and formulas for organizing, calculating, and summarizing data efficiently
- Create and customize visual charts, including line, column, and pie charts, to present data clearly
- Use logical statements, database functions, and data validation to manage and filter large datasets
- Build and manipulate Pivot Tables to quickly summarize, sort, and group information
- Explore advanced tools like named ranges, date calculations, and macro recording for custom reporting
- Apply auditing techniques, cell locking, and Excel hot keys to optimize your spreadsheet workflow
Self-paced syllabus
Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
Excel Level II: Intermediate
- Learn to split and join text, add data validation and named ranges
- Use database functions and logical statements
- Create PivotTables to quickly summarize large databases
- Create advanced combo charts from multiple charts
Excel Level III: Advanced
- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical tools
- Record macros and relative reference macros for ad hoc reporting
What's included with self-paced
- Microsoft Office (1 month)