Office 365 Excel Course for Essential Mac


Learn in this course Excel for Essential Mac - Discover the 365 version of Excel for Mac and its tools

Office 365 Excel Course for Essential Mac

In this course you will learn how to use the new Excel interface, we will also see how to work with the files, create and share them. You can learn how to work with formulas and other Excel functions.

The new Excel 365 interface

In this chapter we will know the novelties and elements that have changed visually in the new Microsoft Excel 365.

    What's new in the Excel 365 for Mac interface 01:49
    The backstage of Excel 365 for Mac 02:34
    The ribbon of Excel 365 04:53
    The Excel 365 window 02:23
    Views and immobilization of panels in Excel 365 02:36

We started working on Excel 365

This chapter is dedicated to facilitating the first steps in the use of Microsoft Excel for new users.

    First steps, we open a file in Excel 365 01:26
    Structure of an Excel 365 book 01:11
    The help of Excel 365 02:11

We handle Excel 365 files

Here we will learn to create new files and when sharing them with other users via online, these are basic functions that we must learn if we want to master Excel 365 perfectly.

    New files and templates in Excel 365 02:24
    Save and Save as in Excel 365 02:10
    Print in Excel 365 02:18
    Share files with other Excel 365 users 02:01
    Export Excel 365 files to other formats 02:11
    Excel 365 account options 01:18

Cells and formulas introduction in Excel 365

In this chapter we will learn everything about the introduction and edition of data in them, which are the basis of everything that is done in Excel.

    Selection of cells and ranges of cells in Excel 365 03:02
    Editing cells in Excel 365 02:01
    Data Formats in Excel 365 03:11
    What is a formula in Excel 365 and what distinguishes it 01:57
    The operators in Excel 365 03:06
    Using parentheses in Excel 365 02:39
    Concatenate with Ampersand in Excel 365 03:05
    Copy and paste values ​​and formulas in Excel 365 04:12
    Relative and absolute references in Excel 365 06:37
    Fill cells automatically in Excel 365 05:00

Handle rows, columns and sheets in Excel 365

Here we will see how to work with rows, columns and sheets, measurements of them, editing, elimination in order all the basic functions to work with them.

    Height and width of rows and columns in Excel 365 03:11
    Insert and delete cells, rows and columns in Excel 365 03:32
    Hide and show rows and columns in Excel 365 02:23
    Moving rows and columns in Excel 365 01:13
    Insert and delete leaves in Excel 365 01:21
    Rename and tag color to an Excel spreadsheet 00:53
    Move and duplicate spreadsheets in Excel 365 02:43
    Simultaneous selection of several sheets in Excel 02:28
    Browsing Excel sheets 365 01:16

We apply formatting to cells and data in Excel 365

By controlling the application of formats we will also have a large part of the control of the appearance of our reports in Excel. In this chapter we will learn all about the formats.

    Formats and default styles in Excel 365 02:52
    Aligning the contents of a cell in Excel 365 04:27
    Application of text formats in Excel 365 02:05
    Application of number formats in Excel 365 04:12
    Application of date and time formats in Excel 365 02:19
    Fillers for Excel 365 cells 01:57
    Controlling the edges of a cell in Excel 365 02:57
    Comments in Excel 365 cells 02:38

Functions in Excel 365, beyond the formulas

The functions are a big step for the uninitiated user, since it is a beginning to obtain a great productivity in the calculation, since they facilitate the work and it is done in a more efficient way.

    What is a function in Excel 365 04:24
    The function assistant of Excel 365 02:24
    Autosum and other quick functions of Excel 365 01:45
    The functions of Excel SUMIF and ROUND 04:23
    The SI function of Excel 365 07:57
    The functions of Excel LEFT, RIGHT and MAYUSC 03:43
    COUNT and COUNTIF. Sister functions in Excel 365 02:17
    The popular VLOOKUP function of Excel 365 04:34
    Functions TODAY, NOW, DAY, MONTH and YEAR in Excel 365 02:59

Data management in Excel 365 tables

It is the natural way to organize Microsoft Excel information, so we will learn it in the videos in this chapter.

    How to organize the data in Excel 365 spreadsheets 04:58
    Introduction to Excel 365 Tables 04:12
    We apply style to an Excel 365 Table 03:19
    Filtering data in Excel 365 04:45
    Introduction to Dynamic Tables in Excel 365 09:32

Insert charts in Excel 365

If used with common sense, a graph is the best method to transmit numerical information, especially if the recipient of that information has little time and little detailed knowledge of the data.

     What is a graph and when to use it in Excel 365 02:36
     Simple graphics of columns in Excel 365 05:56
     Circular, line and area graphics in Excel 365 04:23

Technical data:

     Format: .MP4
     Resolution: 1280x720p
     Size: 387 MB
     Spanish Language
     Formators: José Manuel Pomares
     Content: 58 Videos
     Duration: 3:02 hours
     Software: Excel, Excel for Mac 2016, Office for Mac
     Base Files: Yes Includes

See Intro

Totally free of viruses and malicious software, so do not wait any longer to download it now.

Do not forget to give us an opinion about the program, to improve the content

Download area


Base File

Follow us on our social networks

NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.



Muy bueno el curso lo recomendamos

    Write your review!

    Write a review

    Office 365 Excel Course for Essential Mac

    Office 365 Excel Course for Essential Mac

    Learn in this course Excel for Essential Mac - Discover the 365 version of Excel for Mac and its tools

    Ask a question

    NO registration required!

    If the question you have has not yet been answered here, use the form below to ask something about this addon.

    *(Required to be notified when an answer is available)

    If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form