The Beginner's Guide to Excel - Excel Basics Tutorial

Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.

  • No Rating
  • (0 Reviews)
  • 4 Students enrolled
  • Free
  • Course Includes
  • Introduction Video to Excel


What you will learn

  • Microsoft Excel 101 - An Introduction to Excel
  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Build a solid understanding on the Basics of Microsoft Excel
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Access to a Professional Trainer with 10+ years of Excel Training

Requirements

  • This course was created with Excel 2016. But all features will work in Excel 2010, 2013, 2016 and most will work in 2007.

Description

Microsoft Excel all in One Package

This Microsoft Excel course combines 4 different courses.

  • Microsoft Excel 101 - An Introduction to Excel

  • Microsoft Excel 102 - Intermediate Level Excel

  • Microsoft Excel 103 - Advanced Level Excel

  • Master Microsoft Excel Macros and VBA in 6 Simple Projects

Material recorded with Excel 2016 but works in 2010, 2013, 2016, 2019 (Office 365)

Course Content

Basics of Excel

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's AddIn, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA

mb

Recent Courses

blog
Last Updated 9th September 2020
  • 0
  • 12
blog
Last Updated 1st September 2020
  • 5
  • 12
blog
Last Updated 1st September 2020
  • 1
  • 9.99
blog
Last Updated 31st August 2020
  • 2
  • 8.99
blog
Last Updated 29th August 2020
  • 4
  • 10

About the Instructor

instructor
About the Instructor

Graduate from JKUAT University and consulting as an ICT Expert with over 15years experience.