Udemy

Mastering Excel Fundamentals - Excel Beginner Course

Enroll Now
  • 759 Students
  • Updated 9/2022
  • Certificate Available
4.5
(277 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
14 Hour(s) 56 Minute(s)
Language
English
Taught by
Michael Bouwer
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.5
(277 Ratings)

Course Overview

Mastering Excel Fundamentals - Excel Beginner Course

Beginners Course to learn how to use Microsoft Excel, Master the Fundamentals of Microsoft Excel as a Beginner.

Excel expert Michael Bouwer helps new users of Microsoft Excel from the most fundamental and basic principles all the way to creating their own worksheets with functioning formulas and references.

This course guides you through some of the most common knowledges, that is not so common to all.

No prior knowledge of Excel required.


Michael have experienced thousands of users that simply don't know about the essential principles covered in this course, and  so miss out on a multitude of Excel functionality.

If you want to become proficient or even just a great user of Microsoft Excel, then this course comes highly recommended.


Topics include:

  • Understanding the Excel Layout and Screen with Menus

  • Simple Data Entry Techniques

  • Creating Formulas and Common Functions

  • Understanding Formatting Tools and Worksheet Manipulation

  • Printing

  • Creating and Editing Charts and its elements

  • Adjusting your View as well as working with Multiple Worksheets and Workbooks

  • Some Advanced Functions, such as IF, VLOOKUP and COUNTIF Family of Functions

  • How to Protect your Worksheets and Workbooks

  • Features to do Proper Data Management

  • Tools for Data Analysis

  • Entire Module Dedicated to PivotTables, from Creation to Manipulation to Charting

  • An Introduction to Macros


All the Resource Files are provided which can be downloaded for free.

Course Content

  • 16 section(s)
  • 69 lecture(s)
  • Section 1 What is Excel Used For
  • Section 2 Basic Navigation around Excel Interface
  • Section 3 Data Entry into Excel
  • Section 4 Creating and Mastering Formulas and Functions
  • Section 5 Formatting Features in Excel
  • Section 6 Adjusting The Worksheet Layout to Suit You
  • Section 7 Printing Basics in Excel
  • Section 8 Charting Basics in Excel
  • Section 9 Adjusting Worksheet Views in Excel
  • Section 10 Working with Multiple Worksheets and Workbooks
  • Section 11 Advanced Formulas (IF, VLOOKUP & COUNTIF family)
  • Section 12 Protection and Passwords
  • Section 13 Basic Data Management Features
  • Section 14 Basic Data Analysis Tools
  • Section 15 PivotTables Basics in Excel
  • Section 16 Basic Introduction to Macros

What You’ll Learn

  • How to Use Microsoft Excel as a Complete Beginner
  • From Basic Navigation to Entering Data and Creating your Own Formulas and Functions
  • To Understanding Formatting, and Adjusting Your Layouts and Views and Printing
  • Learning How To Create Charts and Tables and Other Management Features
  • Protecting Your Precious Files and Worksheets and Analysis Tools like Add-Ins
  • All the Way to Everything about PivotTables and even an Introduction to Macros


Reviews

  • D
    David Ault
    3.5

    Yes, I wasn't aware there were so many preset templates for Excel

  • S
    Sarah Campbell
    4.5

    Yes, looking froward to learning all about Excel

  • N
    Niamh King
    5.0

    Great course

  • A
    Alix Dykman
    4.0

    Yes it was a good match.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed