Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - From beginner to Advanced
Rating: 3.9 out of 5(74 ratings)
2,218 students

Microsoft Excel - From beginner to Advanced

Master Microsoft Excel: Transform Data into Insight with Powerful Tools
Created byDataForge AI
Last updated 10/2024
English
English [Auto],

What you'll learn

  • Learn the basics of navigation and formatting cells
  • Explore Excel’s powerful functions such as SUM, IF, VLOOKUP, and nested formulas to manipulate and analyze data.
  • Techniques for sorting, filtering, and validating data, and managing large datasets with ease.
  • Learn the basics of working with worksheets.

Course content

1 section • 10 lectures • 1h 8m total length

  • Introduction6:55

    Import CSV files into Excel to load IPL match and ball-by-ball data, then examine fields like match id, city, date, venue, toss, and innings details.

  • Filter data in excel6:11

    Filter the IPL ball-by-ball data by match id 335982, copy the filtered results to a new sheet named match 5982, then sort by smallest over and ball.

  • sum()6:17

    Master the sum function in Excel to total numbers in a column, using a real file and examples like KKR runs by the end of the first five over.

  • MAX()6:37

    Master the max function in Excel to return the highest value, then calculate run rate by dividing total runs by total overs using sum and max.

  • YEAR(), MONTH(), sum()11:10

    Create a column to mark April 2009 in Excel, use if with and to test month and year, then sum to count matches in April 2009.

  • CONCAT()10:03

    Master the concat function to join strings in Excel and build messages from bowler and fielder names using an if condition. Use cricket dismissal data to generate the card string.

  • VLOOKUP() PART 15:24

    Learn to use vlookup to find a winner by match id or price by fruit, using a search key, table range, index, and sort flag in Excel or Google Sheets.

  • VLOOKUP() PART 23:55

    Learn to use vlookup in Excel to find the winner by match ID, selecting the search key, data table, and the correct column index (winner) to return Chennai Super Kings.

  • MATCH() PART19:18

    Learn how the match function finds the position of a value in a range and combines with vlookup to retrieve a cell value, using a drop-down for column selection.

  • MATCH() PART22:56

    Demonstrate using match() and vlookup to fetch city, match value, and sale value from the IPL match 2008 to 2020 table, with dropdowns updating results like Bangalore and BB McCullum.

Requirements

  • No Prior Excel Knowledge Required

Description

Microsoft Excel Mastery: From Zero to Pro in Data Management and Analysis

Ready to become an Microsoft Excel expert? Whether you’re completely new to spreadsheets or looking to take your skills to the next level, this course will guide you step-by-step through everything you need to know to master Microsoft Excel. You'll start with the basics and gradually build to advanced techniques, ensuring that you gain confidence at every stage.

Why take this course?

Excel is one of the most versatile and widely used tools in the business world. With Excel, you can automate tasks, create stunning reports, manage large datasets, and solve complex problems. By mastering Excel, you can become more efficient, make better data-driven decisions, and boost your career.

What you'll learn:

  • Excel Essentials: Learn the basics of navigation, formatting cells, and working with worksheets.

  • Formulas and Functions: Explore Excel’s powerful functions such as SUM, IF, VLOOKUP, and nested formulas to manipulate and analyze data.

  • Data Management: Techniques for sorting, filtering, and validating data, and managing large datasets with ease.


Who is this course for?

  • Beginners: Learn Excel from the ground up, even if you've never opened a spreadsheet before.

  • Intermediate users: Gain advanced skills, tips, and tricks to work faster and smarter with Excel.

  • Professionals: Anyone who works with data, reports, or spreadsheets in their job – from finance and marketing to engineering and operations.

  • Students: Prepare for job interviews or add Excel to your skillset to boost your career prospects.

By the end of this course, you'll be able to confidently use Excel to manage and analyze data, create professional reports, and automate tasks to save time and effort.

Enroll today and take the next step towards Excel mastery!

Who this course is for:

  • This course is perfect for professionals, students, and anyone who wants to streamline their workflow, boost productivity, and master Excel's powerful features. Enroll now and transform the way you work with data!

Report abuse