Paresh Joshi - Smart Education Centre Proprietor
No reviews yet

We provide offline and online training to the students. At the end of the lecture, we provide a lecture recording also for future reference. So even after the course completion, if anyone wants to revise concepts can watch these videos again. For Advanced Excel & Power Bi we provide lifetime updates for free. This means that if Microsoft introduces any new functions or useful tools, students will be able to update their knowledge for free. For more details, you can check student feedback on Google.

Please note that if a student misses a lecture, they can attend the same lecture at a different time.

Subjects

MySQL Beginner-Expert
C and C++ Beginner-Expert
Advanced Excel Beginner-Expert
Microsoft Power BI Beginner-Expert
Data analysis and visualization Beginner-Expert
Python for Data Analysis Beginner-Expert

Experience

Proprietor (Jul, 2002–Present) at Smart Education Centre, Mumbai

Education

Masters in Software Engineering (Jan, 2001–Jun, 2002) from Bcom mumbai university, MSE

Fee details

₹1,000/hour (US$11.89/hour)

Courses offered

Power BI
- ₹8000
- Duration: 28 HOURS
- Delivery mode: Online
- Group size: 6 - 10
- Instruction language: English, Hindi
- Certificate provided: Yes
Power BI is your one-stop shop for turning data into insights. It's a business intelligence (BI) tool that lets you connect to all your data sources, from Excel to cloud databases.

Think of it as a magic dashboard that creates stunning visualizations and reports. You can then share those insights with your team to make smarter decisions. No coding required, so even data newbies can get started fast.
Advanced Excel
- ₹5000
- Duration: 48 Hours
- Delivery mode: Online
- Group size: 6 - 10
- Instruction language: Hindi, English
- Certificate provided: Yes
Course Overview:
The Advanced Excel Course is designed for intermediate Excel users who want to enhance their skills and become power users. Whether you’re a business analyst, financial professional, or data enthusiast, this course will equip you with advanced techniques to tackle complex tasks.

What You’ll Learn:

Pivot Tables: Master the art of creating and formatting pivot tables. Analyze and summarize large datasets effortlessly.
Macros: Automate repetitive tasks using VBA macros. Save time and streamline your workflow.
Advanced Formulas: Dive into sophisticated formula techniques. Learn about nested IF statements, lookup functions, and more.
Data Tools: Explore features like Goal Seek, Scenario Analysis, and Data Tables.
Collaboration: Understand how to collaborate with others on Excel workbooks.
Tips and Tricks: Discover hidden gems and shortcuts to boost your efficiency.

Specific Topics Covered:
Mathematical Functions: SumIf, SumIfs, CountIf, CountIfs, AverageIf, AverageIfs, and more.
Text Functions: Manipulate text using Upper, Lower, Proper, Trim, and Concatenate.
Date and Time Functions: Work with Today, Now, EOMonth, and Weekday functions.
Advanced Paste Special Techniques: Paste formulas, formats, and validations.
New Excel Features ********* : Explore charts like Tree map, Waterfall, Sunburst, and Box and whisker. Use Slicers, Power Map, and Power View.
Advanced Pivot Table Controls: Field, Items, Sets, and various time lines.
Lookup Functions: Vlookup, HLookup, Index, and Match.
Data Validation: Create dynamic dropdown lists and custom validations.
Logical Functions: If, Nested If, and complex logical operations.
Worksheet Linking: Utilize Indirect function for seamless connections.

Why Take This Course?:
Career Boost: Advanced Excel skills are highly valued in the job market.
Efficiency: Streamline your data analysis and reporting processes.
Problem-Solving: Tackle complex scenarios confidently.
Professional Development: Take that next step toward becoming an Excel pro!

Remember, Excel is more than just cells and formulas—it’s a powerful tool for decision-making and insights. 📈💡