TRAINING SESSION CALENDAR
  2. Courses
  3. Microsoft Excel - Getting Started with Spreadsheet

Microsoft Excel - Getting Started with Spreadsheet

Description

Meet your trainer!
Online session replay
Expand your knowledge
  • First steps
    • Introduction to Excel
    • How things are organized
    • A closer look at the ribbon
    • Get going fast
    • A first look at Excel 2016
    • Save, publish, and share
    • Share documents
    • Work simultaneously with others on a workbook
    • Improved version history
  • Create your first worksheet
    • Start using Excel
    • Insert columns and rows
    • Cell references
    • Add formulas and references
    • Copying formulas
    • Advanced formulas and references
    • AutoFill and Flash Fill
    • AutoFill
    • Flash Fill
    • Password protect workbooks and worksheets
    • Password protect workbooks and worksheets in detail
    • Microsoft Search
  • Layout and printing
    • Save and print an Excel workbook
    • Print worksheets and workbooks
    • More print options
    • Print a worksheet on a specific number of pages
    • Print headings, gridlines, formulas, and more
    • Freeze or lock panes
    • Freeze panes in detail
  • Basics actions in Excel
    • How to create a table
    • Functions and formulas
    • Use slicers to filter data
    • Drop-down lists
    • Drop-down list settings
    • Input and error messages
    • Manage drop-down lists
    • Sort and filter data
    • Sort details
    • AutoFilter details
    • Advanced filter details
    • Use conditional formatting
    • Conditionally format dates
    • Conditionally format text
    • Copy and remove conditional formatting
    • Create a chart
    • Customize charts
    • Create a combo chart
    • Create pie, bar, and line charts
    • Copy a chart
    • Create a PivotTable and analyze your data
    • Create a PivotTable report manually
    • Sort, filter, summarize and calculate your PivoteTable data
  • Basic functions
    • Basic math
    • Operator order
    • Weighted average
    • Average a group of numbers
    • More complex formulas
    • Using functions
    • Advanced IF functions
    • IFS
    • Nested IF functions
    • The SUMIF function
    • AVERAGEIF function
    • IF with AND and OR
    • COUNTIFS and SUMIFS
    • AVERAGEIFS and IFERROR
    • VLOOKUP: How and when to use it
    • The nuts and bolts of VLOOKUP
    • Copy a VLOOKUP formula
    • Look up values on a different worksheet
    • Add time
    • Subtract time
  • New features and tips
    • Start with "Ideas" in Excel
    • Automatic Data Entry in Excel
    • One click Forecasting
    • New Chart types
    • Ink Equation
    • SWITCH
    • MAXIFS & MINIFS
    • TEXTJOIN
    • CONCAT
    • Map Chart in Excel
    • 3D Maps
    • Convert a picture into Data with Excel
Don't forget the mobile version!

Microsoft Excel - Getting Started with Spreadsheet

Time Length Icon 45 min. Pictogram view Viewed 406 times
Button

Discover in this course, the latest version of Microsoft Excel. Make your job easier with value formatting features and table management. Some features will save you a significant amount of time in using this data management tool.
 

Session Theme: Microsoft Excel

Target Audience: Users who want to learn the basics of using a spreadsheet tool

Startup Level: Beginner

Prerequisite: Master independently the basic uses of computer navigation and the uses of your computer

Means and Methods:

  • The session is carried out remotely with a virtual classroom tool
  • Live interaction with a trainer enabling participants to ask questions
  • Additional videos can complete the course

Objectives: At the end of this course you will be able to create simple data tables using formulas with a quick layout

Skills:

  • Learn how to use Microsoft Excel spreadsheet tool
  • Identify the positioning of the tool: What is it used for?

Course Outline:

  • Microsoft Excel, what is the purpose?
  • Interface and vocabulary
  • Managing workbook sheets
  • Navigating a document
  • Autoformatting
  • Customizing options and views
  • Print and save

Context Elements:

It is no longer quite common to introduce Microsoft's flagship tool that is the Excel spreadsheet, but the table processing solution has continued to evolve over the years.

Through an advanced search for the uses of the tool, Microsoft has made the interface more accessible and the functionalities even richer. For a simple table as for an exploitation of large data,  Microsoft Excel has kept  its computational, processing and formatting capabilities advanced.

As much as the interface makes it easy to find its landmarks, such as the formula bar, the gridlines of columns and rows as well as the tabs, the logic of the navigation ribbon has been redesigned to be more logical:  from left to right, you will find the categories of features that are from the most used to the least used.

To familiarize yourself with this tool is to guarantee a maintenance of efficiency in the basic uses of Microsoft Excel, while discovering how to save time!

Excel
Discover
Produce