DEV Community

Cover image for "Excel Mastery Day 1: Setting the Course for Success - My Personal Learning Roadmap Unveiled! 🚀📊
Nitin-bhatt46
Nitin-bhatt46

Posted on

"Excel Mastery Day 1: Setting the Course for Success - My Personal Learning Roadmap Unveiled! 🚀📊

What we will learn in Excel.

Level - 1
Understanding the Excel Interface:
Ribbon, Tabs, and Commands
Cells, Rows, Columns
Importing data and turning into a table.

OverView
Basic Formulas:
SUM, AVERAGE, MIN, MAX
Basic arithmetic operators (+, -, *, /)
Cell References:
Relative, Absolute, and Mixed references
Data Entry and Formatting:
Inputting data efficiently
Basic formatting options (font, colour, borders)
Sorting and Filtering:
Sorting data
Applying filters

Level-2
Advanced Formulas:
IF statements
VLOOKUP, HLOOKUP, INDEX, and MATCH functions
Data Validation:
Setting up drop-down lists
Ensuring data accuracy
PivotTables:
Creating PivotTables for data summarization
Using slicers for interactive filtering
DATE AND TIME FUNCTION:
DATA MANIPULATION FUNCTION
STATISTICAL FUNCTION.
Charts and Graphs:
Creating different types of charts (bar, line, pie)
Customise chart elements
Conditional Formatting:
Highlighting cells based on specific conditions
Using data bars, colour scales, and icon sets

Level - 3:
Power Query:
Importing and transforming data
Merging and appending queries
Fastest Output :
Flash fill
Data Validation
Text to column
Forecasting
Compilation of excel files
THIS IS ENOUGH FOR THE DATA ANALYSIS, SOME FORMULA AND TECHNIQUE WILL DIFFER FROM SECTOR TO SECTOR.

LEARNING IS AN EVERYDAY PROCESS SO, i will be updating previous learning with new tips and tricks.

Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46

THANK YOU

Top comments (0)