17 OCT 2024 - Welcome Back to TorrentFunk!
Get your pirate hat back out. Streaming is dying and torrents are the new trend.
Account Registration works again and so do Torrent Uploads.
We invite you all to start uploading torrents again!

TORRENT DETAILS

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

TORRENT SUMMARY

	Status:	All the torrents in this section have been verified by our verification system
Category:	Other
Infohash	ed839ddbc95fc3fceca7014ba0217a33de37eef5
Size:	2.3 GB in 59 files
Release Date(s):	Torrent Release: 22-12-2019 by user
Swarm:	0 Seeds & 0 Peers
Vote:	No votes yet.

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

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	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

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health