Don't like banners? Log in and we will make sure you see no banners. For free.
[FreeCoursesOnline.Me] PacktPub - Microsoft Excel Advanced 2019 [Video]

[FreeCoursesOnline.Me] PacktPub - Microsoft Excel Advanced 2019 [Video]

Other
Size
2.3 GB
Seeders
0
Leechers
0
Files
59
Category
Other
Added
at 7:17pm GMT+1
Infohash
ed839ddbc95fc3fceca7014ba0217a33de37eef5
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

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 Length8 hours 5 minutes
ISBN9781839219832
Date Of Publication24 Jul 2019




File list
  • [FreeCoursesOnline.Me] PacktPub - Microsoft Excel Advanced 2019 [Video]
  • 0. Websites you may like/How you can help our Group!.txt 208 B
  • 01.Introduction to Excel 2016 Advanced Course/0101.Prerequisites of the Course and Version of Excel.mp4 116 MB
  • 01.Introduction to Excel 2016 Advanced Course/0102.Course Structure.mp4 64.7 MB
  • 02.Functions/0201.Functions - Part 1.mp4 37.6 MB
  • 02.Functions/0202.Functions - Part 2.mp4 21.7 MB
  • 02.Functions/0203.Autosum.mp4 24.6 MB
  • 03.Date and Time Functions/0301.How Date and Time Works.mp4 34.8 MB
  • 03.Date and Time Functions/0302.Basic Date and Time Functions.mp4 35.7 MB
  • 03.Date and Time Functions/0303.Complex Date and Time Functions.mp4 48.7 MB
  • 04.Text Functions/0401.Using Text Functions - Part 1.mp4 70.4 MB
  • 04.Text Functions/0402.Using Text Functions - Part 2.mp4 131.9 MB
  • 05.Logical Functions/0501.Using Logical Functions.mp4 37.4 MB
  • 05.Logical Functions/0502.Exercise 01.mp4 6.7 MB
  • 06.Lookup Functions/0601.HLOOKUP Function.mp4 46.6 MB
  • 06.Lookup Functions/0602.VLOOKUP Function.mp4 31.5 MB
  • 06.Lookup Functions/0603.Exercise 02.mp4 28 MB
  • 07.Financial Functions/0701.Financial Functions and Terminology.mp4 24.2 MB
  • 07.Financial Functions/0702.Personal Financial Functions.mp4 36.2 MB
  • 07.Financial Functions/0703.Professional Financial Functions.mp4 22.8 MB
  • 07.Financial Functions/0704.Depreciation.mp4 17.9 MB
  • 07.Financial Functions/0705.Exercise 03.mp4 10.7 MB
  • 08.Statistical Functions/0801.Statistical Functions for Description - Part 1.mp4 55.3 MB
  • 08.Statistical Functions/0802.Statistical Functions for Description - Part 2.mp4 52.8 MB
  • 08.Statistical Functions/0803.Statistical Functions for Forecasting - Part 1.mp4 39.5 MB
  • 08.Statistical Functions/0804.Statistical Functions for Forecasting - Part 2.mp4 44.9 MB
  • 08.Statistical Functions/0805.Exercise 04.mp4 8.9 MB
  • 08.Statistical Functions/0806.One Click Forecasting.mp4 36.7 MB
  • 08.Statistical Functions/0807.Statistical Functions for Inference.mp4 37.6 MB
  • 09.Connecting to External Data/0901.Connecting to Other Workbooks.mp4 56 MB
  • 09.Connecting to External Data/0902.Connecting to Access Databases.mp4 56.5 MB
  • 09.Connecting to External Data/0903.Connecting to Web Data Sources.mp4 42.9 MB
  • 09.Connecting to External Data/0904.Get and Transform.mp4 67.8 MB
  • 09.Connecting to External Data/0905.Exercise 05.mp4 19.1 MB
  • 10.Tables/1001.Introduction to Tables.mp4 47.2 MB
  • 10.Tables/1002.Working with Tables.mp4 39.7 MB
  • 10.Tables/1003.Table References.mp4 36.9 MB
  • 10.Tables/1004.Table Styles.mp4 23.9 MB
  • 10.Tables/1005.Exercise 06.mp4 7.6 MB
  • 11.Pivot Tables/1101.Introduction to Pivot Tables.mp4 38.9 MB
  • 11.Pivot Tables/1102.Working with Pivot Tables.mp4 56.6 MB
  • 11.Pivot Tables/1103.Filters and Slicers.mp4 62.8 MB
  • 11.Pivot Tables/1104.Pivot Charts.mp4 31.4 MB
  • 11.Pivot Tables/1105.Exercise 07.mp4 12.7 MB
  • 12.Data Analysis/1201.What If Analysis.mp4 36.6 MB
  • 12.Data Analysis/1202.Scenario Manager.mp4 56.6 MB
  • 12.Data Analysis/1203.Goal Seek.mp4 22.5 MB
  • 12.Data Analysis/1204.Solver.mp4 45.8 MB
  • 12.Data Analysis/1205.Exercise 08.mp4 8.1 MB
  • 13.Graphs and Charts/1301.Area Charts.mp4 35.4 MB
  • 13.Graphs and Charts/1302.Surface Charts.mp4 18.4 MB
  • 13.Graphs and Charts/1303.Radar Charts.mp4 18.2 MB
  • 13.Graphs and Charts/1304.Bubble Charts.mp4 23.3 MB
  • 13.Graphs and Charts/1305.Sparklines.mp4 50.2 MB
  • 13.Graphs and Charts/1306.Stock Charts.mp4 46.9 MB
  • 13.Graphs and Charts/1307.Exercise 09.mp4 20.8 MB
  • 14.Excel Web App/1401.Introduction to Excel Web App.mp4 41.5 MB
  • 14.Excel Web App/1402.Using the Excel Web App.mp4 147.9 MB
  • 15.Course Conclusion/1501.Closing Message.mp4 11.1 MB
  • Exercise Files/exercise_files.zip 12.1 MB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2.5 GB02