• Post category:StudyBullet-3
  • Reading time:11 mins read


Basic to Intermediate Level Microsoft Excel Training Course | Step by Step guide to MS Excel Course

What you will learn

Learn Microsoft Excel from Basics to Intermediate Level

Learn How to Analyze the Data

Learn How to Create Charts & Tables

Learn the Formatting & Conditional Formatting

Learn the Mathematical Functions

Learn the Logical & Lookup Functions

Learn to Audit the Excel Data Sheet

Learn Data Consolidation in Excel

Learn the Shortcut Keys

Learn Printing the Excel File

Description

Make Your Work Easier By Learning this Microsoft Excel course.

Microsoft Excel is one of the most used products of Microsoft office & used for data entry, data analysis, data presentation, or calculation. This MS Excel course is Beginner to Intermediate Level training especially for engineers, auditors, record keepers, data analysts, data entry operators, students, teachers, or researchers, or for anyone who just wants to learn MS Excel. If your interest lies in any of the above-mentioned areas or any other field where Excel is used then this MS Excel training course really going to help in your work.

Excluding the preview video, this Microsoft Excel course has a total of 42 video lectures with a total length of almost 4.5 hours. This course is designed by assuming that you have very basic knowledge of excel or you are totally beginner & started using MS Excel the very first time. Just to facilitate the beginners, some basic or entry-level topics are also included but you can skip those if you already have the basic knowledge.

This course is designed in Microsoft Excel 2016 version but you can easily learn in almost any older or latest version of MS Excel.

Excel sample files or excel practice worksheets are attached that you can download & practice on. Also, the MS excel shortcut keys file is attached.

This course is divided into the following different sections:

1. Introduction


Get Instant Notification of New Courses on our Telegram channel.


2. Mathematical Functions in Excel

3. Absolute & Relative References and Excel Cell Name

4. Formatting & Data Types in Excel

5. Roaming in Excel Worksheet or Workbook

6. Operators & Equations in Excel

7. AutoFill, Paste Special Options & Excel Errors

8. Logical Functions in Excel

9. VLOOKUP Function in Excel

10. Auditing in Excel

11. Inserting Charts, Tables, Comments & Hyperlink

12. Info, Text, Date, Time & Reference Functions

13. Data Tools in Excel

14. Conditional Formatting, Sort & Filter Options

15. Printing & Viewing

I strongly believe that this MS excel course will really be worth watching for you & I am sure that you will be very happy to choose this. 

Just hit the enroll button & start learning today.

English
language

Content

Introduction
Introduction to MS Excel Interface
Mathematical Functions in Excel
Basic Math Functions
Auto Sum in Excel
Sum IF Function & Remove Duplicates Option in MS Excel
Sum IF & Sum IFs, Count IF & Count IFs Functions in Excel
Sub Total Function in Excel
Arrays & Sum Product Function in Excel
Some Other Math Functions
Quiz #02 – Mathematical Functions in Excel
Absolute & Relative References and Cell Names in Excel
Absolute & Relative References in Excel
Cell or Range Name in Excel
Quiz #03 – Absolute & Relative References and Cell Names in Excel
Formatting & Data Types in Excel
Formatting Techniques in Excel
Data Types in Excel
Quiz #04 – Formatting & Data Types
Roaming in Excel Worksheet or Workbook
Roaming in Excel Worksheet
Go to & Replace Options
Quiz #05 – Roaming in Excel
Operators & Equations in Excel
Operators Used in Excel
Equation Writing or Solving in Excel
Quiz #06 – Operators & Equations in Excel
AutoFill, Paste Special Options & Excel Errors
Auto Filling the Data in Excel
Copy, Paste & Paste Special Options
Excel Errors
Logical Functions in Excel
Logical Function IF
Logical Function IF Error
Logical Functions (IF, Nested IF, OR)
Logical Function AND
VLOOKUP Function in Excel
VLOOKUP Function
VLOOKUP with Data Validation
VLOOKUP with Wildcard
VLOOKUP with Helper Column
Nested VLOOKUP
Auditing in Excel
Auditing Using Charts
Sheet Formulas Auditing in Excel
Quiz #10 – Auditing in Excel
Inserting Charts, Tables, Comments & Hyperlink
Charts in Excel
Tables in Excel
Inserting Comments
Inserting Hyperlink
Quiz #11 – Charts, Tables, Comments & Hyperlink
Info, Text, Date, Time & Reference Functions
Info Functions
Text Functions
Date, Time & Reference Functions
Data Tools in Excel
Text to Columns Tool
Consolidation in Excel
Conditional Formatting, Sort & Filter Options
Conditional Formatting
Sort & Filter
Quiz #14 – Conditional Formatting, Sort & Filter
Printing & Viewing
Printing & Viewing the Excel File