Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel for Beginners: Excel for Everyday Use
Rating: 3.9 out of 5(44 ratings)
5,182 students

Microsoft Excel for Beginners: Excel for Everyday Use

Learn Essential Excel Skills to Organize Data, Create Reports, and Simplify Everyday Tasks with Confidence
Created bySkillify Academy
Last updated 8/2025
English
English [Auto],

What you'll learn

  • Working with Rows and Columns
  • Renaming and Deleting Worksheet
  • Copy and Moving an Worksheet
  • Common Excel Shortcut Keys
  • Entering Date Values
  • Applying Date and Time Formats
  • Relative Vs Absolute Cell References
  • Logical Functions AND,OR & NOT Operators
  • IF and IFS Statements
  • Calculations with SUM() Function
  • Working with MIN() and MAX() Functions
  • Calculations with AVERAGE() Function and more

Course content

1 section • 15 lectures • 1h 48m total length

  • Working with Rows and Columns9:48

    Master basic Excel row and column operations by adding, deleting, hiding, resizing, and formatting them, plus selecting, inserting, and freezing panes for easier data viewing.

  • Renaming and Deleting Worksheet5:12

    Renaming and deleting worksheets in Excel keeps workbooks organized by using descriptive bottom tab names, quick double-click renames, and delete prompts from the Home ribbon with undo options.

  • Copy and Moving an Worksheet6:15

    Move and copy data in a worksheet using drag and drop, cut and paste, and keyboard shortcuts like Ctrl+X, Ctrl+C, and Ctrl+V to rearrange and duplicate data.

  • Entering Date Values8:45

    Master entering date values in Excel by typing in recognized formats, selecting short or long date styles, and using autofill or the control plus semicolon shortcut.

  • Applying Date and Time Formats7:41

    Learn to apply date and time formats in Excel, format cells, enter dates, use 12-hour or 24-hour time, and create custom formats for consistent, professional spreadsheets.

  • Relative Vs Absolute Cell References5:12

    Master relative and absolute cell references in Excel to auto-adjust formulas when copied and to lock constants such as tax rates or unit prices.

  • Logical Functions AND,OR & NOT Operators8:04

    Learn to use and, or, and not in Excel to build dynamic conditions, analyze data, and test multiple rules, including sales targets and profits, for advanced data analysis.

  • IF and IFS Statements8:52

    Learn to use the if and ifs functions to apply conditional logic in Excel, enabling grading, pass/fail checks, and multi-criteria decisions with and/or operators.

  • Nesting Multiple IF & IF Statements9:07

    Master nested if and multiple if statements in Excel to evaluate conditions and return grading. Learn the if function, nesting, and when to use alternatives like switch or if switch.

  • Calculations with SUM() Function4:13

    Master the sum function in Excel to add numbers across contiguous and noncontiguous ranges, and use the Autosum feature for quick, row- or column-wide total calculations.

  • Working with MIN() and MAX() Functions8:19

    Learn how to use min and max functions in Excel to find smallest and largest values, calculate ranges, and highlight extremes with conditional formatting.

  • Calculations with AVERAGE() Function4:05

    Explore how the average function in Excel calculates the arithmetic mean by summing values and dividing by their count, with practical examples using single and multiple ranges.

  • Working with COUNT() Function8:30

    Master Excel count functions to tally numbers and non-empty cells, using count, counta, countif, and countifs with single or multiple criteria.

  • Working with ROUND() Function3:29

    Master the round() function in Excel to control decimal places and clean data. Round to two decimal places or to the nearest whole number for readable results.

  • Common Excel Shortcut Keys11:27

    Master essential Excel shortcut keys to navigate, enter data, format cells, and create formulas efficiently. Learn navigation, data-entry, formatting, and formula shortcuts, including go-to and autofit.

Requirements

  • No prior Excel knowledge required — start from the basics

Description

Microsoft Excel is one of the most powerful and widely used tools for organizing, analyzing, and presenting data — and it’s not just for professionals. From personal budgeting to work reports, learning Excel can make your everyday tasks faster, easier, and more accurate.


This course, Microsoft Excel: A Beginner's Guide to Everyday Use, is your friendly and straightforward path to mastering the essential skills you need for work, school, and personal projects. Forget about complex formulas and advanced features; we'll focus on the practical, everyday applications that will make your life easier.


This course is built for people who have either never used Excel or who feel they've only scratched the surface. I'll start with the very basics, guiding you through the Excel interface and showing you how to confidently navigate and customize your spreadsheets. By the end, you'll be able to create, format, and manage your own workbooks with ease.


What You'll Learn to Do:

  • Master the Basics: Understand the core components of Excel, from cells and rows to the ribbon and tabs. You'll learn to input data accurately and efficiently.

  • Format Your Data: Make your spreadsheets look professional and easy to read. I'll cover everything from changing fonts and colors to using borders and cell styles.

  • Use Simple Formulas: Unlock the power of Excel's built in calculators. You'll learn essential formulas like SUM, AVERAGE, and COUNT, so you can quickly analyze your numbers without a calculator.

  • Organize Your Information: Learn how to sort and filter data to find exactly what you need in seconds. You'll also learn to freeze panes to keep important headers visible as you scroll.

  • Create Basic Charts: Transform your data into compelling visuals with a few simple clicks. I'll show you how to create different types of charts, from bar graphs to pie charts.

  • Print with Confidence: Stop wasting paper! You'll learn how to properly set up a sheet for printing, ensuring everything fits perfectly and looks great.


By the end of this course, you won't just be using Excel; you'll be harnessing its power to organize your life and simplify your daily tasks. Get ready to build your confidence and become the go to person for basic Excel questions!


Enroll today and start your journey to becoming a confident Excel user!

Who this course is for:

  • You've never used Excel before and don't know where to start
  • You want to manage a household budget, create a chore chart, or track personal goals
  • Focus on skills that you can apply immediately in everyday life
  • Simple explanations with real-world examples for practical learning

Report abuse