Microsoft Excel Training for Apple Mac in London, the UK & Europe
Microsoft Excel for Apple Mac Training – Spreadsheet & Data Skills for Mac Users
Our Microsoft Excel for Apple Mac training courses provide hands‑on, practical training for professionals who use Excel on macOS and want to analyse data, create reports, and work more efficiently. Designed specifically for Mac users, this course helps teams build confidence using Excel for Mac while understanding key differences from the Windows version.
Beginner to Advanced | Online or On‑Site Training
Learn how to use Microsoft Excel for Mac effectively through realistic workplace scenarios. From everyday spreadsheets to advanced analysis and reporting, this course focuses on practical skills that can be applied immediately in a Mac‑based working environment.
What Your Team Will Learn on Our Excel for Mac Course
- Create and structure spreadsheets correctly using tables, formatting, and best‑practice design in Excel for Mac
- Use formulas and functions confidently, including logical, lookup, text, and date functions available on macOS
- Analyse and summarise data efficiently using sorting, filtering, PivotTables, and charts
- Create professional reports and dashboards suitable for management, finance, and operational use
- Understand key differences between Excel for Mac and Windows, including features, shortcuts, and interface variations
- Work faster and reduce errors by applying proven Excel techniques and Mac‑specific shortcuts
All learning is reinforced through hands‑on exercises using practical, business‑focused examples.
Why Choose Phoenix Solutions4all for Excel for Mac Training
- Delivered by expert Microsoft Excel trainers experienced in both Mac and Windows environments
- Hands‑on, instructor‑led training focused on real business use—not generic demonstrations
- Online or on‑site delivery, with course content tailored to your organisation’s data, reporting needs, and macOS setup
Our training ensures Mac users can use Excel confidently and efficiently, without frustration or workarounds.
Who This Microsoft Excel for Mac Course Is For
This course is ideal for business professionals, administrators, finance teams, analysts, project staff, and Mac‑based teams who rely on Excel for reporting, analysis, and decision‑making. Suitable for beginners as well as users progressing to Intermediate or Advanced Excel for Mac skills.
Please select the version that you’re interested in
Please select the level that you’re interested in
Excel Introduction
Course Overview
- Create and maintain spreadsheets
- Create and edit formulae
- Format and print worksheets
- Perform basic list management task
Audience:
This course is designed for new users of Microsoft Excel, or self-taught users. The course covers all aspects of creating and maintaining spreadsheets; including basic formulae and functions.
Prerequisite:
No Prior experience or knowledge of Spreadsheets is required to attend this course. You must have good basic windows, keyboard and mouse skills.
Duration:
This is a 1-day Excel Introduction Course.
The course starts at 09:30 and runs until 16:30.
Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Location:
Our Microsoft Excel Introduction course can be delivered virtually using online training platforms such as MS Teams or Zoom or face-to-face at any preferred location in the UK, Europe or ROW.
Excel Introduction Course Outline
SPREADSHEET PRINCIPLESWhat is a spreadsheet? SCREEN LAYOUT AND EXCEL BASICSRibbon Understanding Workbooks, Worksheets, Rows, Columns, Cells Various selection techniques Understanding different Mouse shapes Tabs Groups Dialog Box Launchers Quick Access Toolbar (QAT) Customizing QAT Formula Bar Customization Live Preview Contextual tabs File Tab (Backstage View) Zoom Feature Page Layout View Full-Screen View Access Keys (Shortcut keys) Saving, File types, File Compatibility (with earlier Versions) Getting Help Various selection techniques Pinning Recent Files ENTERING, SELECTING AND EDITING DATAEntering, Editing and Deleting information in cells (Text, Date, and numbers) Entering Auto Lists Using Fill handle to create simple lists Creating custom lists Deleting Rows, Columns, and Cells Inserting Rows, Columns and Cells Inserting, Deleting, Moving, Copying and Renaming Sheets Various Navigation Techniques using Scroll bar, Keyboards and Go To command Using the Paste Preview |
CREATING FORMULAE AND FUNCTIONSConcept Creating Formulae Editing Existing Formulae BODMAS: Mathematical Order Copying Formulae Understanding Relative Referencing Understanding Absolute Referencing Using the Auto Sum Feature Common Basic Functions: SUM, MIN, MAX, AVERAGE, COUNT, COUNTA Using the Formulas Tab FORMATTING CELLS, ROWS, COLUMNS AND SHEETSFormatting Cells Number Formatting Date Formatting Text Formatting Cell Alignment And Orientation Wrap text Applying borders and shading Border drawing Clearing Formats Changing Column Widths Changing Row Heights Changing sheet Tab Colours Using Format Painter DATA SORT AND FILTERSorting Data Auto Filter CHARTS/GRAPHSCreating Simple Charts Editing Charts Formatting Charts PRINTINGPrint Preview Page Orientation Adding Headers and Footers Printing A Selection Setting A Print Area Scaling Adjusting page breaks using Repeating columns and rows Changing Margins Centre On Page |
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
Extras
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.