English | .MP4 | Audio: aac, 44100 Hz, mono | Video: h264, yuv420p, 1280x720, 15.00 fps(r) | 370 MB
Genre: E-learning
Sometimes multiple worksheets or workbooks are the only solution to storing large amounts of data. But how do you analyze data that's spread out that way?
In this course, author Dennis Taylor shows you how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013. Learn how to insert, delete, move, and copy data from multiple sheets; hide and un-hide sheets; and make global changes. Plus, discover how to create simple formulas that connect different worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use PivotTables to summarize data from multiple workbooks.
Topics include: Download Links: Exc13 Mng Worksht.part1.rar or Exc13 Mng Worksht.part1.rar
Navigating across worksheets and workbooks
Displaying multiple worksheets or workbooks simultaneously
Inserting, deleting, moving, and copying sheets
Changing sheet names and tab colors
Showing and hiding worksheets
Creating linkage formulas among workbooks
Locating and managing links
More Info
Exc13 Mng Worksht.part2.rar
Exc13 Mng Worksht.part3.rar
Exc13 Mng Worksht.part4.rar
Exc13 Mng Worksht.part2.rar
Exc13 Mng Worksht.part3.rar
Exc13 Mng Worksht.part4.rar
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.