Simpliv LLC

Master Microsoft Excel - Excel From Beginner To Advanced

Enquire Now

Course Information

Registration period
4 Feb 2021 (Thu) - 4 May 2021 (Tue)
Price
HKD 101
(US$ 12.99 (Now)
US$ 64.99 (Regular Price))
Course Level
Study Mode
Duration
15.50 Hour(s)
Language
English
Location
-
5 views

Course Overview

Description

Microsoft Excel All-In-One Training

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 18+ 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. 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, 2013, 2016, 2019 and 365 will work with most, or all features
  • You will need Microsoft Excel installed on your computer to follow along and complete the exercise files

What you'll learn

What will you 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 18 years of Excel training


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