Business Applications of Microsoft Excel 2016 – Basic Level

Business Applications of Microsoft Excel 2016 – Basic Level, available at $19.99, with 84 lectures, and has 3 subscribers.

You will learn about You will Master Microsoft Excel from the Beginner level, but will become familiar with the most common Excel formulas and functions used in offices if the student goes ahead to enrolled on the Intermediate level of the course. Master the tricks of Excel financial and statistical functions and their applications in everyday business life, covered mostly at the Intermediate level. Master the basic useful formulas like SUM, AVERAGE, IF, SUMIF, COUNTIF, AVERAGEIF, VLOOKUP and a host of others. Master all the areas of Business Applications of Microsoft Excel you’ve never heard of. Master the Excel data entry and formatting features for working at Freelance sites. Master all the Keyboard Shortcuts and impress your boss and colleagues with your new skills Master how to print worksheet data and be quicker at carrying out regular tabulation tasks. This course is ideal for individuals who are Persons that want to learn Microsoft Excel from the very Basics to Intermediate level. or A business professional who needs to enhance his/her skills. or A recent graduate with an empty looking CV (resume) and no job experience. or A new freelancer that needs additional knowledge to succeed in freelance sites or A worker struggling to get a pay-rise and/or promotion. It is particularly useful for Persons that want to learn Microsoft Excel from the very Basics to Intermediate level. or A business professional who needs to enhance his/her skills. or A recent graduate with an empty looking CV (resume) and no job experience. or A new freelancer that needs additional knowledge to succeed in freelance sites or A worker struggling to get a pay-rise and/or promotion.

Enroll now: Business Applications of Microsoft Excel 2016 – Basic Level

Summary

Title: Business Applications of Microsoft Excel 2016 – Basic Level

Price: $19.99

Number of Lectures: 84

Number of Published Lectures: 84

Number of Curriculum Items: 84

Number of Published Curriculum Objects: 84

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

You will Master Microsoft Excel from the Beginner level, but will become familiar with the most common Excel formulas and functions used in offices if the student goes ahead to enrolled on the Intermediate level of the course.
Master the tricks of Excel financial and statistical functions and their applications in everyday business life, covered mostly at the Intermediate level.
Master the basic useful formulas like SUM, AVERAGE, IF, SUMIF, COUNTIF, AVERAGEIF, VLOOKUP and a host of others.
Master all the areas of Business Applications of Microsoft Excel you’ve never heard of.
Master the Excel data entry and formatting features for working at Freelance sites.
Master all the Keyboard Shortcuts and impress your boss and colleagues with your new skills
Master how to print worksheet data and be quicker at carrying out regular tabulation tasks.

Who Should Attend

Persons that want to learn Microsoft Excel from the very Basics to Intermediate level.
A business professional who needs to enhance his/her skills.
A recent graduate with an empty looking CV (resume) and no job experience.
A new freelancer that needs additional knowledge to succeed in freelance sites
A worker struggling to get a pay-rise and/or promotion.

Target Audiences

Persons that want to learn Microsoft Excel from the very Basics to Intermediate level.
A business professional who needs to enhance his/her skills.
A recent graduate with an empty looking CV (resume) and no job experience.
A new freelancer that needs additional knowledge to succeed in freelance sites
A worker struggling to get a pay-rise and/or promotion.

What readily comes to your mind when you think about Excel? Calculations! You may say. But Excel is beyond that. Excel is the most popular business productivity tools in the world today! And in my 15 years of experience as an instructor and user of Excel, I’ve come to understand that the success of a business analyst and a business planner depends largely on his/her ability to keep track of business-situation analysis, acute data analysis, recording and presentation.

However, most computer users in business environment do not possess the requisite Excel skills to take advantage of the software.

Because of this, whenever I teach in Excel class, I usually ask students to rate their Excel skill level on a scale of 0 – 10; where 0 means complete incompetence and 10 means Excel expert. Many people usually rate themselves higher than what they actually know. I then realized that most Excel users simply don’t know what they don’t know.

The reality is that most people with portfolio of Business Analysts simply possess the skills to tabulate, enter and calculate simple data, thereby using Excel as a mere calculator. That’s all they know. The real Excel experts possess the skills to transform raw data with advanced formulas and functions, analyze insights and patterns with PivotTables, and create beautiful and dynamic visualizations with custom charts and graphs.

These real Excel experts are what I call Excel “Double Threat”. Do you think you possess the skills of Excel Double Threat? Enroll in this course now to start from basic level. There is always a beginning in everything.

And the best way to learn and master the features and functions of Excel is to enroll now in this course as a beginner in Excel,ready to tackle most of the day to day data analysis, using Excel; saving you years of frustration.

Although this course was recorded with the latest version of Excel 2016 to ensure it is up to date with all the latest features and enhancements, All functions and formulas will work in versions 2007 – 2013. Additionally, clear explanations are given where there are differences in features with the earlier versions.

This course gives you a deep, 100% comprehensive understanding of Excel’s data analysis tools and techniques, using features from Excel 2010, 2013 and 2016. Starting with the very basics of data entry and formatting, I’ll show you when, why, and how to use each function and formulas and their corresponding business applications, explain the key difference in the features of these 3-versions of Excel, i.e. 2010, 2013 and 2016 and guide you through practical, hands-on demos and exercises every step of the way.

While Practical Exercise 5 introduces you to Excel calculations, Practical Exercises 7 and 10 will open your eyes to the excellent performance of Excel in business analysis. The exercises are simple, yet very intrinsic to business use.

