Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Tutorial - from Beginner to Advanced
Rating: 4.6 out of 5(24 ratings)
628 students

Microsoft Excel Tutorial - from Beginner to Advanced

"Master Microsoft Excel with Comprehensive Tutorials from Beginner to Advanced Level"
Created byProgramming Knowledge
Last updated 8/2024
English

What you'll learn

  • Basic and advanced functions of Excel, including data entry, formatting, calculations, and formulas.
  • PivotTables, PivotCharts, and other advanced data analysis tools.
  • Automation techniques, such as Macros.
  • Tips and tricks for working with Excel more efficiently.

Course content

2 sections • 65 lectures • 11h 33m total length

  • Introduction to MS Excel11:09
  • Organizing Data11:25
  • Basic Excel Formulas | Important Formulas for Beginners10:39

    Learn to apply Excel formulas to a database using sum functions, range references, and built-in options. Explore manual sums, auto sum, auto average, and insert function for efficient data analysis.

  • How to use the Excel IF function11:08
  • Pivot Tables in Excel | How to Create a Pivot Table in Excel10:13
  • Text Functions in Excel | Excel TEXT Function - Formula and Examples10:20
  • Cell Reference in Excel with Examples11:08
  • Text to Columns in Excel | How to Use Text-to-Columns in Excel9:32
  • How to Use Paste Special + How to Use Speak Cells Feature in Excel11:06
  • Custom List in Excel + Using Advanced Fill in Excel10:23
  • Flash Fill in Excel + Series features10:17
  • Nested IF, AND, IF ERROR Function ( Logical Functions in Excel)12:06
  • Comments and Custom Views10:20
  • How to Make Charts and Graphs in Excel10:58
  • Excel DATE function with examples + Mathematical Functions11:38
  • How to Rotate Text in Cells in Excel + How to Print in Excel10:35
  • How to use Header and Footer in MS Excel10:28
  • Data validation in Excel10:28
  • How to Record a Macro in Excel11:22
  • Relative References in Excel11:17
  • How to Make a Macro in Excel | Write Macros in Excel11:42

    Learn to write and run macros in Excel by recording, editing, and coding in VBA, using both front-end and back-end methods, with partial and full macro writing.

  • Name Array in MS Excel10:33
  • How To Use VLOOKUP in Excel9:58
  • Approximate Match and VLOOKUP rules11:10
  • Consolidate Data in Excel | Excel Consolidate Function10:47
  • Count Functions in MS Excel10:59
  • Single Criteria Statistical functions10:44
  • Multiple Criteria Statistical Functions in Excel10:48

    Explore how to use multiple criteria statistical functions in Excel, including sumifs, countifs, and averageifs, by combining multiple criteria with criteria ranges and data ranges.

  • How to use Index, Match, Lookup and HLookup in Excel11:57
  • Protection Rules in MS Excel | Protecting a Worksheet's Format Excel10:40

    Explore protection rules in Excel, learn how to lock and unlock cells, hide formulas, and protect worksheets and workbooks with passwords.

  • Create Hyperlinks in Excel | Links in MS Excel10:44
  • Data Sorting In MS Excel | How to Sort Lists in Excel10:26

    Master normal and advanced sorting in Excel, using major and minor criteria, color sorts, and custom sort options to organize dates, numbers, and text.

  • Filtering Data | How to Filter in Excel10:45
  • Advanced Filters in MS Excel10:28
  • Chart Shortcuts in MS Excel | Create Excel Chart With Shortcut Keys10:26
  • Combo Charts and Pie Charts in MS Excel11:33

    Learn to create and customize pie charts and combo charts in Excel, focus data, explode slices, hide data, add data labels, use secondary axes, and apply trend lines for forecasting.

  • Spark Line Charts in MS Excel10:23
  • Pivot Chart in MS Excel11:01
  • Conditional Formatting in Excel : Part 110:32

    Learn to apply conditional formatting in Excel to highlight numbers, text, and dates using rules such as greater than, less than, between, equal to, and duplicate or unique values.

  • Conditional Formatting in Excel : Part 210:26

    Learn how to apply conditional formatting in Excel to dates and numbers, using date occurrences, top/bottom rules, above/below average, and visual tools like data bars, color scales, and icon sets.

  • Conditional Formatting for Icon Sets - How to use Icon Sets8:43
  • Advanced Conditional Formatting Formulas in MS Excel11:27

    Learn how to implement advanced conditional formatting with formulas in Excel, using a formula to determine which cells to format and highlighting matching records across columns or rows with criteria.

  • Customizing Pivot Tables Part 110:21

    Discover how to customize pivot tables in Microsoft Excel by grouping by year and month, adjusting design and appearance, and applying filters for targeted insights.

  • Customizing Pivot Tables Part 211:01
  • Pivot Table Item Slicers | Excel Pivot Table Slicers10:13

    Master filtering pivot tables with item and year slicers, including multi-select and clear filters when headers are hidden. Customize slicer appearance, headers, and connections to multiple pivot tables.

  • Slicer and Timeline over Pivot Table in MS Excel10:39
  • Dependent Dropdown Lists in MS Excel10:02
  • Summary Report in MS Excel | How to Create an Excel Summary Report10:29
  • Objects In Ms Excel | Excel Worksheet Objects10:12
  • Table vs Cell Range in MS Excel10:33
  • Slicers on Charts in MS Excel | Slicer Controlled Interactive Charts10:11
  • How to Create a Linked Object in Microsoft Excel10:24
  • Ctrl Shortcuts in MS Excel10:19
  • Function Keys Shortcut In Microsoft Excel9:33
  • Alt Key Shortcuts in MS Excel (Keyboard shortcuts in Excel)11:03
  • Shift + Function Key shortcuts in MS Excel10:32
  • Ctrl + Function Key Shortcuts In Ms Excel11:10
  • Alt And Shift With Special Keys Shortcuts In Ms Excel10:33

    Master alt and shift shortcuts in Microsoft Excel, including alt+down arrow for dropdown lists, alt+space for the control box, alt+enter for multiline cells, and shift+arrow or enter for navigation and selection.

