English | Size: 2.14 GB
Genre: eLearning
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.
http://nitroflare.com/view/F86A4586A09EE3D/UD.Microsoft-Excel-Advanced.part01.rar
http://nitroflare.com/view/3E31DAA50CDF4F0/UD.Microsoft-Excel-Advanced.part02.rar
http://nitroflare.com/view/3872701C779046E/UD.Microsoft-Excel-Advanced.part03.rar
http://nitroflare.com/view/74C911320C5BDA8/UD.Microsoft-Excel-Advanced.part04.rar
http://nitroflare.com/view/2C21927F5488628/UD.Microsoft-Excel-Advanced.part05.rar
http://nitroflare.com/view/F159B2AC741527A/UD.Microsoft-Excel-Advanced.part06.rar
http://nitroflare.com/view/4BC51653C8CAD1F/UD.Microsoft-Excel-Advanced.part07.rar
http://nitroflare.com/view/B10FC74A5EECFE4/UD.Microsoft-Excel-Advanced.part08.rar
http://nitroflare.com/view/08B36F02D8D9350/UD.Microsoft-Excel-Advanced.part09.rar
http://nitroflare.com/view/8911E50CC4F35EB/UD.Microsoft-Excel-Advanced.part10.rar
https://rapidgator.net/file/dfb3f569de1c8022363cc3986a018af1/UD.Microsoft-Excel-Advanced.part01.rar.html
https://rapidgator.net/file/c4adfe56611f706e87d3731bf842894f/UD.Microsoft-Excel-Advanced.part02.rar.html
https://rapidgator.net/file/8a98fc22fac3effb0c8744801486bd5a/UD.Microsoft-Excel-Advanced.part03.rar.html
https://rapidgator.net/file/9328839634ddfda26a74b0645bca1e68/UD.Microsoft-Excel-Advanced.part04.rar.html
https://rapidgator.net/file/bc6d27060d4316f2f8f68d2a9d47a573/UD.Microsoft-Excel-Advanced.part05.rar.html
https://rapidgator.net/file/468edf13e34ce8a7f124bc0671e61ba1/UD.Microsoft-Excel-Advanced.part06.rar.html
https://rapidgator.net/file/27886e6953692577919bb783db47ed40/UD.Microsoft-Excel-Advanced.part07.rar.html
https://rapidgator.net/file/3c5298c7ac61d76d64bdf56cfeb8a429/UD.Microsoft-Excel-Advanced.part08.rar.html
https://rapidgator.net/file/6bda7fa7cb41d34399d0ff094e851cff/UD.Microsoft-Excel-Advanced.part09.rar.html
https://rapidgator.net/file/322de1d4efd8f26c76b3e3767156ff52/UD.Microsoft-Excel-Advanced.part10.rar.html
If any links die or problem unrar, send request to
https://forms.gle/e557HbjJ5vatekDV9
Leave a Reply