Learn with this course Excel 2016 for Mac essential - Discover the 2016 version of Excel for Mac and its tools
This product is no longer in stock
Information of: Excel 2016 for Mac essential
Learn with this Excel 2016 course for Mac essentials - Discover the 2016 version of Excel for Mac and its tools
Microsoft has done a complete renovation for Mac users of the market leading spreadsheet: Excel 2016. In this course you will see that Excel for Mac and Excel for Windows are exactly the same in terms of the user interface, which favors Work for users who work on both platforms. Those who already know previous versions of Office for Mac will discover in this course how to work with this new interface.
The new Excel 2016 interface
In this chapter we will know the news and all the other elements that have changed visually in the new Microsoft Excel 2016 in its version for Mac. We could practically say that it is the same as for Windows.
What's new in the Excel 2016 interface for Mac 01:49
The backstage of Excel 2016 for Mac 02:34
The ribbon of Excel 2016 04:53
The Excel 2016 window 02:23
Views and immobilization of panels in Excel 2016 02:36
We started working on Excel 2016
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 2016 01:26
Structure of an Excel 2016 book 01:11
The help of Excel 2016 02:11
We handle Excel 2016 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 2016 perfectly.
New files and templates in Excel 2016 02:24
Save and Save as in Excel 2016 02:10
Print in Excel 2016 02:18
Share files with other Excel 2016 users 02:01
Export Excel 2016 files to other formats 02:11
Excel 2016 account options 01:18
Cells and formulas introduction in Excel 2016
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 2016 03:02
Editing cells in Excel 2016 02:01
Data formats in Excel 2016 03:11
What is a formula in Excel 2016 and what distinguishes it 01:57
The operators in Excel 2016 03:06
Using parentheses in Excel 2016 02:39
Concatenate with Ampersand in Excel 2016 03:05
Copy and paste values and formulas in Excel 2016 04:12
Relative and absolute references in Excel 2016 06:37
Fill cells automatically in Excel 2016 05:00
Handle rows, columns and sheets in Excel 2016
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 2016 03:11
Insert and delete cells, rows and columns in Excel 2016 03:32
Hide and show rows and columns in Excel 2016 02:23
Moving rows and columns in Excel 2016 01:13
Insert and remove sheets in Excel 2016 01:21
Rename and tag color to an Excel spreadsheet 00:53
Move and duplicate spreadsheets in Excel 2016 02:43
Simultaneous selection of several sheets in Excel 02:28
Browsing the Excel sheets 2016 01:16
We apply formatting to cells and data in Excel 2016
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 2016 02:52
Alignment of the contents of a cell in Excel 2016 04:27
Application of text formats in Excel 2016 02:06
Application of number formats in Excel 2016 04:12
Application of date and time formats in Excel 2016 02:19
Fillers for Excel 2016 cells 01:57
Controlling the edges of a cell in Excel 2016 02:57
Comments in Excel 2016 cells 02:38
Functions in Excel 2016, 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 2016 04:24
The Excel 2016 Function Wizard 02:24
Autosum and other quick functions of Excel 2016 01:45
The functions of Excel SUMIF and ROUND 04:23
The SI function of Excel 2016 07:57
The functions of Excel LEFT, RIGHT and MAYUSC 03:44
COUNT and COUNTIF. Sister functions in Excel 2016 02:17
The popular VLOOKUP function of Excel 2016 04:34
Functions TODAY, NOW, DAY, MONTH and YEAR in Excel 2016 02:59
Data management in Excel 2016 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 2016 spreadsheets 04:58
Introduction to Excel Tables 2016 04:12
We apply style to an Excel Table 2016 03:19
Filtering data in Excel 2016 04:45
Introduction to Dynamic Tables in Excel 2016 09:32
Insert graphics in Excel 2016
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 chart and when to use it in Excel 2016 02:36
Simple graphics of columns in Excel 2016 05:56
Circular, line and area graphics in Excel 2016 04:23
Size: 387 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||387 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.