Requirements

  • Basic computer literacy and familiarity with Microsoft Office software.
  • Access to Microsoft Excel (version 2016 or later recommended).
  • Individuals who want to learn Microsoft Excel from the beginner level to advanced.
  • Those who want to develop their skills in data analysis, budgeting, and financial modeling using Excel.
  • Professionals who use Excel in their work and want to improve their efficiency and productivity.

Description

This comprehensive Excel tutorial is designed to take you from a beginner to an advanced user. You'll start by learning the basics of Excel, including navigating the interface, creating and formatting spreadsheets, and using basic functions and formulas. As you progress through the course, you'll explore more advanced features, such as conditional formatting, data analysis, pivot tables, and macros.

Throughout the course, you'll have hands-on practice with real-world examples and exercises, which will help you build your skills and confidence. You'll also receive expert tips and tricks for optimizing your Excel workflow and streamlining your work.

By the end of the course, you'll be able to use Excel with ease and confidence, creating professional-grade spreadsheets and analyzing data with speed and accuracy. Whether you're a business professional, student, or just looking to expand your skillset, this Excel tutorial is the perfect way to take your abilities to the next level.


This comprehensive course takes you from beginner to advanced in Microsoft Excel. With over 10 hours of content, you'll learn how to organize data, use basic and advanced formulas, create pivot tables and charts, use text functions, and more. You'll also learn about conditional formatting, data validation, and protection rules, as well as how to create macros and use shortcuts to save time. With step-by-step instructions and real-world examples, this course will help you master Excel and improve your productivity. Whether you're a student, business professional, or anyone who works with data, this course is for you. Enroll now and start mastering Excel!

Who this course is for:

  • Students, job seekers, and business professionals who want to improve their Excel skills.
  • Anyone who wants to learn Excel from scratch and build a strong foundation for future learning.
  • Those who want to learn advanced features of Excel and apply them to their work or personal projects.

Report abuse