fbpx

Microsoft Excel Complete Course from Zero to Hero

Promotional Video

Course Features and Bonus

  • Lifetime Access & Updated
  • Complete Materials (pdf-Powerpoint Slide-Excel Files Exercises-Quick Study Guide-Others Articles)
  • Quizes
  • Assignments
  • Training Project
  • Guarantee Satisfaction
  • Support & Answer Question
  • Close Facebook group for more skills and knowledge
  • 3 Templates demo
  • 10% discount for others Excel courses
  • Training Certificate

Course Objectives

  • How to use Excel Interface and Component

  • Build Mathematical Formula and Performing Calculation

  • Use Excel Build-in Functions

  • Printing Data

  • Data Management

  • Improive Data Visualization

  • Extract Reports

  • Data Analysis and Forecasting

Course Description

Organizations across the world over rely on information to make sound decisions regarding all manner of affairs but with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging.

So you will face a great challenge and obstacle in saving and formatting the data in an easy and simple way in order to make it easier for you to query and analyze the data.

Fortunately, this is where the power of Microsoft Office Excel can help.

Excel can help you organize, calculate, analyze, revise, update and present your data in ways that will help the decision makers in your organization steer you in the right direction.

It will also make these tasks much easier for you to accomplish, and in much less time,than if you used traditional pen-and-paper methods or non-specialized software.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage.

You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes.

As this level of use and collaboration, you have also likely encountered your fair share of issues and challenges.

You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do.

Course Outline

Chapter One : Getting Started with Excel

  • Excel Interface
  • Enter Data
  • Save File Formats
  • Copy & Paste Options
  • AutoFill & FlashFill
  • Excel Shortcuts
  • Data Format
  • Insert & Delete & Hide Column and Row
  • Worksheet Management

Chapter Two : Performing Calculations

  • Build Formula
  • Order of Operations
  • Insert Functions
  • Relative & Absolute References
  • Name Ranges
  • Format Cells
  • Manage Views
  • Errors Code

Chapter Three : Printing

  • Printing Data
  • Header & Footer

Chapter Four : Managing Data

  • Sort
  • Filter
  • Tables
  • Text To Column
  • Data Validation
  • Link Cells
  • Data Protection
  • Macro

Chapter Five : Advanced Functions

  • IF Function
  • Specialized Functions (SUMIF-AVERAGEIF-COUNTIF)
  • VLOOKUP-HLOOKUP
  • INDEX-MATCH
  • 3D Formula
  • Date and Time Functions
  • Text Functions
  • Database Functions

Chapter Six : Data Visualization

  • Outline
  • Subtotal
  • Conditional Formatting
  • Chart
  • Pie Chart
  • Advanced Chart
  • Trendline
  • Pivot Table
  • Pivot Chart
  • Slicer
  • Timeline
  • Sparklines
  • Map Data

Chapter Seven : Data Analysis

  • PMT
  • Goal Seek
  • Data Table
  • Scenarios
  • Forecasting

Target Audience

  • This course is intended for Students, Employees in all fields, Entrepreneurship – Project Managers – Financials – HR- Quality – Development – Statisticians and Analysts who want to acquire the basic concepts of Microsoft Excel to create electronic spreadsheets and acquire advanced concepts of Excel such as analysis and forecasting, use of advanced functions and also intended for who have experience using Excel and want or need to develop their skills in working with some of automating tasks and more advanced features

Course Requirement

  • Basic Computer Skills

  • Microsoft  Excel Application