Microsoft Excel - Excel from Beginner to Advanced

Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
-
Language
English
Price
$13

Course Overview

This Microsoft Excel course includes all three Levels from Beginner to Advanced

  • Microsoft Excel Level 1 - Beginner
  • Microsoft Excel Level 2 - Intermediate
  • Microsoft Excel Level 3 - Advanced

As your instructor I will use my 16+ years of Excel training and certifications including: Microsoft Office Specialist Expert and Master Instructor: 2000 XP (2002) 2003 2007 2010 2013 and 2016 Microsoft Certified Trainer (MCT) Microsoft Certified Professional (MCP) to guide you step by step through Beginner Intermediate and Advanced Levels of Excel.

At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks as well have all the training you need to help pass both: Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified like me. Below are just a few of the topics that you will master:

  • Creating effective worksheets
  • Writing and editing formulas and calculations
  • Use sorting and filtering options
  • Build a database right the first time and avoid common design flaws
  • Creating informative and captivating Charts
  • Eliminate repetitive tasks instantly using Macros
  • Create many scenarios with varying groups of data
  • Manage large ranges of data in a List or Table
  • Increase productivity with functions: IF PMT VLOOKUP FIND SEARCH MATCH INDEX and much more

BASIC KNOWLEDGE

  • This course was created with Excel 2016. However Excel 2007 2010 or 2013 will work with most or all features
  • You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

Who should take this course

Anyone interested.

Course content

What you will learn:

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Writing Formulas and performing Calculations
  • Increase productivity with functions: IF PMT VLOOKUP FIND SEARCH MATCH INDEX and much more
  • Create charts with Trend Lines and Dual Axis
  • Use Excel as a Database with Sort and Filter options
  • How to avoid the most common Database Design flaws
  • Taught by Certified Microsoft Office Excel 2016 Specialist and Expert with over 16 years of Excel training

About Course Provider

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.

Frequently asked questions

{{ item.question }}