Excel 2016 - PC

Rapid Skillz

Course

Online

£ 47.45 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

In this Excel 2016 – PC online course, you’ll learn how Microsoft® Excel® 2016 delivers many new features and updates to the user experience and core functionality. With online integration with OneDrive®, Excel 2016 is a first-class spreadsheet tool.
Presented by Dan Fanella, this Excel 2016 – PC training course will teach you the latest tips and tricks for working with formulas, tables, charts, and more. By the time you’re finished with this course, you’ll have a deep understanding of working with your data – from sharing and securing, to importing and exporting.
This training course is for Microsoft Office Excel 2016 for Windows.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

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

  • MS Excel
  • PC training
  • PC
  • Spreadsheet
  • Excel
  • Export
  • Import
  • Conditional Formatting
  • Data tables
  • Pivot tables
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

A. Getting Started
  • What you’ll learn in this training
  • Excel spreadsheet structure overview
  • Creating and saving an Excel file
  • Interface overview
B. Work with Data and Datasets
  • Enter data into a cell
  • Create a dataset
  • Auto-fill data
  • Create simple calculations
  • Referencing cells
  • Auto-fill cell references
  • Format cell data
  • Cut and paste data
C. Create Formulas
  • Create multiple calculation formulas
  • Use AutoSum
  • Create an averaging formula
  • Retrieve the min and max value
  • Retrieve the number count
  • Create a correlation
  • Access and search for built in formulas
D. Manage Data and Datasets
  • Trace precedents
  • Trace dependents
  • Sort data
  • Changing text to columns
  • Setup data validation
  • Delete and insert columns and rows
E. Format Your Table
  • Merge cells
  • Label data
  • Change cell background color
  • Change table format
  • Freeze panes
  • Create conditional formatting
  • Insert images and objects
F. Work with Sheets
  • Name and add sheets
  • Reference cells in other sheets
G. Work with Charts
  • Insert a chart
  • Edit a chart
  • Change the chart type
  • Change chart data
H. Share and Secure Data
  • Protect a sheet
  • Hide and unhide columns and rows
  • Add comments to a cell
  • Save to OneDrive®
  • Invite people to share
I. Import and Export Data
  • Import data from text
  • Import data from Access®
  • Import data from XML file
  • Export Excel as CSV
  • Export spreadsheets to PDF
  • Export data as tab delimited text
  • Printing spreadsheets

Additional information

LENGTH

1 hour 50 min

See related categories

Excel 2016 - PC

£ 47.45 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all