Useful Excel for Beginners

Useful Excel for Beginners

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user

Language: english

Note: 4.5/5 (52,189 notes) 491,375 students

Instructor(s): Dinesh Natarajan Mohan

Last update: 2020-11-22

What you’ll learn

  • Learn the fundamentals of Excel
  • Become an effective user

 

Requirements

  • Knowledge of operating a personal computer
  • Microsoft Excel for Windows (Preferably 2007 or 2010 or 2013)

 

Description

      Welcome to the Useful Excel for Beginners course. 

     In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply. 

     As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing. 

     The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. 

Since this is a free course, Udemy does not offer certificates anymore.

 

Who this course is for

  • Never used Excel before
  • Beginner level Excel user

 

Course content

  • Introduction
    • Introduction to the Course
  • Basics of Excel
    • Basics of Excel
    • Workbooks and Worksheets
    • Fundamentals
    • CHAPTER 2: Basics of Excel
  • Entering Data
    • How to Enter data
    • Auto Fit
    • Keyboard Navigation
    • Auto Complete
    • Entering Numbers
    • Navigating edges
    • Navigating – First and last used cells
    • Selecting cells – Introduction
    • Selecting cells – Shift + Arrow
    • Selecting cells – Ctrl + Shift + Arrow
    • Selecting cells – Mouse Click and Drag
    • Selecting cells – Mouse Click and Shift Click
    • Selecting cells – All Cells & Used Cells
    • Selecting cells – Rows and Columns
    • Selecting cells – Non-contiguous cells
    • Selecting cells – Summary
    • Number Formatting – Introduction
    • Number Formatting – General and Text
    • Number Formatting – Number and Fraction
    • Number Formatting – Currency
    • Number Formatting – Accounting
    • Number Formatting – Percentage
    • Number Formatting – Date
    • Number Formatting – Time
    • Number Formatting – Summary
    • Inserting and deleting Rows, Columns and Cells
    • CHAPTER 3: ENTERING DATA
  • Formatting
    • Formatting – Introduction
    • Formatting – Bold, Italics and Underline
    • Formatting – Border
    • Formatting – Fill and Font
    • Formatting – Alignment
    • Formatting – Format Painter and Clear Formats
    • CHAPTER 4: FORMATTING
  • Editing
    • Editing – Editing Cell Content
    • Editing – Multiple Lines of Text
    • Editing – Ctrl + Enter
    • Editing – Auto Fill
    • Editing – Copy and Paste
    • Editing – Cut and Paste
    • Editing – Auto Fill Series
    • Editing – Sort
    • Editing – Filter
    • Editing – Find and Replace
    • CHAPTER 5: EDITING
  • Saving
    • Saving – Saving Excel documents
    • CHAPTER 6: SAVING
  • Viewing
    • Viewing – Freeze Panes
  • Calculations
    • Calculations – Introduction to Formula
    • Editing Formula
    • Introduction to Functions
    • Entering Functions
    • Types of Functions
    • MIN, MAX and AVERAGE Functions
    • Copying Formula
    • Cell References
    • Paste Formula
    • Counting Functions
    • Lookup Functions
    • Date Functions
    • Text Functions
    • SUMIF Function
    • IF Function
    • Errors
    • Calculations – Summary
    • CHAPTER 8: CALCULATIONS
  • Visualizing
    • Introduction to Charts
    • Creating a Chart
    • Chart Components – Labels
    • Chart Components – Background
    • Chart Components – Axes
    • Chart Components – Format and Design
    • Chart Types
    • Introduction to Conditional Formatting
    • Conditional Formatting – Format All Cells
    • Conditional Formatting – Format Only Cells
    • Conditional Formatting – More Rule Types
    • Conditional Formatting – Formula Based
    • Conditional Formatting – Summary
    • Illustrations
    • CHAPTER 9: VISUALIZING
  • Analyzing
    • Introduction to PivotTables
    • Creating PivotTable
    • PivotTable Summarization Types
    • PivotTable Tools
    • PivotCharts
    • CHAPTER 10: PIVOTTABLES
  • Tables
    • Creating a Table
    • Tables – Functionality
    • CHAPTER 11: TABLES
  • Sharing
    • Save & Send
    • Printing
    • CHAPTER 12: SHARING
  • Final Thoughts
    • Final Thoughts

 

Useful Excel for BeginnersUseful Excel for Beginners

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate