Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel from Beginner to Advanced Level
Rating: 4.2 out of 5(38 ratings)
113 students

Microsoft Excel from Beginner to Advanced Level

Mastering the Microsoft Excel Application for Productivity
Created byAbraham Eninla
Last updated 7/2020
English
English [Auto],

What you'll learn

  • Understand the Microsoft Excel from the Basic to Advanced Level
  • Master the use to Microsoft Excel Tools, Commands and Functions
  • Learn Microsoft Excel Defined Functions and Formulas used in calculations and Office Tasks
  • Understand how to handle Large Data, Manipulate, Summarized and Generate Reports
  • Understand the Power of Data Analysis using Microsoft Excel
  • Master how to use PIVOT TABLE and PIVOT CHART to create Dynamic Reports and Charts
  • Understand the POWER of VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, CHOOSE, INDEX & MATCH in Data and Financial Analysis
  • Understand DATA VALIDATION, CONSOLIDATION and Using SUB TOTAL tool for creating Subtotals Calculation for grouped Items
  • Working with Charts (Column, Pie, Bar, Line Chart and lot more. Editing Charts and working on Chart Designs
  • Understanding Alignment Tools, Text and Number Formatting, and Excel Cell and Table Style Formatting
  • Working Tables, Inserting Pictures and Images into Excel Worksheet, and using Text Boxes in Excel
  • Working with Cell and Range Names for Data Analysis and Calculations. Managing Names, and creating Names from Selections
  • Using Sparklines Column and Line Charts for Horizontal and Vertical in-cell Charts.
  • Using Hyperlink Tools to create Links to Worksheets, External Files, websites and Email from Excel Worksheet
  • Removing Duplicate Transactions, Text or Number from large range of data
  • Working with Conditional Formatting Tools on Large Data e.g Sales Data
  • Most courses ignore Basic fundamental tools, which can many task easy. This Course seeks to Address all major TOOLS in Excel
  • Creating and Working with Dashboards - Slicer and Timeline Tool.
  • Creating Sensitivity Analysis using the What-If-Analysis Tools (Goal Seek, Data Table, Solver and Scenarios)
  • Working with Logical Functions (IF, AND & OR and NESTING the IF Functions)
  • Understanding Project Evaluation Techniques using Financial Functions (PV, FV, NPV & IRR)
  • Introduction to Excel Macros and VBA Automations (Macros Recording, codes, User Form creation, VBA Controls and Objects)
  • As a Microsoft Excel Certified Expert, I guarantee that this Course will also help you to pass Certification Exams as it uses Examples that we help participant familiarize with Key Excel Tools.
  • Enjoy access to a CERTIFIED MICROSOFT EXCEL EXPERT with over 2 Decades in Spreadsheet Analysis using MICROSOFT EXCEL

Course content

13 sections • 78 lectures • 17h 54m total length

  • Introduction to the Microsoft Excel Course (Beginner to Advanced Level)18:50

    Objectives of Training on Basic to Advanced Excel Course


    BASIC MICROSOFT EXCEL OBJECTIVES

    · The Basic Excel level introduces students to the Microsoft Excel application and how to use it to do normal day to day spreadsheet tasks in the office.

    · To ensure that all participants are familiar with Data handling and storage using the Spreadsheet program.

    · To expose participants to the power of using Excel functions and formula for Calculation, performing logical decisions, and data control.

    · To enhance participants reporting ability with good knowledge in the use of charts for representing Data.

    · To give participants a basic knowledge of how to use Ms-Excel to handle all office tasks that are in spreadsheet or table format, perform calculations on data, format the worksheet, plot charts, do simple data analysis, and many more.

    . To work with Images, Charts, Shapes and Smart Arts objects.

    . To work with Worksheets; rename, group, delete, colour, hide, lock and perform worksheet - Workbook structure protections.

    . To work with the AutoFill Command to automatically fill cells with required values.

    . To understand the Excel Keyboard shortcuts, Sort data, filter records, perform quick analysis on a dataset, and worksheet printing commands.

    . To understand Microsoft Excel cell referencing and applications.

    . To understand Formulas and Functions, use Maths, Statistical Functions in performing calculations on numbers.

    . To understand the TEXT and DATE Functions in Excel and applications.

    . To understand Excel Worksheet Formatting and Rules (Text, Number, Cell and Worksheet Formattings).


    INTERMEDIATE AND ADVANCED MICROSOFT EXCEL OBJECTIVES


    This course outline is designed to explore the more detailed features of Excel. It advances the user's knowledge of functions, demonstrates how to manage data with Excel, and explores how Excel is used to present data using tables and charts.


    Intermediate  to Advanced Excel Training Objectives


    · The intention of this training is to further expand participants’ understanding of the working power of the Microsoft Excel application.

    · It is also expected that at the end of the training participants will understand how to link, relate, and reference data within a workbook.

    · Further understanding of how to graphically represent data without much complexity.

    · Enhance participants’ understanding of the usefulness of financial functions for handling mortgage loans.

    · Show participants how to sort, extract and filter large data for analysis purposes.

    . To understand how to Protect Worksheets, Workbook protection and Excel File encryption.

    . To understand how to work with a range of data and convert them into database Tables for extended data analysis.

    . To understand the Microsoft Excel Database, Date, Statistical, Maths, Financial, Lookup and Reference Functions at Intermediate Level.

    · To show participants how to create organograms, graphics, logos, and background images in excel.

    . Participants would learn how to summarize large data using Pivot Table and Chart Tools, Sub Total, and the Filter Tool.

    . Consolidate periodic, regional, or departmental reports, generate executive reports from a large set of data.

    . Learn Excel Functions from Intermediate to Advanced Level (VLOOKUP, INDEX, MATCH, SUMIF, COUNTIF, SUM, COUNT, AVERAGE, IF, OR, AND, etc).

    . To Learn Data Validation Rules, Conditional Formating Rules from Intermediate to Advanced Level.

    . To Create links to other worksheets within a workbook.

    . To Use the Sparkline Chart Tools within the Excel Cells.

    . To Work with Sensitivity analysis using the What-if-Analysis tools (Goal Seek, Solver, Scenarios and Data input Tables).

    . To Use the VLOOKUP, MATCH & INDEX Function for Practical Task (Balance Sheet Statement).

    . To Use the Financial Functions (PV, FV, NPV & IRR for Project Evaluation Techniques)

    . To Work with the SUMIFS, COUNTIFS and AVERAGEIF (Case Study - Income Statement)

    . To do Simple Dashboard Creation using the Excel Worksheet.



    After completing this course, participants will know how to:

    • Start Microsoft Excel and identify the components of the Excel interface; open an Excel workbook; use the Help window; and navigate worksheets.

    • Enter and edit text, values, and formulas; insert pictures; use AutoFill; save and update a workbook, and save a workbook as a PDF file.

    • Move and copy data and formulas; use the Office Clipboard; work with relative and absolute references; and insert and delete ranges, rows, and columns.

    • Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA and other functions to perform calculations in a worksheet.

    • Use SUMIF, COUNTIF, VLOOKUP, MATCH, INDEX, IF, OR, AND Functions and many others.

    • Generate Executive Reports using the PIVOT TABLE, SUBTOTAL, DATA CONSOLIDATION, FILTER and SORT Tools

    • Format cells, rows, and columns; merge cells; apply colour and borders; format numbers; create conditional formats; copy formatting; and apply table styles.

    • Check spellings; find and replace text and data; preview and print a worksheet; set page orientation and margins; and create headers and footers.

    • Create, format, modify, and print charts based on worksheet data; work with various chart elements; apply chart types and chart styles.

    • Freeze panes and split a worksheet; hide and unhide data; set print titles and page breaks to optimize print output; manage multiple worksheets.

    . Use the Sparkline Chart Tools within the Excel Cells.

    . Work with Sensitivity analysis using the What-if-Analysis tools (Goal Seek, Solver, Scenarios and Data input Tables).

    . Use the VLOOKUP, MATCH & INDEX Function for Practical Task (Balance Sheet Statement).

    . Use the Financial Functions (PV, FV, NPV & IRR for Project Evaluation Techniques)

    . Working with the SUMIFS, COUNTIFS and AVERAGEIF (Case Study - Income Statement)

    . Simple Dashboard Creation using the Excel Worksheet.

  • Highlights of Microsoft Excel Beginners Lectures5:03

    Explore core Microsoft Excel concepts from the 2016 work environment, including freeze panes, templates, charts, formulas, functions, conditional formatting, and keyboard shortcuts for quick analysis.

  • Highlights of Microsoft Excel Intermediate Level Lectures6:33

    Master intermediate Excel topics, from creating and formatting line and bar charts with multiple series to subtotals and data consolidation, plus text and financial functions and amortization schedules.

  • Highlights of Microsoft Excel Advanced Level Lectures6:23

    Explore pivot tables and slicers, dashboards, and data organization. Learn financial analysis with present value, npv, irr, discounted cash flow, and tools like data validation, hyperlinks, vlookup, index, and vba.

Requirements

  • This Course was Created with Microsoft Excel 2016 version. However, participants with Versions 2010, 2013, 2016, 2019 and Office 365 can participate Conveniently.
  • No prior Knowledge of Microsoft Excel is required as this course seek to take learners from zero knowledge to Advanced level.
  • The Only skill required is the operational knowledge of a Computer System.

Description

The Microsoft Excel course exposes students to all available tools, command and Functions in the application. The training is carefully structured to take care of the learning needs of students, who are really yearning to know how to use Excel to carry out tasks in their workplaces. The course is also prepared to help regular users of the application, who want to upgrade their knowledge and upskill.

The Beginners to Intermediate topics capture the most frequently used command for day to day tasks. The Advanced level is also to help students learn the most advanced formulas, functions, and Tools. The advanced Excel training course builds on the beginner to intermediate course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

The advanced excel tutorial will help you start a career in the area of data and financial analysis especially in the following fields; investment banking, private equity, corporate development, and equity research. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, replay, and repeat exercises until you have mastered them.

Who this course is for:

  • New and Intending Users of Microsoft Excel
  • Accountants, Financial Analyst, Data Analyst, Human Resource Managers, Project Managers and Trainers
  • Any person who desires to know Microsoft Excel and use it for Day to Day office Task.

Report abuse