About Advanced Excel Training

The Advanced Excel Training by Excelwithmukul is an 8-week online training program covering the basic and advanced modules of Microsoft Excel. In this training program, you will learn how to use Microsoft Excel and the advanced concepts of Excel. During the course, students will work on practical projects. The project unit is divided into four assignments. Each assignment focuses on solving a different startup challenge using the concepts covered in the respective module. The projects face a variety of challenges. Students will be presented with interesting real-life scenarios and have to use the Excel tools, functions and data visualization techniques learned to solve problems, make inferences and present data in a meaningful and effective manner using Excel. For doubt clearing, you can post your queries on the forum and get answers within 24 hours.

Basic Excel Training

Learn how to use Microsoft Excel from ExcelwithMukul
Duration: 4 weeks on Saturday & Sunday
Timing: 7:00 to 9:00 PM
Certified Training
Course Fee- Rs. 3000/-

Table of Contents For Basic Excel

1. Getting Started: Get familiar with Excel Learn the basic operations and formulas of excel.

• Introduction to Excel
• Why should we learn Excel?
• Orientation / Tour
• Interface & Terminology
• Excel worksheets
• Excel Ribbon
• Backstage View
• Quick Access Toolbar
• Keyboard shortcuts

2. Excel Basics: You will learn basic concepts in this module which will give you a chance to build a solid foundation.

• Cell Basics
• Modifying cells/rows/columns
• Basic Cell Formatting
• Cell Number Formats
• Cut, Copy & Paste
• Format Painter
• Personalizing Worksheets
• Multiple worksheets
• Find & Replace
• Sheet Protection
• Printing & Page Layout
• Assignment

3. FORMULAS & FUNCTIONS: In-depth lessons on formulas, functions, lookup functions and data validation with Excel

• Intro
• Basic Formulas
• Advanced Formulas
• Cell References
• Excel Functions
• Date/Time Functions
• Text Functions
• Financial Functions
• Logical Functions
• Lookup Functions
• Data Validation
• Troubleshooting
• Assignment

4. WORKING WITH DATA: You will learn all about data organization and data visualization

• Basic tips for working with data
• Freezing panes and view options
• Data sorting
• Data filtering
• Tables
• Charts
• Assignment

5. ADVANCED CONCEPTS: You will learn the skills needed to automate, analyze & present Excel data in the most effective manner

• Conditional Formatting
• What-If Analysis
• Pivot Tables
• Assignment

Advanced Excel Training

Learn how to use Microsoft Excel from ExcelwithMukul
Duration: 4 weeks on Saturday & Sunday
Timing: 7:00 to 9:00 AM
Certified Training
Course Fee- Rs. 5000/

What the key points of Advanced Excel

  • Understand data’s many contexts, origins, and applications in life, work, and society
  • Understand introductory-level data and mathematical concepts
  • Work with different types of data
  • Become data literate with the data analyst toolkit, including data storytelling
  • Apply summary statistics to analyze and understand data sets
  • Apply analytics methods to industry and business scenarios
  • Learn about data analyst career paths

Table of Contents For Advanced Excel

Data Cleansing

  • Find corrupt or incorrect records in a table or database.
  • Identify incomplete, inaccurate or irrelevant parts of the data.
  • Replacing, Modify and deleting incorrect or irrelevant data.

Data Transformation

  • Change the data from unstructured to structured data sets.
  • Define proper data types in data sets.
  • Proper data formatting for dynamic calculation.

Data Handling

  • When data updated or synchronized, it’s stored in well mannered.
  • Data Safety and security.
  • Auto check and detect an error in data when it is updated

Data Analysis

  • Understand the data and find the solution using data sets.
  • Learn the excel tool Pivot table in detail and discovering possible decision-making outcomes.
  • Using excel data analysis tools i.e. charts, pivot table, Slicers, we can forecasting and analysis the data and it is helpful for strategic decision.

DashBoard BI Project

The dashboard is a pictorial representation of data sets which is helpful for data analysis and making a strategic decision. We can visualize our data on a single page By using charts, slicers, and symbols. You do not need to make a different type of reports. You can solve your business problems by using the dashboard in minimum time. You can also forecast your financial data which is helping to build your business strategy.

Combo Offer Basic + Advanced Excel

Learn how to use Microsoft Excel from ExcelwithMukul
Duration: 8 weeks on Saturday & Sunday
Basic Excel Timing: 7:00 to 9:00 PM
Advanced Excel Timing :7:00 to 9:00 AM
Certified Training
Course Fee- Rs. 7000/-