catraining

 

Microsoft Partner
Microsoft Excel 2016 for Mac Introduction

Audience: This course is designed for either beginners or those with limited experience of Microsoft Excel. In our Excel Introduction course you learn how to easily summarise data using formulas and present your results visually as charts. We then cover formatting and printing documents. The course caters for all levels of ability and includes an overview of the new Office 2016 for Mac interface.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel 2016 for Mac Introduction training course is delivered at our Training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Use the Excel 2016 ribbon and toolbars (new)
    • Create and modify existing worksheets
    • Save to the Cloud (new)
    • Edit a worksheet
    • Format a worksheet
    • Work with Excel formulas
    • Print your worksheet
    • Create a chart
    • Control the worksheet display
    • Windows equivalent shortcut keys (new)

  • Course Outline
    print this page
    Module 1: Getting Started
    • Starting and exiting from Excel
    • Using the Excel ribbon, menu and toolbars
    • Displaying Help information
    • Changing the file type and converting to PDF
    • Using and creating Custom Lists
    • Using windows keyboard shortcuts on a Mac (new)
    • Access OneDrive (new)
    • How to access Web Apps if using office 365 version (New)
    Module 2: Creating and modifying existing worksheets
    • Creating and opening workbooks
    • Adding data to a worksheet
    • Selecting ranges of cells
    • Entering worksheet data
    • Saving a workbook
    Module 3: Editing a worksheet
    • Using the Spell Checker
    • Adjusting column widths
    • Inserting and deleting a range of cells
    • Copy, move and delete cell entries
    • Find and Replace specific entries in a worksheet
    • Inserting and renaming sheet tabs
    Module 4: Formatting a worksheet
    • Changing the font style, size and colour
    • Adding alignment options, wrap text, orientation and merge cells
    • Applying borders and patterns
    • Adjusting row height and column widths
    • Changing the number format of cell entries
    • Using Styles for consistent formatting
    • Conditional formatting
     
    Module 5: Working with Excel formulas
    • Creating basic formulas
    • Use the formula builder pane (new)
    • Brackets and the order of calculation
    • Excel functions
    • Using the SUM, AVERAGE, MAX, MIN, COUNT and COUNTA functions
    • Using the formula builder
    • Using AutoFill and AutoSum
    • Using absolute and relative references
    Module 6: Printing your worksheet
    • Previewing a worksheet
    • Changing the Page Set-up of a worksheet
    • Setting the print area
    • Printing certain rows or columns on each page
    • Printing selected worksheet entries
    Module 7: Creating a chart
    • Plotting a chart
    • Previewing and printing a chart
    • Adding new data to an existing chart
    • Including multiple data ranges in a chart
    • Uses of the different chart types
    • Use the Recommended Charts feature (new)
    Module 8: Controlling the worksheet display
    • Splitting the workbook window into panes by freezing panes
    • Hiding rows and columns
    • Changing the zoom level for a worksheet
    • Sorting and filtering worksheet data
     
      Microsoft

Call us now for further information Tel:08001601666