With this course you will learn to exalt the power of Excel 2016, working with more sheets and books at the same time. You will be able to move between sheets and books, customized and creating relationships between them, combining or adding data from several sheets and books at once.
This product is no longer in stock
With this course you will learn to exalt the power of Excel 2016, working with more sheets and books at the same time. You will be able to move between sheets and books, customized and creating relationships between them, combining or adding data from several sheets and books at once. Among other actions with the leaves, you will learn to hide and show, insert, remove sheets and protect them. You will also learn to see several on-screen, entering and bringing data between multiple sheets simultaneously. We will teach you to see several books on screen, copy data and create links between them. So your day-to-day with Excel will be more productive by saving time and effort.
Scroll and customize sheets in Excel 2016
Why work with more sheets and books in Excel 02:36
Browse Spreadsheets 05:17
Scroll through Excel sheet 04:20
Insert and remove sheets in Excel 2016 05:29
Copy and move worksheets in the same book 04:49
How to change in Excel the name of the sheets 03:19
Color tabs on Excel sheets 02:58
Show and hide sheets in Excel 2016 03:28
Work with different sheets at the same time
See different sheets of the same book 05:51
copying, inserting and moving data on different sheets 05:04
Group and ungroup sheets in Excel workbooks 2016 05:17
Get data from different sheets in book 04:53
Challenge: Create and modify a report from multiple sheets 01:48
Solution to the proposed challenge 06:50
Work with several Excel workbooks
Options for viewing and browsing between books 06:20
Show different sheets of different books 05:29
Copying and moving data between workbooks in Excel 2016 06:08
Copying and moving sheets between books 04:14
Create formulas between books to bring data
Create formulas to link data from different books 06:01
Work with links between different books 03:45
Challenge: Prepares a quarterly report from other monthly 01:15
Solution to the proposed challenge 05:21
Concluding recommendations and examples of use 02:56
Size: 269 MB
Content: 23 Videos
Duration: 1:43 hours
Software: Excel, Excel 2016
Base files: If included
Totally virus free and malicious software, so don't wait any longer on Descargartelo now.
Don't forget to give us an opinion about the course, to improve the content.
Note: Do not forget to follow us on our social networks of Facebook and Twitter to form part of our community and receive the notification every time we publish something new, so you will not miss anything.
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.