Meet Your Trainer (Akhilesh Meena)
Akhilesh Meena is an expert in the field of Business Intelligence with high proficiency in specialized tools such as Power BI, Microsoft Excel, Power Pivot, Power Query and more.
Having received his Engineering degree from IIT Bombay, one of the top-ranked engineering institutes in India and later an MBA from IIM Indore, another highly coveted college in the country; Akhilesh has over the years, honed his expertise in Business intelligence consulting, data visualization, and business Analysis across the spectrum of industries including FMCG, automotive, pharmaceuticals, real estate and more.
So far, he has trained more than 1700 delegates from 180+ Organizations in Power BI, MS Excel, Visualizations, and other tools used in the business environment, every single day.
This is for YOU if...
- You want to make a career shift toward Business Analysis
- You are looking to demand a higher salary package
- You are looking to become a key player in your team
- You spend more time preparing reports and are left with no time for analysis
- You are tired of doing repetitive manual tasks
- You are missing quality time with your loved ones
Course Content
Orientation
Available in
days
days
after you enroll
Section 1: Excel Basic Concepts
Available in
days
days
after you enroll
Section 2: Formula Writing Concepts
Available in
days
days
after you enroll
Section 3: Name Ranges and Excel Tables
Available in
days
days
after you enroll
Section 4: Aggregation Functions
Available in
days
days
after you enroll
Section 5: Date Functions
Available in
days
days
after you enroll
- Download Me First: Practice File
- Extract Parts of a Date: Day, Month , Year (4:55)
- How to get Year End and Year Start Date (2:38)
- Text Function for Date Parts (1:17)
- Over Time Calculations (7:17)
- NETWORKDAYS.INTL : Calculate Working Days between 2 Dates (1:58)
- WORKDAY.INTL : Calculate End Date from Start and Working Days (1:50)
- Duration between Dates in Years Month and Days (4:20)
- EDATE Function : Get Expected End Date (1:33)
- List Dates between two Dates : SEQUENCE (1:48)
Section 6: Logical Functions
Available in
days
days
after you enroll
Section 7: Data Validation : Minimize Data Entry Errors
Available in
days
days
after you enroll
Section 8: Data Cleaning : Text Functions
Available in
days
days
after you enroll
- Text Case : LOWER, UPPER, PROPER, TRIM (8:24)
- Text to Columns Feature to Split Text (4:27)
- LEFT, RIGHT, MID, LEN : Split Data (4:45)
- FIND, SEARCH Function: Position of any Character (5:24)
- SUBSTITUTE: Similar to Find and Replace of Excel (1:31)
- REPLACE Function : Replace Text based on Number of Characters (3:04)
- 5 Ways to Split Text (6:04)
- Joining Text from Multiple Cells (6:26)
Section 9: LOOKUP Functions
Available in
days
days
after you enroll
Section 10: Conditional Formatting
Available in
days
days
after you enroll
- Types of Conditional Formatting (4:39)
- Data Bars in other column (1:12)
- Conditional Formatting in Pivot Tables (1:27)
- Icon sets with Customized Rules (2:05)
- Highlight Dates with Custom Conditions (2:53)
- Highlight Upcoming Birth Dates (5:55)
- Advanced CF: Dynamic Borders/ Background Color Around Data (3:01)
Section 11: Charts & Visualization
Available in
days
days
after you enroll
Pivot Tables 12: Key to Interactive Reports and Dashboards
Available in
days
days
after you enroll
Bonus : Excel Key Board Shortcuts
Available in
days
days
after you enroll
Bonus: Tools of Interactivity for Advance Dashboards
Available in
days
days
after you enroll
- Interactive Report Option Buttons (6:47)
- Interactive Dashboard Check Boxes (6:58)
- Interactive Report Camera Tool Option Buttons (7:15)
- Interactive Report Offset and Spin Button (9:39)
- Interactive Dashboards Scroll Bar (11:13)
- Interactive Dashboards Part-1 (102:01)
- Interactive Dashboards Part-2 (95:30)
Bonus: Macros and AI with Excel
Available in
days
days
after you enroll
Check your inbox to confirm your subscription