Description

This course will allow you to understand all of Excel's functions. You will learn to create, present and print tables incorporating calculation formulas. You'll also see multi-sheet and multi-workbook management, charting, and key data analysis techniques.

Who is this training for ?

For whom ?

Anyone wishing to master the basics of Excel 2016 or 2013.

Prerequisites

Training objectives

Use the entry, copy and move functions in the cells of a workbook

Add formulas using the addressing of other cells (relative and absolute)

Format the cells of an Excel workbook

Use Excel functions of base (calculation, dates, etc.)

Present, sort and analyze data from a workbook

Layout a workbook for printing and sharing it

Training program

• Publication
  • Transform a PowerPivot table into a free format and enrich the reports.
  • Distribute, secure and share your dashboards on the web in a few mouse clicks.
  • Retrieve a PowerPivot cube in Analysis Services.
  • Practical work Publish your PowerPivot calculations and reports.
• Design and presentation of a table
  • Elaboration of needs, good practices.
  • Present a table quickly.
  • Copy or move information, improved pasting, incremental copying.
  • Automatic filling.
  • Row height, column width, cell presentation (font.
  • ).
  • Practical work Design tables calculations.
• Calculations and formulas
  • Setting up calculation formulas.
  • Relative and absolute addressing, copying formulas.
  • Calculate and use percentages, dates.
  • Discover the first functions of Excel.
  • Create formulas for linking spreadsheets.
  • Practical work Use calculation tools.
• Print settings
  • Manage the layout, different display modes.
  • Customize headers and footers.
  • Page breaks, repeat titles, define the area to print, automatic adjustment.
  • Practical work Define the layout options to present the workbook for printing
• Managing tabs and folders
  • Organize the workbook sheets.
  • Work via OneDrive, discover Excel Online, sharing possibilities.
  • Exchange information with Word or PowerPoint.
  • Practical work Working with several tabs or workbooks.
• Creating an Excel data list
  • Define, create a list of data.
  • Use table tools.
  • Enter data, use a drop-down list, integrate calculations .
  • Practical work Managing data lists.
• Data exploitation and analysis
  • The Data Analysis tag.
  • Conditional formatting.
  • Handle sorts and subtotals, use filters.
  • Removing duplicates.
  • Pivot tables.
  • Practical work Calculate significant information from lists of data.
• Creating charts
  • Choose the right type of graph according to the data.
  • Recommended graphs.
  • Personalize, filter the results.
  • Practical work rnCreate graphics.