Excel Course Online
Master Microsoft Excel from beginner to advanced in this 3‑module, 18‑hour self‑paced bootcamp. Learn essential formulas and functions, charts, Pivot Tables, database and logical functions, advanced analytics, macros, and time‑saving techniques to become an Excel power user.
What you'll learn
- Progress from Excel fundamentals to intermediate and advanced skills in 3 modules
- Learn formulas, functions, charts, Pivot Tables, database and logical functions
- Master advanced analytics tools, macros, and time‑saving workbook techniques
- Get 18 hours of project‑based video training plus proprietary workbooks
- Access expert instructor support, discussion forums, and 1‑on‑1 bonus training
- Earn a verified digital certificate from an accredited institution
Skills you'll gain
- Get comfortable with the Excel interface, data entry, and workbook management
- Use essential formulas and functions including Autosum and text functions
- Format worksheets, use conditional formatting, and prepare work for printing
- Create and customize charts including line, column, pie, combo, and Pivot Charts
- Work with tables, sort and filter data, remove duplicates, and use data validation
- Apply database and lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH
- Use logical and statistical functions including IF, AND, OR, COUNTIFS, and SUMIFS
- Build and analyze Pivot Tables with grouping, timelines, calculations, and variances
- Apply advanced cell management, cell locking, auditing, hotkeys, and Go To Special
- Use date and special formatting plus advanced conditional formatting and nested IFs
- Perform What‑If Analysis with Goal Seek and Data Tables
- Record and run basic and relative reference macros for ad‑hoc reporting
- Consolidate and analyze data across sheets and windows using dynamic array techniques
Prerequisites
- • Comfort using a computer; no prior Excel knowledge required
Who this course is for
- → Participants with limited to no experience in Excel who want to master common business applications
- → People working in or seeking roles that require advanced analytical skills in Excel
- → College and graduate students wanting practical Excel skills in business contexts
- → Entrepreneurs and freelancers who need to work on advanced Excel projects
Provider
VDCI
Related Courses
Python Certification
This course teaches you the fundamentals of Python programming and guides you through projects and an exam to earn a Python Certification on freeCodeCamp.
Certificate in Systems Analysis and Design (CSAD)
EPOL 472: Instructional and Training System Design
Provides instruction and practice in selecting, organizing, and preparing content for instructional programs in business and technical settings, offering a theoretical orientation to instructional design and hands-on experience developing instructional materials.
Ace The Machine Learning System Design Interview
A focused 59-minute course that teaches a repeatable system for ML system design interviews, emphasizing structure, communication, real-world trade-offs, and what interviewers actually care about so you can demonstrate seniority and pass with confidence.
Low Level Design BootCamp @SUPRA Batch
A comprehensive Low Level Design program covering fundamentals, OOP, UML, SOLID principles, design patterns, and real-world design problems to prepare beginners and experienced programmers for technical interviews and placement exams.
Learn TypeScript
TypeScript has been gaining incredible market share against vanilla JavaScript in recent years. Master TypeScript from start to finish in this comprehensive, immersive, hands-on course while solving real-world type challenges each step of the way.