PacktPub | Microsoft Excel Advanced 2019 [Video] [FCO]
movies, software, shows...
Files
| 0. (1Hack.Us) Premium Tutorials-Guides-Articles & Community based Forum.url | 409 B | ||
| 0101.Prerequisites of the Course and Version of Excel.mp4 | 116 MB | ||
| 0102.Course Structure.mp4 | 64.7 MB | ||
| 0201.Functions - Part 1.mp4 | 37.6 MB | ||
| 0202.Functions - Part 2.mp4 | 21.7 MB | ||
| 0203.Autosum.mp4 | 24.6 MB | ||
| 0301.How Date and Time Works.mp4 | 34.8 MB | ||
| 0302.Basic Date and Time Functions.mp4 | 35.7 MB | ||
| 0303.Complex Date and Time Functions.mp4 | 48.7 MB | ||
| 0401.Using Text Functions - Part 1.mp4 | 70.4 MB | ||
| 0402.Using Text Functions - Part 2.mp4 | 131.9 MB | ||
| 0501.Using Logical Functions.mp4 | 37.4 MB | ||
| 0502.Exercise 01.mp4 | 6.7 MB | ||
| 0601.HLOOKUP Function.mp4 | 46.6 MB | ||
| 0602.VLOOKUP Function.mp4 | 31.5 MB | ||
| 0603.Exercise 02.mp4 | 28 MB | ||
| 0701.Financial Functions and Terminology.mp4 | 24.2 MB | ||
| 0702.Personal Financial Functions.mp4 | 36.2 MB | ||
| 0703.Professional Financial Functions.mp4 | 22.8 MB | ||
| 0704.Depreciation.mp4 | 17.9 MB | ||
| 0705.Exercise 03.mp4 | 10.7 MB | ||
| 0801.Statistical Functions for Description - Part 1.mp4 | 55.3 MB | ||
| 0802.Statistical Functions for Description - Part 2.mp4 | 52.8 MB | ||
| 0803.Statistical Functions for Forecasting - Part 1.mp4 | 39.5 MB | ||
| 0804.Statistical Functions for Forecasting - Part 2.mp4 | 44.9 MB | ||
| 0805.Exercise 04.mp4 | 8.9 MB | ||
| 0806.One Click Forecasting.mp4 | 36.7 MB | ||
| 0807.Statistical Functions for Inference.mp4 | 37.6 MB | ||
| 0901.Connecting to Other Workbooks.mp4 | 56 MB | ||
| 0902.Connecting to Access Databases.mp4 | 56.5 MB | ||
| 0903.Connecting to Web Data Sources.mp4 | 42.9 MB | ||
| 0904.Get and Transform.mp4 | 67.8 MB | ||
| 0905.Exercise 05.mp4 | 19.1 MB | ||
| 1001.Introduction to Tables.mp4 | 47.2 MB | ||
| 1002.Working with Tables.mp4 | 39.7 MB | ||
| 1003.Table References.mp4 | 36.9 MB | ||
| 1004.Table Styles.mp4 | 23.9 MB | ||
| 1005.Exercise 06.mp4 | 7.6 MB | ||
| 1101.Introduction to Pivot Tables.mp4 | 38.9 MB | ||
| 1102.Working with Pivot Tables.mp4 | 56.6 MB | ||
| 1103.Filters and Slicers.mp4 | 62.8 MB | ||
| 1104.Pivot Charts.mp4 | 31.4 MB | ||
| 1105.Exercise 07.mp4 | 12.7 MB | ||
| 1201.What If Analysis.mp4 | 36.6 MB | ||
| 1202.Scenario Manager.mp4 | 56.6 MB | ||
| 1203.Goal Seek.mp4 | 22.5 MB | ||
| 1204.Solver.mp4 | 45.8 MB | ||
| 1205.Exercise 08.mp4 | 8.1 MB | ||
| 1301.Area Charts.mp4 | 35.4 MB | ||
| 1302.Surface Charts.mp4 | 18.4 MB | ||
| 1303.Radar Charts.mp4 | 18.2 MB | ||
| 1304.Bubble Charts.mp4 | 23.3 MB | ||
| 1305.Sparklines.mp4 | 50.2 MB | ||
| 1306.Stock Charts.mp4 | 46.9 MB | ||
| 1307.Exercise 09.mp4 | 20.8 MB | ||
| 1401.Introduction to Excel Web App.mp4 | 41.5 MB | ||
| 1402.Using the Excel Web App.mp4 | 147.9 MB | ||
| 1501.Closing Message.mp4 | 11.1 MB | ||
| 2. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url | 307 B | ||
| 3. (NulledPremium.com) Download E-Learning, E-Books, Audio-Books, & more.etc.url | 204 B | ||
| 4. (FTUApps.com) Download Cracked Developers Applications For Free.url | 204 B | ||
| How you can help our Group!.txt | 204 B | ||
| exercise_files.zip | 12.1 MB | ||
| ▲ 63 total files | |||
Description
Lynda and other Courses >>> https://www.freecoursesonline.me/
For Developer Tools & Apps >>> https://ftuapps.com/
Forum for discussion >>> https://1hack.us/ 
Simon Sez IT
July 24, 2019
8 hours 5 minutes
Source: https://www.packtpub.com/programming/microsoft-excel-advanced-2019-video
Learn and master Excel 2019 by learning advanced functions and formulas
Learn
What’s new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
How to create awesome visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek, and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts
About
Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
Upon completion of this course, you’ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you’ll have advanced understanding of Excel that will positively impact your professional capability.
All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Advanced-2019
Features
Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information
Learn and master advanced charting and graphing in Excel
Course Length 8 hours 5 minutes
ISBN 9781839219832
Date Of Publication 24 Jul 2019
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
PacktPub | Microsoft Windows 10 Pro - Hands-On Training [Video] [FCO] Posted by
SunRiseZone in Other
|
2.5 GB | SunRiseZone | 5 years | 0 | 0 |
All Comments