Microsoft Excel 2016 for Mac Intermediate

Audience: Aimed at users with some experience in working with Microsoft Excel wanting to broaden their knowledge, our Excel Intermediate course focuses on unleashing the power of Excel formulas and functions to manipulate worksheet data and includes a brief guide to summarising data with filters, subtotals and tables. The course includes a tour 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 Intermediate 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

 

After completing this course, students will be able to:

• • Use Excel formulas confidently
  • Manipulate data with text functions
  • Use Logical and Lookup functions
  • Link Worksheets
  • Analyse Worksheet data
  • Protect Excel documents
  • Save time formatting worksheets
  • Restrict data entry using rules and drop down lists

---

Course Outline



Module 1: Essential Formulas

• Quick overview of the improved ribbon for those who are upgrading from 2008 or 2011
• Entering and copying formulas quickly and easily
• Using Absolute references in formulas
• Date calculations
• TODAY, NOW and NETWORKDAY functions
• Use the formula builder pane
• Using named ranges in formulas
  

Module 2: Manipulating data with text formulas

• Concatenation; joining data together
• Fixing formula results using Paste as Values
• Splitting data using Text to Columns
• Changing case using UPPER, LOWER and PROPER
• Extracting data using LEFT, RIGHT and MID
• Dealing with space characters using LEN and TRIM
  

Module 3: Logical and Lookup Formulas

• Aggregate data using the COUNTIFS and SUMIFS functions
• IFERROR and IFNA for correcting error values
• Using the IF function for decision making
• AND, OR, XOR and NOT functions
• VLOOKUP and HLOOKUP functions

Module 4: Linking Worksheets

• Moving the cell pointer from one worksheet to another
• Copying data from one worksheet to another
• Entering formulas to link related worksheets
• Linking Excel workbook files
• Formatting multiple worksheets in one operation
• Moving and copying worksheets

 

Module 5: Analysing Worksheet Data

• What is a Table?
• Tables or Ranges?
• Sorting ranges and tables
• Filtering lists and tables using AutoFilter
• Adding Subtotals and nested Subtotals
• Creating a Pivot Table report
• Changing the summary function in a Pivot Table report
  

Module 6: Protecting Excel documents

• Locking and Unlocking cells
• Worksheet protection
• Workbook protection

Module 7: Save Time Formatting Worksheets

• Excel styles
• Modify Normal Style to format all the worksheet cells
• Create custom number and date formats
• Excel workbook template files
• Creating and using Templates

Module 8: Data Validation

• Restricting data entry for ranges using validation rules
• Setting the input message and error alert
• Creating drop down lists

 

---

Call us now for further information Tel:08001601666