Learning Microsoft Excel 2016 Training Video

Course

Online

£ 97.69 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

A Practical Training Course That Teaches Real World Skills In this project-based Learning Microsoft Excel 2016 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 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 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 tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 8.5 hours to complete this course  82 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 training course, expert author Guy Vaccaro will teach you everything you need to know to begin creating and managing spreadsheets in Excel 2016. This course is designed for the absolute beginner, meaning no experience with Excel is required.

You will start by learning how to manage workbooks and worksheets, then jump into learning how to enter and edit data in cells. From there, Guy will teach you about formulas and functions, formatting, and page setup and printing. This video tutorial will also cover workbook and worksheet management, mathematical formulas, security, and charts in detail. Finally, you will learn about advanced formulas, including using an IF formula, text manipulation using...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Management
  • Excel
  • Security
  • Microsoft Excel
  • Printing
  • IT Security
  • Microsoft excel training
  • MS Excel
  • IT Management
  • Skills and Training

Course programme

  • 01. Start Here
    • Get Started With Excel 2016
    • New Tell Me Feature
    • Excel Workbook And Worksheets
    • Customizing Color Schemes And Quick Toolbar
    • Using The Included Working Files
    • About The Author
    • 0107 How To Access Your Working Files
  • 02. Managing Workbooks And Worksheets
    • Creating And Saving New Workbooks
    • Opening Workbooks And Save As Options
    • Saving And Opening OneDrive Files
    • Navigating An Excel Workbook
    • Adding Removing And Renaming Worksheets
    • Using The 2016 Templates
  • 03. Entering And Editing Data In Cells
    • 0301 Entering And Editing Text Numbers And Dates
    • 0302 Cut Copy Paste Vs Drag And Drop
    • 0303 Special Features Of The Fill Handle
    • 0304 Managing Columns And Rows
    • 0305 Searching Within A Worksheet Workbook
  • 04. Math: The Basics
    • 0401 Normal Mathematic Operators
    • 0402 Starting With Basic Functions
    • 0403 Copying Formula
    • 0404 Displaying Formula And Functions
  • 05. Formatting
    • 0501 Cell And Range Selection
    • 0502 Modifying Typeface Size Colors
    • 0503 Number Formats Alignment And Orientation
    • 0504 Merging And Wrapping Cell Contents
    • 0505 Cell Borders
    • 0506 Applying Editing Date Formats
    • 0507 The Format Painter
    • 0508 Clearing Finding And Replacing Formatting
  • 06. Workbook And Worksheet Management
    • 0601 Worksheet Navigating Copying Moving And Tab Color
    • 0602 Side By Side Comparison Of Worksheets
    • 0603 Modifying More Than One Sheet At A Time
  • 07. Page Setup And Printing
    • 0701 Controlling Print And Screen Headings
    • 0702 Orientation Margins And Scaling
    • 0703 Headers And Footers
    • 0704 Using Page Break And Page Layout Views Effectively
    • 0705 Printing Parts Of A Worksheet
    • 0706 Spellchecking And Smart Lookup
  • 08. Mathematical Formulas
    • 0801 The Sum Function
    • 0802 Other Mathematical Functions Average Min Max
    • 0803 Various Count Functions
    • 0804 Absolute Referencing
    • 0805 Formula Across Multiple Sheets
    • 0806 3D Referencing In Action
    • 0807 The Advantages Of Named Cells And Ranges
  • 09. Security
    • 0901 Protection Of Whole Or Part Worksheets
    • 0902 Protection For The Whole Excel Workbook
  • 10. Charts In Excel
    • 1001 Using The Recommended Charts Option
    • 1002 Create A Chart Quickly Or Slowly
    • 1003 Formatting A Chart
    • 1004 Modifying The Chart Type
    • 1005 Formatting Chart Elements
    • 1006 Adding A Trendline
    • 1007 The Pie Chart
    • 1008 Sparklines Mini Charts
    • 1009 The New Forecast Sheet
    • 1010 New To 2016 Chart Types
  • 11. Graphics Objects
    • 1101 Inserting And Enhancing Images
    • 1102 Inserting Shapes And Screenshots
    • 1103 Using SmartArt Graphics
    • 1104 Formatting Graphical Objects
    • 1105 Stacking Grouping And Flowcharts
    • 1106 A Mathematical Formula With A Graphic Object
  • 12. Excel As A Database
    • 1201 Fixing Onscreen And In Print Rows And Columns
    • 1202 Sorting Data
    • 1203 Filter Data To Reduce Dataset Size
    • 1204 Removing Duplicate Entries
    • 1205 Using Subtotals In A Worksheet Of Data
    • 1206 Using Text To Columns
    • 1207 The New Get And Transform For Using Web Data
  • 13. Advanced Formula
    • 1301 Using An IF Formula
    • 1302 New IFs For Multiple Criteria
    • 1303 DATEDIF A Useful Hidden Function
    • 1304 Text Manipulation Functions
    • 1305 Use Of Text To Format Numbers
    • 1306 Date Manipulation Functions
    • 1307 Introducing SUMIF COUNTIF AVERAGEIF
    • 1308 Use Of Rank To Calculate Placings
    • 1309 Flash Fill The Magic Touch
  • 14. What's Next
    • 1401 Office Apps For Excel 2016
    • 1402 Are You Ready To Go Advanced

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 purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

Learning Microsoft Excel 2016 Training Video

£ 97.69 + VAT

*Indicative price

Original amount in AUD:

$ 189