In this course, we show you how to get the most out of your work with Microsoft Excel 2013 sheets and workbooks.
This product is no longer in stock
In this course, we show you how to get the most out of your work with Microsoft Excel 2013 sheets and workbooks. Learn to work with several sheets and several books at the same time, to personalize them and to create relationships between them. In relation to the sheets, we explain actions like inserting and deleting, protecting, hiding and seeing several sheets on screen at the same time, entering data simultaneously and bringing data from other sheets. As for working with books, we teach you how to work with several books on the screen, copy data between books and create links between them. Your work with Excel 2013 will be more productive and will save you a lot of time in your day to day.
Scroll and customize Excel sheets version 2013
Working with several sheets and books in Excel 2013 02:15
Manage by browsing the spreadsheets 05:01
Learn how to navigate the Excel 04:37 sheet
Inserts and removes sheets in Excel 2013 04:46
Know the copy and move sheets option in a book 04:08
Give another name to the leaves 04:48
Color tabs of sheets 03:46
Excel 2013: Displaying and hiding sheets 04:45
Work with multiple sheets at the same time
Displaying multiple sheets of the same book 04:06
Know how to copy, insert, and move data to sheets 05:35
Group and ungroup sheets in Excel 2013 03:47
Get data to Excel from different sheets 04:41
Challenge: Apply the learned actions in a case study 01:29
Solution: Apply the learned actions in a case study 04:12
Work with several workbooks Excel 2013
View and navigate between books 04:23
Show different book sheets 04:30
Copying and moving data between books 05:05
Learn how to copy and move sheets between books 04:17
Carries data between books with formulas
It combines data from different books by creating formulas 04:21
Work with links between different books 02:07
Challenge: Create a book with data from other books 01:02
Solution: Create a book with data from other books 05:15
Examples of use of combined books and sheets 02:57
Size: 215 MB
Trainers: Yolanda Cuesta Altieri
Content: 23 Videos
Duration: 1:31 hours
Software: Excel, Excel 2013
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.