MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 3.5 hours | Size: 2.14 GB
Improving your performance by learning some of the more popular Excel features
What you’ll learn
This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, 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 course.
Description
MODULE 1: Advanced File Tasks
Learning outcomes: A look at some important administrative features which are useful for managing and controlling Excel files.
Topics covered:
Saving and File Management
Converting and Encrypting Files
File Properties and Digital Signatures
File Accessibility and Compatibility
MODULE 2: Working with Functions and Formulas
Learning outcomes: Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.
Topics covered:
Formulas with Absolute References
Autosum Functions (SUM & AVERAGE)
IF and Nested Functions
Working with Named Ranges
Array Functions (SUMIF & AVERAGEIF)
Formula Auditing
Text Functions
MODULE 3: Managing Tables in Microsoft Excel
Learning outcomes: Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.
Topics covered:
Creating Excel Tables
Working with Records and Filters
Advanced Filters
MODULE 4: Data Tools in Excel
Learning outcomes: Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.
Topics covered:
Text to Columns
Flash Fill
Remove Duplicates
Data Validation
Consolidate
MODULE 5: Doing More with Charts in Excel
Learning outcomes: Developing your ability to effectively create charts and format them specific to the reader
Topics covered:
Trendlines
Error Bars
Working with Axis Options
Advanced Chart Formatting
MODULE 6: Sparklines
Learning outcomes: Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out
Topics covered:
Creating Sparklines
Editing Sparklines
Who this course is for:
Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time.
Password/解压密码-0daydown
Download rapidgator
https://rg.to/file/3f373a65fb91e43bce529b2d7482ebc1/Microsoft_Excel_Intermediate.part1.rar.html
https://rg.to/file/a32227e7b89d73043a6f344bbe70f35a/Microsoft_Excel_Intermediate.part2.rar.html
https://rg.to/file/2c462f28c75f0fee2a4f72eead9fea86/Microsoft_Excel_Intermediate.part3.rar.html
https://rg.to/file/1b9ef011d6bb411ea19e6665f239521e/Microsoft_Excel_Intermediate.part4.rar.html
https://rg.to/file/3e4fd564a9d3741c1bb4ce62dd53cd7b/Microsoft_Excel_Intermediate.part5.rar.html
Download nitroflare
http://nitroflare.com/view/39A9F38F05931D7/Microsoft_Excel_Intermediate.part1.rar
http://nitroflare.com/view/65EF4C61D777E90/Microsoft_Excel_Intermediate.part2.rar
http://nitroflare.com/view/26A14BBAEFED465/Microsoft_Excel_Intermediate.part3.rar
http://nitroflare.com/view/3ED92226D577B0C/Microsoft_Excel_Intermediate.part4.rar
http://nitroflare.com/view/4B84DD01F52F85F/Microsoft_Excel_Intermediate.part5.rar
Download 百度云
你是VIP 1个月(1 month)赞助会员，
转载请注明：0daytown » Microsoft Excel Intermediate