This course access includes practical files, homework exercises, One-on-One instructor support, Lifetime Access, which means you can always come back to review the materials, downloadable PDF eBook (140+ pages) from which the videos were made and a 100% Money-Back guarantee from Udemy!

Course Features

Uses and application of Microsoft Excel in homes and businesses.
Simple tables and data entry.
Excel data protection against unauthorized or malicious damage.
Data validation to prevent wrong data entry.
Business data conditional summation.
Business data sorting and filtering.
Conditional formatting.
Importing external data for business analysis.
Introduction to Worksheet functions and formulas used in business calculations.
Making external references to data stored outside a workbook.
Formatting Excel table
Page numbering and worksheet printing.
Lots more.

As an added bonus, you can download an entire book from which the videos were derived for this course so that you can get a “hands-on” approach to learning Excel.

Another great aspect of this course is that, at the end of this course, you will be given a CERTIFICATE OF COMPLETION. This course has practical exercises after each session so if you need to prove that you have learned the material, you have to ensure that you carry out the practicals and exercises on your own while watching the videos.

This course is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review materials. Moses Ighedo’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview

Lecture 2: Introduction to Microsoft Excel

Lecture 3: Uses of Microsoft Excel

Lecture 4: How to Start Excel

Lecture 5: First Hands-on Practical Exercise

Chapter 2: Features of Excel window

Lecture 1: Excel Screen, Starting with Quick Access Toolbar

Lecture 2: Excel Screen, Starting with Ribbon Tabs

Lecture 3: Navigating Excel Worksheet

Chapter 3: Navigating and Entering data into Worksheet

Lecture 1: Selecting Range of Cells

Lecture 2: Entering Data into Worksheet

Lecture 3: Entering Numbers as Texts

Lecture 4: Entering Dates or Times

Lecture 5: Do Your Practicals

Lecture 6: Automatically Repeat Items in Column

Lecture 7: Entering Data into Several Sheets

Lecture 8: Filling Data into other Sheets

Lecture 9: Fill Series_1

Lecture 10: Fill Series_2

Lecture 11: Fill Series_3

Lecture 12: Custom Fill Series

Lecture 13: Editing Worksheet Data

Lecture 14: Hiding rows and columns

Chapter 4: Saving and Opening Workbook

Lecture 1: Saving Workbook

Lecture 2: Saving Workbook in PDF

Lecture 3: Introduction to Excel Calculations

Lecture 4: Views in Microsoft Excel

Lecture 5: Freeze Panes to Lock Rows and Columns

Lecture 6: Creating Drop-down List of Entries

Lecture 7: Data Validation

Lecture 8: Workbook Protection

Lecture 9: Appllying Excel File-Level Protection

Lecture 10: Removing File-Level Protection

Lecture 11: Protect Workbook Structure

Lecture 12: Worksheet Protection

Lecture 13: Lock Only Specific Ranges in a Worksheet

Lecture 14: Calculations using the SUMIF Function

Lecture 15: SUMIFS Function

Lecture 16: COUNT Function

Chapter 5: More Editing Features of Excel

Lecture 1: Copy or Move Cells and Worksheets

Lecture 2: Insert Moved or Copied Cells in-between Existing Cells

Lecture 3: Copy & Paste items using Clipboard

Lecture 4: Find and Replace

Lecture 5: Editing Cells Rows and Columns

Lecture 6: Change the Width of a Column or Height of a Row

Chapter 6: Using Multiple-Sheet Workbook

Lecture 1: Using Multiple-Sheet Workbook

Lecture 2: Creating a New Sheet based on a Custom Template

Lecture 3: Renaming Worksheet and changing sheet tab colours

Lecture 4: Excel Short-cuts and Function Keys

Chapter 7: Data Sorting and Filtering

Lecture 1: Data Sorting

Lecture 2: Sorting Numbers

Lecture 3: Sort by Cell Colour and Custom List

Lecture 4: Data Filtering

Lecture 5: Filtering Numbers, Dates or Times

Chapter 8: Formatting Worksheet

Lecture 1: Formatting Worksheet by Adding Borders

Lecture 2: Apply a Pattern to Background Colour

Lecture 3: Using the Format Painter to copy formatting

Lecture 4: Conditional Formatting with Data Bars

Lecture 5: Conditional Formatting with a Formula

Lecture 6: Adding Autoshapes and Text Boxes

Lecture 7: Adding Comments to cells of the worksheet

Chapter 9: Alignment and Text Control

Lecture 1: Text Alignment

Lecture 2: Merging Cells

Lecture 3: Text Control

Lecture 4: Aligning Column Headings

Chapter 10: Formatting Data

Lecture 1: Introduction to Formatting Data

Lecture 2: Formatting Numbers

Lecture 3: Display Numbers as Dates and Percentages

Lecture 4: Convert Dates Stored as Texts to Dates

Lecture 5: Convert Numbers Stored as Texts to Numbers

Lecture 6: Formatting Texts

Lecture 7: Defining Named Reference

Lecture 8: Using Defined Names in Formulas

Chapter 11: Excel Tables

Lecture 1: Introduction to Excel Tables

Lecture 2: Renaming a Table and Creating Calculated Column

Lecture 3: Inserting Table Rows and Columns

Lecture 4: Displaying and Calculating Table Totals

Lecture 5: Import Data from External Source into Excel

Lecture 6: Exchange Data Between Access and Excel

Lecture 7: Linking to Excel Data from Access

Lecture 8: Split Text into Different Columns

Lecture 9: Intro to Printing Workbook

Lecture 10: Page Numbering

Lecture 11: Printing Several workbooks at once

Lecture 12: Bonus Lecture

Instructors

Moses Ighedo
Excel in Business Teacher

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu