Learning Microsoft Excel 2016 for Mac Training Video

Courses For Success

AU$ 189 - (Rs 9,187)

Important information

  • Course
  • Online
  • When:

A Practical Training Course That Teaches Real World Skills In this project-based Learning Microsoft Excel 2016 for Mac video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Learning Microsoft Excel 2016 for Mac training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Learning Microsoft Excel 2016 for Mac subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Learning Microsoft Excel 2016 for Mac tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 5.5 hours to complete this course 60 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Microsoft Excel 2016 for Mac training course, expert author Guy Vaccaro will teach you everything you need to know to be able to work in Excel 2016, including managing your own workbooks, formatting worksheets, and creating and using formulas. This course is designed for the absolute beginner, meaning no previous experience with Excel is required.

You will start by learning how to manage Excel workbooks and worksheets, including creating and saving a new workbook, saving Excel files in other formats, and using the Excel 2016 templates. From there, Guy will teach you how to enter and edit data in cells. This video tutorial also covers how to use basic mathematical operators, format worksheets,...

Important information

Requirements: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...


Where and when

Starts Location

What you'll learn on the course

Basic IT training
Microsoft Excel
Basic IT
Microsoft excel training
using Excel
MS Excel
Skills and Training

Course programme

  • 01. Your Excel 2016 Journey Starts Here
    • Quick Introduction To The New Excel 2016 Interface
    • Do I Need A Microsoft Account?
    • About Your Author
    • Using The Included Working Files
    • 0105 How To Access Your Working Files
  • 02. Managing Excel Workbooks And Worksheets
    • Creating And Saving A New Workbook
    • Opening And Closing Workbooks
    • Saving And Opening Excel Files To And From OneDrive And iCloud
    • Saving Excel Files In Other Formats
    • Adding, Deleting, Moving, And Copying Worksheets
    • Using The Excel 2016 Templates
  • 03. Entering And Editing Data In Cells
    • 0301 Entering Text, Numbers, And Dates
    • 0302 Editing The Contents Of Cells
    • 0303 Undo And Redo Your Actions
    • 0304 Cut, Copy, And Paste
    • 0305 Drag And Dropping Cells
    • 0306 The Fill Handle
    • 0307 Inserting And Deleting Rows And Columns
    • 0308 Changing Column Widths And Row Heights
    • 0309 Hiding And Unhiding Rows, Columns And Sheets
    • 0310 Searching For Values In A Workbook
  • 04. Math Basics
    • 0401 Getting Started With Basic Mathematical Operators
    • 0402 Order Of Operation With BODMAS
    • 0403 Introduction To Basic Formula
    • 0404 The New Formula Builder And Quick SUMs
    • 0405 Copying Formula And Functions
    • 0406 Displaying Formulae On A Worksheet
  • 05. Formatting Worksheets
    • 0501 Selecting Cells For Formatting
    • 0502 Modifying Typeface, Font Size And Colors
    • 0503 Cell Alignment, Orientation And Merging
    • 0504 Using Number Formats
    • 0505 Adding And Removing Borders
    • 0506 Applying Date Formats To Cells
    • 0507 Format Painter And Fill Formatting
    • 0508 Clearing Cell Contents And Formatting
  • 06. Page Setup And Printing
    • 0601 Paper Size, Margins, Orientation And Scaling
    • 0602 Using A Print Area And Printing Titles
    • 0603 Using The Page Break Tools
    • 0604 Creating Headers And Footers - Method 1
    • 0605 Creating Headers And Footers - Method 2
    • 0606 Other Print Options And Checking Spelling
    • 0607 Generating A PDF From A Worksheet
  • 07. Mathematical Formulas
    • 0701 The SUM Function
    • 0702 Other Mathematical Functions - AVERAGE, MIN And MAX
    • 0703 Useful Count Functions
    • 0704 Averages, Mean, Mode, And Median
    • 0705 Using PI In Formula
    • 0706 Absolute Referencing Explained
    • 0707 Formulas Across Worksheets
    • 0708 3D Referencing
    • 0709 Making Use Of Named Ranges
    • 0710 Dates, Shapes, And Formula
    • 0711 IF Statements
  • 08. Advanced Formatting
    • 0801 Adding, Editing, Deleting, And Printing Comments
    • 0802 Creating Your Own Custom List
    • 0803 Converting To A Table For Formatting
  • 09. Security
    • 0901 Activate And Deactivate Worksheet And Workbook Protection
    • 0902 Protecting Part Of A Worksheet To Aid Data Entry
    • 0903 Password Protecting The Workbook File
  • 10. Excel 2016 Summary
    • 1001 What You Have Learned

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...