Are you spending too much time on repetitive tasks in Excel? Do you hesitate to use VBA
code to automate your basic tasks? Fear not! Enroll in our Power Query course and
streamline your workflow effortlessly, without the need for any single coding.
Whether you're crunching numbers as a business analyst, accountant, or data expert,
mastering Power Query is your ticket to smoother workflows and standout performance.
Power Query is a handy tool from Microsoft that helps you clean and organize data in
Excel and Power BI. With it, you can quickly connect to different data sources, clean up
your information, and then import it into your favourite analysis tool for better
insights.
A great thing about Power Query is how it can automate boring data cleaning tasks,
saving you loads of time. Plus, it's really easy to use, even if you're not a tech
expert. Whether you're just starting out or already experienced, Power Query's
user-friendly interface makes data cleaning a piece of cake.
A tool from Microsoft, helps to clean and organize data in Excel.
- Delimited
- Fixed Width
- Column data format
- Destination
- Skip columns
- Text qualifier
- Merging Queries
- Appending Queries
- Splitting Columns
- Grouping and Aggregating Data
- Filtering Data
- Removing Duplicates
- Formatting Column Values
- Renaming Columns and Tables
- Working with Date and Time Functions
- Pivoting and Un-pivoting Data
- AutoFilter
- Advanced Filtering with Text, Numbers, and Dates
- Using Advanced Filter with Wildcards
- Copying Filtered Data to Another Location
- Combining Advanced Filter with OR and AND Logic
- Filtering Data Based on Date Ranges
- Top/Bottom N Filter
- Filter by Color
- Sorting Data by Multiple Columns
- Sorting Data in Custom Order
- Advanced Sorting Techniques
- Creating Named Ranges
- Managing Named Ranges
- Use Named Range with
- Formulas
- Data Validation
- Conditional Formatting
- Tables
- PivotTables
- Chart
- Macros
- INDEX and MATCH Functions
- Deleting Named Ranges
- Scope of Named Ranges
- Creating Static & Dynamic Drop-down Lists
- Limiting Input to a List of Values
- Limiting Input to Specific Text Patterns
- Validating Dates and Times
- Restricting Input to Whole Numbers
- Validating Email Addresses or URLs
- Using Custom Formulas for Validation
- Creating Dependent Drop-down Lists
- Advanced Technique
- Ensuring Unique Entries
- Handling Input Errors
- Allowing or Disallowing Blank Cells
- Using Data Validation with Named Ranges
- Handling Input Message
- Remove Data Validation
- Text Functions
- CONCATENATE
- LEFT, RIGHT, MID
- LEN
- UPPER, LOWER, PROPER
- SUBSTITUTE, REPLACE
- Logical Functions
- AND, OR
- NOT
- Date and Time Functions
- TODAY, NOW
- DATE, TIME
- DAY,WEEKDAY, WEEKNUM, MONTH, YEAR
- Lookup and Reference Functions
- VLOOKUP
- HLOOKUP
- XLOOKUP
- INDEX
- MATCH
- INDIRECT
- Array Functions
- SUMPRODUCT
- TRANSPOSE
- SUM, AVERAGE
- FREQUENCY
- OFFSET
- Conditional Functions
- SUMIF, SUMIFS
- COUNTIF, COUNTIFS
- MAXIF, MINIF
- IF / IFERROR / IFNA
- CHOOSE
- IFS
- ISBLANK, ISNUMBER, ISTEXT
- XLOOKUP
- FILTER
- UNIQUE
- SEQUENCE
- TEXTJOIN
- CONCAT
- CONCATENATE
- IFS
- MAXIFS
- MINIFS
- FlashFill
- Creating a Pivot Table
- Basic Functionality
- Adding Data to a Pivot Table
- Sorting Data in a Pivot Table
- Filtering Data in a Pivot Table
- Changing Pivot Table Layout
- Refreshing Pivot Table Data
- Renmaing Pivot Tables
- Adding Sub-total
- Advanced Technique in Pivot Table
- Grouping and Ungrouping Data in a Pivot Table
- Creating Calculated Fields/Items
- Creating Pivot Charts from Pivot Tables
- Removing Blank Cells in Pivot Table
- Use of Data Model
- Creating Pivot Tables from External Data Sources
- Creating Multiple Pivot Tables from a Single Data Source
- Connecting Slicers to Pivot Tables
- Using Timeline Filter with Pivot Tables
- Dynamic Data Range
- Coming Soon
- Evaluate Formula
- Show Formula
- Calculate Formula Manual/Automatic
- Refresh Formula
- Cell
- Range
- Sheet
- Workbook
- VBA
- Share Workbook
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