* Cantinho Satkeys

Refresh History
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  4tj97u<z
    03 de Novembro de 2024, 10:49
  • j.s.: bom fim de semana  43e5r6 49E09B4F
    02 de Novembro de 2024, 08:37
  • j.s.: ghyt74 a todos  4tj97u<z
    02 de Novembro de 2024, 08:36
  • FELISCUNHA: ghyt74   49E09B4F  e bom feriado   4tj97u<z
    01 de Novembro de 2024, 10:39
  • JPratas: try65hytr Pessoal  h7ft6l k7y8j0
    01 de Novembro de 2024, 03:51
  • j.s.: try65hytr a todos  4tj97u<z
    30 de Outubro de 2024, 21:00
  • JPratas: dgtgtr Pessoal  4tj97u<z k7y8j0
    28 de Outubro de 2024, 17:35
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  k8h9m
    27 de Outubro de 2024, 11:21
  • j.s.: bom fim de semana   49E09B4F 49E09B4F
    26 de Outubro de 2024, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    26 de Outubro de 2024, 17:06
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana
    26 de Outubro de 2024, 11:49
  • JPratas: try65hytr Pessoal  101yd91 k7y8j0
    25 de Outubro de 2024, 03:53
  • JPratas: dgtgtr A Todos  4tj97u<z 2dgh8i k7y8j0
    23 de Outubro de 2024, 16:31
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    23 de Outubro de 2024, 10:59
  • j.s.: dgtgtr a todos  4tj97u<z
    22 de Outubro de 2024, 18:16
  • j.s.: dgtgtr a todos  4tj97u<z
    20 de Outubro de 2024, 15:04
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  101041
    20 de Outubro de 2024, 11:37
  • axlpoa: hi
    19 de Outubro de 2024, 22:24
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    19 de Outubro de 2024, 11:31
  • j.s.: ghyt74 a todos  4tj97u<z
    18 de Outubro de 2024, 09:33

Autor Tópico: Excel Microsoft 365 Office Beginner course  (Lida 77 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Online mitsumi

  • Moderador Global
  • ***
  • Mensagens: 115810
  • Karma: +0/-0
Excel Microsoft 365 Office Beginner course
« em: 06 de Agosto de 2021, 13:20 »

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 47 lectures (3h 23m) | Size: 1.45 GB
Excel Microsoft 365 Beginner creating workbooks, toolbar, formulas, functions, templates, styles

What you'll learn:
Using and creating workbooks, toolbar
Using Excel commands and features, organizing worksheets
Using and creating formulas, functions, math calculations
Using and creating templates, styles, themes

Requirements
Access to Excel 365 Software on a Computer or take notes

Description
Learn how to use and work with Excel 365 from Microsoft Office. This is a in-depth beginner class and part one of 3 courses Beginner, Intermediate and Advanced. This course covers new features of Excel 365, Starting up and working with Excel, Creating new workbooks, Organizing your worksheet, Basic formulas, Using templates and themes, and a downloadable Test Quiz is included with enclosed answer key.

This Excel 365 class is taught by a Microsoft Certified Professional and Comptia A+ Computer expert. He has been the President and owner of a computer repair, networking and software company for the past 20 years. He has 3 college degrees in computers which include computer science, programming, networking and GIS. He has programmed, designed, and created professional software programs. He has helped and taught over 3,000 clients how to use Microsoft computer software, hardware and peripherals.

In this beginner course we will go over the following:

Chapter 1: New Features for 365

Overview

How Excel is different from older versions

What is new in Excel 365

How new features are added

365 using Office and Excel

365 in the Cloud

Example of a Excel wookbook/worksheet

Chapter 2: Starting up Excel

Overview

Opening up a workbook and worksheet

The Excel Screen

Difference between a workbook, worksheet and spreadsheet

cells, gridlines, entering data, sheet tabs

The Title bar, Quick access tool bar and namebox

File tab, backstage minitool bar

Customizing and using the Ribbon and KeyTips

Finding and replacing data, undo/redo, copy and paste, selecting cells

scrolling, adjusting columns, rows

inserting and deleting rows and columns, adjusting cells

Using Autofill

Using Comments

The file, view tab, workbook window, status bar

zoom slider

font styles and effects

Chapter 3: Creating new workbooks

Overview

Entering text, numbers and dates

Editing data

More on Editing data

Designing borders and backgrounds

opening and saving workbooks

excel file formats

using conditional formatting

Chapter 4: Organizing your worksheet

Overview

Freeze panes

Split panes

creating, renaming hiding, unhiding worksheets

Format Painter

Alignment and wrap text

Formatting numbers and dates

copying and moving worksheets

hiding and unhiding rows and columns

copying and pasting data numbers, using paste special

Chapter 5: Basic Formulas

Overview

Formulas and functions

Creating basic formulas

Sum a column of numbers, autosum

copying a formula to other cells

simple formula syntax

inserting functions

auto calculate

add, subtract, multiply and divide cells

editing a range of cells

Chapter 6: Using a Template

Overview

Creating and using templates

Applying styles and themes

Conclusion

Downloadable Test Quiz is included with answer key.

Who this course is for
Business employees, home office workers for business or personal use of Excel 365


Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction