What you'll learn
- Learn to quickly work on excel with pro tips.
- Improve productivity at work
- Help to improve efficiency in excel work
- Master the advanced functionality of Excel which will help to use Microsoft Excel in a effective way
Requirements
- Basic understanding of Computer
- Basic Understanding of Excel
Description
If you want to become an expert in Excel it will help you to become an advanced professional in Excel.
if you want to become a pro in Excel to boost your productivity, and efficiency in excel?
If you are struggling while working with the excel sheets and their data?
If you are not sure how you can improve your skills in excel?
If any of the above questions answer is Yes, then this is the right course for you, with more than 80 tips which are covered in this course, which will make you an expert in Microsoft excel.
The following topics are covered in this course:
Productivity tips
Autofill & flash fill
CTRL + ALT shortcuts
cell protection and its usage
Advanced sorting & filtering
Formatting tips
Invisible text
Frozen pens
Custom number formats
formula formatting
snap to grid example
Formula tips
Unique & Duplicates
Formula auditing Tools
different Calculation Modes
Fuzzy-Match lookups
INDEX & MATCH with its example
Visualization tips
Filled Maps
Sparklines
Dynamic Ranges
Form Controls
Custom Templates
Pivot table tips
Custom Sort Lists
Date & Value Grouping
what are Slicers & Timelines and How to use them?
Cache Source Data
Conditional Formatting
Analytics tips
Data Modeling
Goal Seek & Solver
Outlier Detection
All these topics with a handful of examples with practical demonstrations.
At the end of this course, you will become a confident excel professional (Power User) who can do most of your excel work so easily with advanced formulas, interactive visuals and charts, which will save your time and will help you to achieve your goals.
Who this course is for:
- Beginner to Pro Excel Power Users
Instructor
- 4.2 Instructor Rating
- 1,135 Reviews
- 62,977 Students
- 6 Courses
With over 16 years of enriching experience in the IT industry, I have carved a niche for myself at the forefront of technological innovation, working on a multitude of projects for a global clientele within a leading multinational company. My journey began in the realm of Java technologies, where I honed my skills in enterprise development before diving into the dynamic world of Business Intelligence (BI) and ETL technologies. My expertise spans a wide array of tools and platforms, including:
SAP Business Objects Reporting, SAP Design Studio, SAP Lumira Designer, SAP Analytics Cloud, and Microsoft Power BI Desktop/Pro, Data Fabric, Data Modelling. Python for Data Analysis( Jupyter Notebook, Pandas, Numpy, Matplotlib, Seaborn)
SQL - Microsoft SQL Server, Oracle.
ETL - Microsoft SQL Server Integration Service (SSIS), SAP BusinessObjects Data Services (BODS), and Pentaho,Microsoft Fabric.
In an industry characterized by rapid technological evolution, my ability to swiftly adapt and master new technologies has been a cornerstone of my professional growth. This adaptability, coupled with a deep-seated passion for technology, has propelled me to not only excel in my field but also to share my wealth of knowledge with others.
Driven by the belief that sharing knowledge enriches the community, I founded a YouTube channel, 'Atul Kadlag,' over 5 years ago. Through this platform, I have been dedicated to demystifying complex technological concepts and empowering both peers and enthusiasts alike with practical insights into the latest in technology and BI solutions. This endeavour reflects my commitment to not just excel in the IT industry, but also to contribute to its growth by fostering a culture of learning and innovation.