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 Beginner to Advanced - Data & Dashboards
Rating: 3.9 out of 5(21 ratings)
88 students

Microsoft Excel Beginner to Advanced - Data & Dashboards

FREE Training Manuals included, Templates, Analyse Data, Formulas, Charts & Graphs, Interactive Dashboards, Pivot Tables
Created byiTeachers - David, Stephanie & Glenda
Last updated 9/2020
English

What you'll learn

  • Become a professional Microsoft Excel user from Beginner to Advanced
  • How to manage your data in tables and then how to analyse your data to create meaning
  • Understand and use common and advanced Excel formulas
  • Create an interactive dashboard using a case study
  • Follow along with TRAINING MANUALS for Beginner, Intermediate and Advanced
  • Analyze Data with Excel PivotTables and Pivot Charts
  • Understand Slicers
  • Use conditionally formatting and create traffic lights
  • Test your skills with quizzes and examples
  • Impress your boss or advance your career with your advanced Excel skills

Course content

4 sections • 26 lectures • 2h 58m total length

  • Opening Excel, Microsoft Ribbon and Minimize the ribbon4:06

    This lesson will cover

    *  Opening Excel

    * Understanding the Microsoft Ribbon

    * Minimizing the Microsoft Ribbon


  • Customizing the quick access toolbar and Undo & Redo3:50

    This lesson will cover:

    *  Customizing the quick access toolbar

    * Using the Undo and Redo

  • Navigation in Excel1:45

    This lesson will cover:

    * Selecting Cells

    * Using the Name Box

    * Using the Go To

  • Worksheets - Selecting, Renaming, Inserting, Deleting, Moving and Coloring4:02

    This lesson will cover:

    *  Selecting a worksheet

    *  Renaming a worksheet

    * Inserting a new worksheet

    * Moving a worksheet

    * Deleting a worksheet

    * Changing the worksheet color

    * Grouping worksheets

  • Formatting - Bold, Borders, Column Width, Merge & Center, Cell & Font Color5:40

    This lesson will cover:

    * Adding numbers using AUTOSUM

    * Adding 2 numbers

    * SUMIF function


  • Adding Numbers - AutoSum & SUMIF8:16
  • Using Fill3:58

    This lesson will cover:

    *  Saving time using fill function

    * Using fill to copy text

    * Using fill for a series

  • Splitting Data3:49

    This lesson will cover:

    * Splitting data using Text to Columns

  • Page Layout & Printing2:58

    This lesson will cover:

    *  Margins

    * Orientation

    * Size

    * Print Area

    * Background

    * Print tiles

    * Printing a page

  • Excel Introduction

Requirements

  • Basic computer understanding
  • Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)

Description

Microsoft Beginner to Advanced -  Data and Dashboards

This Microsoft Excel course combines Beginner, Intermediate and Advanced levels and is focused on managing and analyzing your data with pivot tables and interactive Dashboards.  This course will give you to power and knowledge to understand your data and make important decision based on your reports, graphs and dashboards.

Material recorded with Excel Microsoft Office 365, but all features will work in Excel 2010, 2013, 2016 and most will work in 2007.

Learn the Microsoft Excel skills you need with our beginner to advanced hands-on Excel course.  These courses are designed to teach you the skills in how to master spreadsheets with confidence. You will learn to work with a range of excel tools, such as, formulas and functions, creating charts, sorting and filtering data, creating reports and much more. You can also extend your Excel skills to an advanced level with pivot tables, and interactive dashboards. 

All courses come with a manual and training data for you to follow along after the lessons. 

What you will get:

* 3 Courses - Beginner, Intermediate and Advanced

* Training manuals for all courses

* Case studies for your training

* Templates

* Training Data


Who this course is for:

  • Beginner, Intermediate and Advanced students wanting to use all the features in Excel
  • Experienced Microsoft Excel users who are looking to efficiently analyze large data sets and create interactive dashboard reports
  • This course will take you from beginner to advanced

Report abuse