* Cantinho Satkeys

Refresh History
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana   4tj97u<z
    15 de Fevereiro de 2025, 16:34
  • j.s.: tenham um excelente fim de semana  49E09B4F
    14 de Fevereiro de 2025, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    14 de Fevereiro de 2025, 17:06
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    14 de Fevereiro de 2025, 11:24
  • cereal killa: ghyt74 pessoal  classic
    14 de Fevereiro de 2025, 10:08
  • JPratas: try65hytr Pessoal  classic k7y8j0 h7ft6l
    14 de Fevereiro de 2025, 03:52
  • JPratas: dgtgtr A Todos  4tj97u<z k7y8j0 yu7gh8
    13 de Fevereiro de 2025, 18:08
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    13 de Fevereiro de 2025, 11:32
  • j.s.: try65hytr a todos  4tj97u<z
    12 de Fevereiro de 2025, 21:00
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    08 de Fevereiro de 2025, 11:36
  • j.s.: tenham um excelente fim de semana  43e5r6 49E09B4F
    07 de Fevereiro de 2025, 20:23
  • j.s.: try65hytr a todos  4tj97u<z
    07 de Fevereiro de 2025, 20:23
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    07 de Fevereiro de 2025, 11:24
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    07 de Fevereiro de 2025, 04:15
  • j.s.: dgtgtr a todos  49E09B4F
    06 de Fevereiro de 2025, 14:24
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    05 de Fevereiro de 2025, 11:33
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    05 de Fevereiro de 2025, 02:35
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana   4tj97u<z
    01 de Fevereiro de 2025, 11:59
  • j.s.: tenham um excelente fim de semana  49E09B4F
    31 de Janeiro de 2025, 21:20
  • j.s.: try65hytr a todos  4tj97u<z
    31 de Janeiro de 2025, 21:20

Autor Tópico: Excel Basics Helpful Tips & Formulas for Excel  (Lida 340 vezes)

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

Offline mitsumi

  • Moderador Global
  • ***
  • Mensagens: 118061
  • Karma: +0/-0
Excel Basics Helpful Tips & Formulas for Excel
« em: 26 de Junho de 2019, 11:23 »

Excel Basics: Helpful Tips & Formulas for Excel
.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 590 MB
Duration: 1 hours | Genre: eLearning Video | Language: English
Learn how to quickly format, view, and organize your Microsoft Excel data using easy formulas and built-in tools.

What you'll learn

    How to use Text to Columns
    How Remove Duplicates
    How to use VLOOKUP
    How to use Concatenate
    IF functions
    How to use Average/Sum/Median
    How to create and use Pivot Tables
    How to create Conditional Formatting
    Freezing top rows and first columns
    Filter from A-Z
    Creating a graph/chart
    Creating a graph with a secondary axis

Requirements

    Be able to open a basic excel spreadsheet

Description

Microsoft Excel is used by millions of people around the world every day. It is an extremely powerful tool that allows individuals and businesses to easily sort, search, and review large sets of data.

While there are endless possibilities for how to use Excel, there are a number of basic formulas and built-in tools that everyone should know. You can learn these basic tips in under an hour and once you've mastered them you'll be using Excel faster and more efficiently than ever before.

In this course I'm going to show you how to use the following:

    Section 1: Must Know Formulas

        Text To Column: Split the text into multiple columns based on pre-determine break points

        Remove Duplicates: Easily clean up large lists and columns.

        VLOOKUP: For a specified value, the function finds (or 'looks up') the value in one column of data, and returns the corresponding value from another column

        CONCATENATE: link (things) together in a chain or series

        'IF' Function: An if statement is a programming conditional statement that, if proved true, performs a function or displays information

        Average/Sum/Median: Quickly get basic information about your data

    Section 2: Filters & Conditions

        Create a Pivot Table to better view large sets of data

        Use Conditional Formatting to visualize your data

        Freeze Top Row and First Column

        Filter A-Z, by Date, and Numerically

    Section 3: Making a Chart

        Create your basic chart using Pivot Table data

        Create a chart with a Secondary Axis to compare two sets of data at once

This course is perfect for those looking to get a leg-up on their peers, those who use Excel for any function, and those looking to better understand how to take control of their data.

I've been teaching classes on business subjects like Digital Advertising & Marketing, Public Speaking, Email Marketing, and more. Here are some real life review from other classes:

Who this course is for:

    Anyone working in a sales role
    Students working in Excel
    Anyone who's job requires reporting in Excel
    Any data heavy jobs
    Anyone interested in becoming more efficient in using Excel
             

               
 
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