CloudTeam

Main menu

Contact
Technology. Skills. Opportunity. ENPL

TrainingMicrosoft 365 & Copilot / Microsoft 365MS-EXCELADV

MS-EXCELADVCloudTeam course

Microsoft Excel Advanced - english

This seminar develops advanced Excel skills: nested functions, pivot tables, data validation and basic macros. The course is designed for users who already know the basics and intermediate functions and want to analyze data efficiently and automate repetitive tasks.

Duration
2 days
Level
Intermediate
Provider
In-house courses
Topic
Microsoft 365 & Copilot / Microsoft 365

Course outline

  • Further Formulas and Functions, nested functions, lookup function
  • Protecting cells and documents, custom number formats, conditional formatting
  • Working with Data Lists, complex sorting
  • Data Validation - setting and checking criteria
  • Goal Seek
  • Consolidate
  • Scenario Manager
  • Solver
  • PivotTable - creating, changing, advanced features
  • Outlining Excel Data
  • Subtotals
  • Charts, break-even analysis, Sparklines
  • Macros - recording and running, creating custom functions
  • Data Import and Export, working with graphics
  • Preparing a document for sharing, templates
  • Forms - validation, cell protection, controls
  • Performing settings in Excel, customizing the Quick Access Toolbar

Skills you will gain

  • Use Lookup & Informational Functions
  • Create Pivot Tables
  • Use What-If Tools
  • Sharing and Tracking Workbooks
  • Record Basic Macros

Who should attend

  • Experienced Excel users who need to perform more complex functions
  • People analyzing data lists and using What-If tools
  • People who would like to start recording basic macros
  • Information Workers

Prerequisites

  • Sound Excel skills and understanding of key spreadsheet concepts, equivalent to the Intermediate course level

Upcoming dates

These sessions run online with LLPA partners. Times are shown in Polish time, and the language of delivery is listed for each date.

DateTimes (Polish time)LanguageStatusPriceAction
09:00–17:00EnglishScheduled3290 PLNRequest a quote

3290 PLN

Ask about dates