Microsoft Excel 365 - Basic & Advanced
CPD-accredited Excel 365 course covering basic to intermediate skills. Learn navigation, formulas, data preparation, PivotTables, charts, automation with macros, Power Query, and modern functions like XLOOKUP, Dynamic Arrays, and LET to analyze and present data effectively.
What you'll learn
- Navigate the Excel interface and work efficiently with the ribbon and worksheet
- Use formulas, functions, and shortcuts to boost productivity
- Prepare, sort, and filter data for analysis and reporting
- Apply math, statistical, logic, text, date, and time functions
- Create charts, graphs, and PivotTables to summarize and visualize data
- Automate repetitive tasks with macros and use modern Excel features like XLOOKUP, Dynamic Arrays, and LET
Skills you'll gain
- Navigate the Excel interface and work with workbooks and worksheets
- Boost productivity using formulas, functions, and keyboard shortcuts
- Prepare and clean data for analysis using sorting, filtering, and tables
- Use math, statistical, logic, text, date, and time functions to manipulate data
- Create and format PivotTables, including calculated fields
- Perform what-if analysis with Scenario Manager and Goal Seek
- Import, unpivot, and append data using Power Query (Get & Transform)
- Build effective column, bar, pie, line, and combination charts
- Apply cell formatting, custom number formats, and conditional formatting
- Automate repetitive tasks by recording basic macros
- Use modern Excel functions like XLOOKUP, Dynamic Arrays, and LET
Prerequisites
- • No prior experience needed
Who this course is for
- → Beginners with no prior Excel experience
- → Intermediate users wanting to improve productivity and analysis skills
- → Professionals who need Excel for reporting, data analysis, or project management
- → Learners seeking a CPD-accredited Excel certification
Provider
GoSkills
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.