MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English + srt | Duration: 202 lectures (2h 8m) | Size: 1.1 GB Scenario based training on Excel for learners of all levels
What you'll learn: Build a solid understanding on the Basics of Microsoft Excel Microsoft Excel from Beginner to Advanced using real scenarios and downloadable working files Practice the use of dynamic functions like IF, VLOOKUP, HLOOKUP, PMT, INDEX, MATCH, SUBTOTALS and many more Create great looking reports using Pivot tables, Slicers and Sparklines Automate daily routine work using Macros Practice Excel Tips and Tricks to work more effective Requirements This course was created with Excel as compiled in Microsoft Office 365 ProPlus. Do not worry if you have a lower version of Excel. The functions are the same across the versions and you will easily find your way Description How does learning from someone who started Excel training in his company in 1995 sound? Today you have this opportunity! For over 26 years Wilkie has laid the foundation for thousands of people teaching Microsoft Excel. In this course, he will share his knowledge with you. He will lay the foundation starting with the Basic principles and then build towards the Advanced features. Whether you have never opened an Excel file ever before, you want to brush up on your skills and the newest features, or you are well versed in Excel and want to learn more advanced functions, this course has it all! The course also includes valuable tips and tricks to work more effectively in Excel, and is designed from a basic to advanced level. We'll discuss topics such as: Entering and editing data Autofill formatting of cells working with functions sorting of data past special The What-if-analysis One- and two data table validations conditional format charts subtotals links protection Lookups Pivot tables, and macros The training is built on scenarios and you can practice what you have learned using downloadable Excel working files, and is for anyone who wants to work more effectively in Microsoft excel. Whether in a corporate or personal capacity, if you use excel regularly this course is for you! Remember: You don't know what you don't know, so it is worth your time investing in this course. See you online! Who this course is for This Microsoft Excel course is for anyone who wants to work smart and more effective and productive using Excel Take this course to make sure you do not miss out on advanced features you are not aware of Homepage