Microsoft Excel Advanced

[voska89]

MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 3 hours | Size: 1.96 GB
Becoming an Advanced user of Microsoft Excel

What you'll learn
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.
Requirements
Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Description
MODULE 1: Grouping & Outlining and Subtotals
Learning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.
Topics covered:
Outlining and Grouping Data
Using the Subtotals Tool
MODULE 2: What-If Analysis
Learning outcomes: Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.
Topics covered:
Exploring Scenarios
Goal Seek and Data Tables
Using Solver
MODULE 3: PivotTables
Learning outcomes: Creating Pivot Tables in order to display and summarise large quantities of data effectively.
Topics covered:
Getting Started with PivotTables
Displaying Data in a PivotTable
Formatting a PivotTable
Using the Classic PivotTable Layout
Slicers
MODULE 4: Charting Pivoted Data
Learning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
Topics covered:
Getting Started with PivotCharts
Using the PivotChart Tools Tabs
Formatting a PivotChart
MODULE 5: Advanced Excel Tasks
Learning outcomes: Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.
Topics covered:
Excel and Hyperlinks
Using Custom AutoFill Lists
Sharing Workbooks
MODULE 6: Creating HLOOKUP and VLOOKUP Functions
Learning outcomes: Exploring the different Lookup functions, and how to add further functionality to a spreadsheet to reference particular data quickly and effectively.
Topics covered:
Using the VLOOKUP Function
Using the LOOKUP Function
MODULE 7: Introduction to Macros in Excel
Learning outcomes: Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
Topics covered:
Recording and Playing Macros
Copying and Deleting Macros
Visual Basic and Macros
Who this course is for:
Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time.

Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me

Download (Uploadgig)
https://uploadgig.com/file/download/96b6cdf9dd061043/kw4gk.Microsoft.Excel.Advanced.part1.rar
https://uploadgig.com/file/download/33572eAda4e51C13/kw4gk.Microsoft.Excel.Advanced.part2.rar
https://uploadgig.com/file/download/bce8C8d3dedcf3AC/kw4gk.Microsoft.Excel.Advanced.part3.rar
Download ( Rapidgator )
https://rapidgator.net/file/8ab8c783c5a300dfb3d6fd1815b83872/kw4gk.Microsoft.Excel.Advanced.part1.rar
https://rapidgator.net/file/ea3d6c54f964c83b3bed9a40c9046b1f/kw4gk.Microsoft.Excel.Advanced.part2.rar
https://rapidgator.net/file/7048ae869dda8eb6b94d07ff658ed45c/kw4gk.Microsoft.Excel.Advanced.part3.rar
Download ( NitroFlare )
http://nitroflare.com/view/C925A5EB0127A9E/kw4gk.Microsoft.Excel.Advanced.part1.rar
http://nitroflare.com/view/A4D9A590D891543/kw4gk.Microsoft.Excel.Advanced.part2.rar
http://nitroflare.com/view/167743237573842/kw4gk.Microsoft.Excel.Advanced.part3.rar