Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Success Blueprint: Beginner's Ultimate Class
Rating: 4.4 out of 5(276 ratings)
11,254 students

Excel Success Blueprint: Beginner's Ultimate Class

Microsoft Excel For Beginners | Unleash The Power Of Excel
Created byThe Table Of Bosses, Isabelle Arrieta Support, Isabelle Arrieta
Last updated 9/2023
English
English [Auto],

What you'll learn

  • Students will learn how to navigate the Excel interface and perform basic functions, such as data entry, formatting, and basic calculations.
  • Students will learn how to use more advanced functions, such as IF statements, VLOOKUP, and INDEX/MATCH, to analyze and manipulate data.
  • Students will learn how to manage and organize data effectively using Excel, including sorting, filtering, and formatting tables.
  • Students will learn how to create visually appealing charts and graphs that effectively communicate data trends and patterns.
  • Students will learn time-saving tips and tricks that can help them work more efficiently in Excel, such as keyboard shortcuts and automation techniques.
  • Real-world applications: Students will learn how to apply Excel skills to real-world scenarios, such as financial analysis and project management

Course content

3 sections • 14 lectures • 2h 18m total length

  • Basic Excel_ Introduction8:07

    Explore the basics of Excel, from the anatomy of a spreadsheet to the ribbon and name box. Learn how columns, rows, cells, ranges, and worksheets organize data in workbooks.

  • Basic Excel_ Inputting Data7:05

    Adjust the zoom for easy viewing, then input top ten grossing movies data (rank, title, studio, worldwide, domestic, overseas, year) and edit text with double-click or the formula bar.

  • Basic Excel_ Formatting Data7:51

    Learn basic excel formatting, including fonts, font sizes, and cell styles, apply borders, wrap text, and merge and center, then format data as currency or accounting for clear, aligned tables.

  • (PART 4) Basic Excel_ Formulas11:12

    Learn how to use formulas in Excel, format results as percent, and copy the formula across cells by dragging, while using print preview and applying borders.

  • Basic Excel_ Basic Functions9:18

    Master basic Excel formulas and functions—autosum, average, min, max, and count—across data ranges, using the formula bar and freeze panes, with charts coming next.

  • Basic Excel_ Creating Charts7:54

    Learn to create and customize charts in Excel by selecting data, choosing a chart type, editing chart titles, axis labels, legends, and reviewing print preview and orientation.

Requirements

  • No requirements just be ready to learn

Description

This course is designed to help beginners master the art of Excel, one of the most powerful tools for data analysis, management and reporting. Through a combination of interactive lectures, hands-on exercises, and real-world examples, students will learn the fundamentals of Excel, from basic data entry and formatting to more advanced functions such as pivot tables and charts.

In Excel 101, students will learn how to navigate the Excel interface, how to work with spreadsheets, and how to input and manipulate data. They will learn how to create basic formulas and functions, including SUM, AVERAGE, COUNT and more, and how to format and style their data to make it visually appealing and easy to read.

As the course progresses, students will delve deeper into Excel’s capabilities, learning how to create and format tables, charts, and graphs. They will also learn how to use more advanced functions, including IF, VLOOKUP and INDEX/MATCH, to analyze and manipulate data.

By the end of this course, students will have a solid foundation in Excel, and will be able to use it to perform data analysis, reporting, and management tasks in a variety of settings, from business to finance to science. They will have gained the skills necessary to succeed in any Excel-based role and will be well-equipped to tackle more advanced Excel courses in the future.


Who this course is for:

  • This course is for beginners.

Report abuse