Microsoft 365 – EXCEL BASIC

Typology: Online Course
Duration: 6 hours
LanguagesItalian 

 

OBJECTIVES:

47 Video to find out how to approach and practice the personal productivity software par excellence.

Mini-video training pills that explain step by step the various features and use cases with audio, video and animations.

 

CONTENTS

Introduction: 

  • Understanding the potential of Excel
  • How to orient yourself in the workplace
  • How to use Excel in Office 365

Manage folders and worksheets: 

  • How to create and manage workbooks
  • How to create and manage worksheets
  • How to share folders on the cloud
  • How to work in real time with other users
  • How to print worksheets by adapting the content
  • How to insert and use the header and footer

 Manage cells: 

  • How to select cells, rows and columns
  • How to insert, delete and change the size of cells, rows and columns
  • How to format cells
  • How to format cells based on content
  • How to display bars, color scales and icons in cells
  • How to apply borders and hide the grid
  • How to manage cell names

 Enter data correctly: 

  • Recognize cell modes
  • How to enter numeric values
  • How to enter dates
  • How to enter times
  • How to enter percentage values
  • How to insert and format text
  • How to enter data from a drop-down list

 

Enter the formulas: 

  • How to enter a formula and use arithmetic operators
  • How to copy or move values ​​and formulas
  • How to do calculations with cells in different sheets and folders
  • How to check and correct formulas
  • Summary of Exercise 1
  • Calculating the final amount of invoices with Excel 1
  • Calculating the final amount of invoices with Excel 2
  • Calculating the final amount of invoices with Excel 3
  • Sales analysis and seller commission calculation 1
  • Sales analysis and seller commission calculation 2
  • Sales analysis and seller commission calculation 3

Excel Mobile:

  • Work with folders in OneDrive and SharePoint
  • Work with folders on your device
  • Create folders in OneDrive, on your device, or in SharePoint
  • Use the mobile interface
  • Edit cells
  • Enter the functions
  • Share OneDrive and SharePoint folders
  • Collaborate on shared folders
  • Send copy of folders
  • Insert data from an image
  • Drawing with your fingers
  • Exercise Part1
  • Exercise Part2

 

Produced by: Piazza Copernico

Content edited by: Different

Teacher: Frank Iacovelli

COURSE CODE:

OFFICE365 _ excel_base

Print Friendly, PDF & EmailPDF / PRINT