• Home
  • Blog
  • Newsletter
  • Site Map

Best Online Short Courses

Self-paced and Tutor-led Online Education Suggestions:

Microsoft Excel: From Beginner to Advanced

January 7, 2020

The Simpliv course “Microsoft Excel – Excel from Beginner to Advanced” will enable you to master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks. It will also give you the training you need to help pass both: Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified.

Here 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.

Learning Excel

Microsoft Excel – Excel from Beginner to Advanced – Course Content

The course comprises 157 Lectures organized into the following sections:

  • Excel Level 1 – Beginner
  • Basics
  • Functions & Formulas
  • Editing Worksheets
  • Formatting
  • Print
  • Modifying Worksheet Appearance
  • Excel Level 2 – Intermediate
  • Advanced Formulas & Functions
  • Tables
  • Charts
  • PivotTables & PivotCharts
  • Graphics
  • Customize
  • Excel Level 3 – Advanced
  • Workbook
  • Collaborating
  • Audit Worksheets
  • Analyzing Data
  • Excel Level 3 – Advanced

Knowledge Required

  • 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

Summary of Course Main Features

  • Instructor: Kirt Kershaw
  • Lectures: 157
  • Level: All
  • Includes:
    • Life Time Access
    • Certificate of Completion
    • Access on Android and iOS App

Price: $ 12.00

Visit the Course Page

 

Related

Similar Posts You May Like:

Excel From Beginner To AdvancedMaster Microsoft Excel from Beginner to Advanced Udemy Excel Crash CourseLearn Excel Shortcuts, Formulas & Functions for Financial Modeling Business Data AnalysisLearn Business Data Analysis with Microsoft Excel and Power BI Beginner to Pro in ExcelBeginner to Pro in Excel: Financial Modeling and Valuation alison business intelligenceLearn How to Use Excel 2013 Power Business Intelligence – Free Course Boost Your Workplace Productivity With These Free Courses drop shippingDrop Shipping: From Beginner to Advanced Scratch ProgrammingFull Scratch 3.0 Programming Course: Beginner to Advanced Default ThumbnailLearn How To Sell On eBay: Beginner to Advanced Course Udemy The Complete Financial AnalystBecome A Successful Financial Analyst With This Top Udemy Course

Filed Under: Databases, Excel, Lectures Tagged With: Excel, Microsoft

Search this Site

About This Site

This site provides information on self-paced and tutor-led online short courses - some of them are free, some are on special offer, and all are excellent value. Use the Search Box, the Main Topics drop-down box, or the Tag Page to find courses that interest you.

Main Topics

Tag Page

Complete List of Tags

Video Marketing Machine

Video Templates

*New customer offer! Top courses from $12.99 when you first visit Udemy.

*New customer offer! Top courses from $12.99 when you first visit Udemy.

*New customer offer! Top courses from $12.99 when you first visit Udemy. End Date: 03/31/2021.

Web Hosting Deal

Web Hosting

Get a Career in Computer Science

Coursera Purple CS Design 3

Textbooks: Rent. Buy. Sell.

Check Your Grammar

The #1 Writing Tool

Free Trial to Create Awesome Videos

Content Samurai Free Trial

Lifetime Learning Access to Eduonix – Only A Few Places Left

Lifetime Access to Eduonix Courses

Amazon Offers

Amazon Prime Free Trial

Sign up for Free Weekly Newsletter

Best Online Courses Newsletter

Enter your email address below to receive a weekly summary with new learning suggestions.

Amazon Gift Ideas

Follow

RSS feed RSS - Posts

Important Links

Contact Us

Terms of Use

Privacy Policy

Best Degree Programs

Online and Distance Learning Degrees

Job Search

Job Search

Copyright © 2023  Best Online Short Courses