Microsoft Excel Certification Training
This online course prepares you for the Microsoft Office Specialist Excel Expert certification exam. You will learn to create and format worksheets, use advanced formulas, work with lists, charts, PivotTables, macros, and collaboration tools to analyze and present data efficiently.
What you'll learn
- Prepare for the Microsoft Office Specialist Excel Expert certification exam (MO-201 or MO-211)
- Learn to create, modify, format, and print Excel workbooks and worksheets
- Use advanced formulas, database and logic functions, and statistical tools for data analysis
- Visualize data with charts, PivotTables, and advanced formatting including conditional formatting
- Work with lists, tables, data tools, and validation to organize and control data input
- Record and use macros and apply collaboration and protection features in Excel
Skills you'll gain
- Modify and format data in Excel to create clear, presentable worksheets
- Perform calculations, write formulas, manage workbooks, and use Excel shortcuts
- Use database, logic, and statistical functions to work with and analyze large datasets
- Visualize data with charts to show trends, comparisons, and insights
- Convert, sort, filter, and manage lists and tables to organize data
- Insert and modify illustrations, logos, and shapes for professional reports
- Apply conditional formatting and styles to emphasize key data and save time
- Create PivotTables and charts to summarize large amounts of data quickly
- Trace precedents and dependents to understand cell relationships
- Convert text blocks, use validation tools, and consolidate data from multiple sources
- Protect worksheets and workbooks for secure collaboration
- Import and export data, charts, and files to work with other applications
- Be prepared to sit for the Microsoft Excel Expert certification exam (MO-201 or MO-211)
Prerequisites
- • Comfort using a personal computer
- • Familiarity with operating Microsoft Office software
Who this course is for
- → Individuals seeking Microsoft Office Specialist Excel Expert certification
- → Professionals who work with data and spreadsheets in an office environment
- → Learners who want to improve productivity and data analysis skills using Excel
Provider
The City College of New York / ed2go
Related Courses
Python Bootcamp
Python Bootcamp covers fundamentals of Python programming, including control structures, advanced data types, functions, modules, packages, multithreading, exception handling, file handling, GUI design, and database connectivity, preparing learners for future work in data science and machine learning.
Systems Engineering
This course introduces Systems Engineering principles across the lifecycle of complex systems, covering system design, architecture, requirements analysis, modeling, verification, lifecycle models (Waterfall, V-Model, Spiral, Agile), SysML, risk management, trade-off analysis, and a Smart Home Security System project.
IT Systems Design and Analysis
Prepare to design, analyze, and evaluate IT systems using data flow diagrams, ERDs, UML, and feasibility analysis. Learn to assess existing systems, identify inefficiencies, compare solution alternatives, and deliver a digital transformation strategy through a hands-on final project.
Hands On FullStack Development Course with Infrastructure Management Product implementation
A 180-day, project-first full-stack infrastructure course where you build and operate production-grade services with CI/CD, testing, observability, and operational playbooks, aimed at taking you from toy projects to real-world deployment experience.
Learn Typescript
Hands-on introduction to TypeScript fundamentals and their application in real projects. Learn core typing concepts, advanced TypeScript features, and how to use TypeScript with React and Express while building safer, more maintainable JavaScript applications.
AI Engineering Course
Designed to help software engineers transition to AI engineering, with detailed breakdowns of vector databases, indexing, large language models, attention, and core optimizations so you can understand how LLMs work and use them to build real-world applications.