Excel for Data Analytics
- 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
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.
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 Pivot Tables 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
- 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
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 18:00 · America/New_York (EST); final session ends at 21:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 18:00 · America/New_York (EDT); final session ends at 21:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
Confirm current dates and availability on Noble Desktop before booking.
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.
- Tuition
- $595
- Course length
- 18 hours
- Schedule
- On your schedule
Apply 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 Pivot Tables 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)