Certificate In Excel 365 Essentials Online Course

Courses For Success
Online

Precio a consultar

Información importante

  • Curso
  • Online
  • Cuándo:
    A definir
Descripción

Make Basic Changes Without Using a Computer Where Your Desktop Office Applications are Installed. Welcome to the Office 365 Excel Essentials course. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved. The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere. By the end of this Certificate In Excel 365 Essentials Online Course, you should be able to: Understand the Office 365 web interface, including the home page, the team site, and the shared documents list Understand the Excel 365 browser interface Upload a spreadsheet to the Shared Documents library Download and reload workbooks Understand saving and collaborating Build, copy and edit formulas Understand the difference between Formulas and Functions Sort and filter data Collaborate with others on a spreadsheet Use alignment options Apply borders and fill color Insert and work with Tables and Charts Insert links Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation This course is internationally recognized and accredited by the International Association of Online Training...

Información importante

Requisitos: Entry requirements Students must have basic literacy and numeracy skills. Open entry Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up...

Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online

¿Qué aprendes en este curso?

Excel
Access
Options
Basic
Basic IT training
Office IT
Spreadsheet
Basic IT
Web
Accredited
Team Training
Ms Office
MS Excel

Programa académico

Module One: Getting Started
By the end of this course, you should be able to:

  • Open and close spreadsheets
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Download and reload workbooks
  • Use the Find Command
  • Save a Copy
  • Open in Editing View
  • Open the spreadsheet in the Excel desktop application for more advanced features
  • Understand saving and collaborating
  • Create a new file
  • Enter labels and values
  • Edit data
  • Use the Wrap Command
  • Use cut, copy, and paste
  • Use Undo and redo
  • Add rows and columns
  • Delete cells
  • Understand shortcuts
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Understand Autocomplete
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Refresh and recalculate data
  • Format text and numbers
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables
  • Insert and work with Charts
  • Insert links

Module Two: Welcome to Office 365 Web Apps

  • The Home Page
  • The Team Site
  • Shared Documents
  • Uploading a Spreadsheet

Module Three: Worksheets and Workbooks

  • Opening a Spreadsheet
  • Overview of the Reading View
  • Understanding Worksheets vs. Workbooks
  • Downloading and Reloading
  • Closing Spreadsheets

Module Four: Working with Excel Files

  • Using the Find Command
  • Saving a Copy
  • Editing in Browser
  • The Excel Web App Interface
  • Opening in Excel

Module Five: Editing in the Browser (one)

  • About Saving and Save As
  • A New File and AutoSaving
  • Entering Data
  • Editing Data
  • Using the Wrap Command

Module Six: Editing in the Browser (two)

  • Cut, Copy, and Paste
  • Using Undo and Redo
  • Adding Rows and Columns
  • Deleting Cells
  • Using Timesaving Shortcuts

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Understanding Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Using AutoComplete

Module Nine: Working with Data

  • Sorting Data
  • Filtering Data
  • About Collaborating
  • About Refreshing External Data

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Adding Borders
  • Adding Fill Color

Module Eleven: The Insert Tools

  • Inserting Tables
  • Inserting Charts
  • Working with Charts
  • Inserting Links

Module Twelve: Wrapping Up
Words from the Wise