MS Office Excel

User Avatar
Aden
(0 review)
£99.00
microsoft-logo

What’s new in Excel 2019

  • Creating workbooks
  • Entering text, numbers and working with dates
  • Navigating workbooks
  • Page setup and print options
  • Working with rows, columns, and cells
  • Cut, Copy and Paste
  • Introduction to Functions and Formulas
  • Formatting in Excel, including formatting cells and numbers
  • Creating charts and graphs
  • Sorting and Filtering
  • Introduction to PivotTables
  • Logical and lookup formulas – the basics

Advanced Microsoft Excel 2019

  • What’s new/different in Excel 2019
  • Advanced charting and graphing in Excel
  • How to use detailed formatting tools
  • Lookup and advanced lookup functions
  • Financial functions including calculating interest and depreciation
  • Statistical functions
  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
  • How to create awesome visualizations using sparklines and data bars
  • Mastery of PivotTables and Pivot Charts
  • Scenario Manager, Goal Seek and Solver
  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

Course Features

  • Lectures 13
  • Quizzes 14
  • Duration 24 hours
  • Skill level All levels
  • Language English
  • Students 101
  • Certificate Yes
  • Assessments Yes

  • Intro to Excel 0

    No items in this section

  • Excel 2019 27

    • Lecture2.1
      Course Exercise Files
    • Lecture2.2
      What’s New In Excel
    • Lecture2.3
      Course Overview
    • Lecture2.4
      Overview of the Excel
    • Lecture2.5
      Creating Workbooks
    • Lecture2.6
      Entering Text and Numbers
    • Lecture2.7
      Creating Basic Formulas
    • Lecture2.8
      Relative References
    • Lecture2.9
      Order of Operations
    • Lecture2.10
      Working with Ranges
    • Lecture2.11
      Module 2 – Practice Exercise
    • Lecture2.12
      Saving Workbooks
    • Lecture2.13
      Navigating Workbooks
    • Quiz2.1
      Page Setup & Print Options 0 question
    • Quiz2.2
      Working with Rows, Columns and Cells 0 question
    • Quiz2.3
      Moving Data 0 question
    • Quiz2.4
      Formulas & Functions 0 question
    • Quiz2.5
      Working with Sheets 0 question
    • Quiz2.6
      Formatting Worksheets 0 question
    • Quiz2.7
      Charts, Working with Names, Sorting and Filtering 0 question
    • Quiz2.8
      Outlining and Subtotaling Working with Views, Linking Advanced Formula Creation 0 question
    • Quiz2.9
      Pivot Tables, Additional Excel Features Shortcuts 0 question
    • Quiz2.10
      Functions. Date and Time Functions ,Text Functions,Logical Functions 0 question
    • Quiz2.11
      Lookup Functions, Financial Functions, Statistical Functions 0 question
    • Quiz2.12
      Connecting to External, Data Tables, Pivot Tables 0 question
    • Quiz2.13
      Data Analysis 0 question
    • Quiz2.14
      Graphs and Charts, Surface Charts, Radar Charts, Bubble Charts, Spark lines, Stock Charts 0 question
author avatar
Aden
Aden has Over 5,6 years hands-on technical experience in Enterprise network and cloud domain handling design and implementation. He is also certified in Cisco, Microsoft, VMware and various vendors. He is also certified in Teaching and Training in the Lifelong Learning Sector. He works as a full-time lecturer, as a data analyst and Technical Trainer in Brightnetworks. Aden uses teaching and training experience, and variety of training approaches to help learners overcome their different barriers and challenges, and to date has helped hundreds of learners to develop IT skills and get started in the industry.

Reviews

Average Rating

0
0 rating

Detailed Rating

5
0%
4
0%
3
0%
2
0%
1
0%
£99.00

Leave A Reply

Your email address will not be published. Required fields are marked *