Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
To make highly informed decisions quickly, organizational leaders need to be able to access and interpret data in real-time. Information, and the ability to decipher and act on it swiftly, has become a competitive differentiator and by using the techniques explained in this course we can dazzle the stakeholders and beat our rivals. This course mainly focuses on unique features of MS Excel such as data validation and filtering techniques, Flash fill techniques and interactive formatting of data tables.
The industries and functional specializations such as Information Technology, administration, accounting, Finance, Marketing, Operations, Human Resource Management, Health care benefit the most by using these dazzling Excel tools
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: The Backstage view - Analysis Perspective|
The Backstage view - Analysis PerspectivePreview
|Section 3: Tabs, Toolbars and Ribbons|
Tabs, Toolbars and Ribbons
|Section 4: Best Practices for Spreadsheet Models|
Best Practices for Spreadsheet Models
|Section 5: Advanced Data Filtering techniques|
Advanced Data Filtering techniquesPreview
|Section 6: Exploring Data Validation techniques and controlling inputs|
Exploring Data Validation techniques and controlling inputs
|Section 7: Creating dynamic lists using data validation and Name Ranges|
Creating dynamic lists using data validation and Name Ranges
|Section 8: Formatting data as Tables|
Formatting data as TablesPreview
|Section 9: Demonstrating Flash Fill techniques and its usage in Excel Tables|
Demonstrating Flash Fill techniques and its usage in Excel Tables
|Section 10: Conditional Formatting-Rules and Data Bars|
Conditional Formatting-Rules and Data Bars
|Section 11: Interactive formatting using data tables-advanced conditional formatting|
Interactive formatting using data tables
|Section 12: Additional Material|
|Section 13: Practice test|
Practice test 1
Practice test 2
|Section 14: Exercises|
Quick Bonus for You!
|Section 15: Course Conclusion|
Bonus Lecture on Operational Challenges with Data in Excel - Demystified
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.