Mac Excel

Mac Excel Basics is a comprehensive course that covers the fundamental features of Excel for MAC, as well exposing the delegate to some of the functions in MAC Excel. This is an intensive one-day course, 09h00 to 15h30, which will provide the delegate with sufficient skills to create basic spreadsheets and formulae.

This course will prepare the delegate for more MAC Excel Intermediate and MAC Advanced Excel courses. The delegate receives an Excel MAC manual and an electronic attendance certificate on completion of the Excel Basic MAC Course. Prices on request, T&C applies.

We almost run MAC Excel Basics almost on-demand as we try to accommodate the client’s work schedule when possible.

Mac Excel Basics
Mac Excel Basics

MAC Excel Basics FAQ

  • Can you put Microsoft Office on a Mac?
    • The Office apps available from the Mac App Store provide the very latest version of Office on the Mac. Word, Excel, PowerPoint, and Outlook require a Microsoft 365 subscription to activate.
  • Can I move Microsoft Office to my new MacBook?
    • For Office 365 subscription you can go to the Office.com portal, log into your account, and deactivate the old install and download the installer and make a fresh install on your new hardware.
  • Is Microsoft Office free for Mac?
    • Nope. Apple has a suite of apps for word processing, spreadsheets and presentation (think PowerPoint) software – but Office is licensed separately. The good news is, as a cloud delivered service, Office works much better with Macs than in days past.
  • How do I use Office on MacBook?
    • In the top menu bar select Finder > Applications and scroll down to the Microsoft Office apps. Open any Office app, like Microsoft Word and in the What’s New box that opens, select Get Started. On the Sign in to activate Office screen, select Sign in.

Contact Arnold + 27 083 778 4903 or email [email protected] for more info.

Locations by City – MAC Excel Basics – Master your Mac Pro

Mostly virtual and private consultations. Corporate onsite available T&C’s

Cape Town

Sandton – Johannesburg – Hyde Park – Bedford View – Four Ways

Centurion – Pretoria

Durban – Umhlanga – Ballito

Virtually Southern Africa

What This Course Covers

Introduction to spreadsheets
Starting excel in win 8
The excel screen
Navigating within a worksheet
Workbook views
Working with help
Working with excel
Working with the office clipboard
Entering information into excel
Creating a new workbook
Entering information
Auto complete & auto fill
Pick from drop-down list Auto fill options
Save as new name/workbook
Editing and deleting data
Working with blocks
Adjusting column width
Sheet printout options
Adjusting row height
Formulas and functions
The sum function
The auto sum feature
Working with common functions
Changing fonts & point size
Cell borders and colors
Customizing cell formats
Aligning cell data
Indenting text
Rotating text
Wrapping text within a cell
Formatting numbers
Inserting and deleting a row/column
Using cell styles
Using the format painter
Creating a chart
chart objects
Accessing other functions
Working with insert (built-in) functions
Formulas and mathematical rules
Creating a custom formula
Spell checking the worksheet
Saving your workbook
Previewing a workbook before printing
Modifying the page setup
Changing margins
Changing the print area
Setting/removing page breaks
Applying a graphics background
Defining print titles
Scaling the document
Sheet options
Accessing the page setup dialog box
Customizing headers/footers
Printing your worksheet
Closing a document
Formatting cells
Applying attributes
Applying design
Moving the chart
Selecting chart objects
Sizing the chart
Editing the chart
Printing the chart
Applying text attributes to chart objects
Changing the font of chart objects
Changing font size
Changing the font color
Applying numeric formats to
Glossary of short cut keys

This courses will prepare the delegate for more advanced MAC Excel Courses. The delegate receives a manual and an electronic attendance certificate on completion of the relevant Excel Basic MAC.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold + 27 083 778 4903 or email [email protected] for dates in your area?

ON and OFFSITE training are offered. See our Specials for Gauteng & KZN, other areas call Arnold 083 7784903. Offsite includes teas, light lunch, and an electronic attendance certificate. Group discounts apply. ONSITE, YOUR VENUE, minimum of three delegates attending simultaneously. Prices on request.

View our Excel Video tips on Youtube  

These are great Excel Tips resources

Microsoft Office ©

Simon Sez IT Youtube

Chandoo

Tutorialspoint

We provide training throughout Southern Africa and have offices in all the major cities.

Johannesburg, Pretoria, Sandton, Midrand, Centurion, Roodepoort, Edenvale, Durban, Umhlanga, Cape Town. "Other Areas on Request"

You May Also Like

MS Excel

Excel

MS Excel software package has different levels which cover many courses.
MS Excel

Excel Guru

Excel Guru software package has different levels which cover many courses.
MS Excel

MS Office

MS Office software package has different levels which cover many courses.
MS Excel

Soft Skills

Soft Skills software package has different levels which cover many courses.
Skip to content