- Overview
- Applications
- Excel Ribbon
- Quick Access Toolbar
- Excel Layout and Environment
- Row and Columns
- Cell and Cell Address
- Range and References
- Sheets and Workbooks
- Entering Data
- Text Formatting
- Color Formatting
- Border Formatting
- Alignment Formatting
- Fill Formatting
- Format Painter
- Merge & Center
- Custom Formatting
- Conditional Formatting
- Shortcuts
- Cut, Copy and Paste
- Insert and Delete Rows/Columns
- Hide and Unhide Rows/Columns/Sheets
- Save Workbook and Rename Worksheet
- Shortcuts
- Sorting
- Sorting Manual
- Advanced /Multi-level Sorting
- Alphabetic Sorting (A-Z or Z-A)
- Sort by Date/Number/Text
- Sort by Color
- Types of Filters
- AutoFilter
- Copying Filtered Data to Another Location
- Paste Values
- Paste Formula
- Coming Soon
- Coming Soon
- Coming Soon
- Mathematical Functions
- SUM, AVERAGE
- MIN, MAX
- COUNT
- Coming Soon
- Coming Soon
Microsoft Certified Trainer - 1 Million+ Students
Experienced Tableau specialist adept at
converting business requirements into
impactful visualizations. Skilled in Tableau Server administration,
performance optimization, and report publishing. Proficient in SQL queries
across MySQL, SQL Server, and Oracle. Expertise in creating Data Lakes to
centralize offline data management. Strong ability to define data flows and
templates in Excel and MySQL environments. Knowledgeable in implementing
user filters for row-level security (RLS) and proposing suitable
visualization views aligned with KPIs. Proficient in Tableau features like
LOD, Parameter, Sets, and Actions. Experienced in end-to-end automation of
data and dashboard processes. Well-versed in training team members on new
technologies and BI tools. Expertise in converting excel-based reports to BI
visualizations and writing VBA Macros/Python Script for data preparation.
Analyzes data requirements and designs visualization solutions to meet
client needs. Skilled in data analysis and preparing ad-hoc reports.
Additionally, proficient in Python for data manipulation and analysis,
including feature engineering, data mapping, data cleaning, and aggregation.
Skilled in creating online platforms using Python, HTML/CSS, and JQuery for
data file management with LDAP Authentication. Experienced in Exploratory
Data Analysis (EDA) and assisting team members with machine learning
algorithms for predictions. Utilized Python libraries such as Pandas, NumPy,
Sci-Kit, Scikit-learn, OpenPyXL, and ldap3.
Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.
The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).
This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.
This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.
Leave a Comment