Learn in this course Excel for Essential Mac - Discover the 365 version of Excel for Mac and its tools
This product is no longer in stock
Information for: Office 365: Excel for Mac essential
Learn in this essential Excel course for Mac - Discover version 365 of Excel for Mac and its tools
Excel for Mac and Excel for Windows are exactly the same in terms of the appearance and organization of menus and commands, which facilitates the work shared between followers of Apple and Microsoft without fear of spreadsheets. In this course you will learn how Excel works in its version for Office 365 and, whether you already know previous versions of Excel for Mac or if you are approaching this program for the first time, this training is designed for you to start using it without hesitation and without fear .
The new Excel 365 interface
In this chapter we will know the novelties and all the other elements that have changed visually in the new Microsoft Excel 365 in its version for Mac. We could practically say that it is the same as for Windows.
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. We start step by step with the fundamental, so that nobody gets lost in the boot.
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
The changes in the treatment of the files, especially when creating new ones and sharing them with other users via online, are subjects of compulsory learning 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
Some obvious protagonists of Excel are the cells. These are the center of almost everything that is done in any spreadsheet. We will learn all about the introduction and editing of data in them.
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
There is no handling of a spreadsheet if the measurements of the columns and rows are not mastered. The organization of the information will depend to a large extent on the use we make of rows, columns and leaves. Let's see in this video how 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 the world of the company, not only does the content count, the image must also be taken care of.
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
Functions are instructions that return a desired value in Excel. They represent a big step for the uninitiated user, since it is a beginning for obtaining a high productivity in the calculation.
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
Learning how to manage and analyze data in a table is very important. 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
Size: 388 MB
Formators: José Manuel Pomares
Content: 58 Videos
Duration: 3:02 hours
Software: Excel, Excel for Mac 2016, Office for Mac
Base Files: Yes Includes
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
If you like or help this article. Support the developers by buying this material.
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.
|OS||Windows XP o superior|
|File Size||388 MB|
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.