Excel for beginners – Understand why and how to use MS Excel

Learn how to start off with Microsoft Excel and start making your calculations on spreadsheets and do first reports

This course has been created to support students who are new to Microsoft Office products and in this particular case new to Microsoft Excel.

What you’ll learn

  • students will be able to create basic reports in Microsoft Excel.
  • students will become familiar with Microsoft Excel.
  • students will be able to do calculations using Excel spreadsheets.
  • students will be able to format their reports in Microsoft Excel.

Course Content

  • Understand the Microsoft Excel Application –> 7 lectures • 18min.
  • The Excel file structure –> 2 lectures • 7min.
  • Customize an Excel file –> 2 lectures • 8min.
  • Input data in an Excel file –> 3 lectures • 7min.
  • Format the content –> 13 lectures • 40min.
  • Modify the elements of an Excel file –> 2 lectures • 7min.
  • Manage Excel files –> 5 lectures • 15min.
  • Insert images, shapes and objects into an Excel file –> 6 lectures • 11min.
  • Work with charts –> 3 lectures • 10min.
  • Page Layout –> 10 lectures • 18min.
  • Basic concepts of Formulas in Excel –> 8 lectures • 36min.
  • The View Ribbon –> 3 lectures • 4min.
  • Put It All Together –> 3 lectures • 18min.
  • Exercises –> 3 lectures • 1min.

Excel for beginners - Understand why and how to use MS Excel

Requirements

  • use the computer.
  • use windows or MAC OSX.
  • have a copy of Microsoft Office.

This course has been created to support students who are new to Microsoft Office products and in this particular case new to Microsoft Excel.

If you are aiming to use your computer to do calculations and deliver reports then this is the right place.

I have been working with Microsoft Excel since 1990. I saw all the big evolution of this amazing tool and so far I consider Excel as the most complete tool to use for any electronic document from a normal preparation of spreadsheet and report to the delivery of a full management document and to the delivery of professional presentations to an audience.

In this course you will learn how to manage the main functionalities of the tool so that you will know where to find what you need and what you can use for your scopes.

You will understand why and how to use Microsoft Excel, how an an Excel file is structured and how to achieve results using tools available in the ribbons, how to use an Excel file, how to input data and content, how to format your spreadsheets and how to calculate your file results using basic formulas and calculations.

In details:

  • how to use the tools
  • how to use/add and delete Worksheets
  • how to customize the background color, font color, borders and font and data format in cells and ranges
  • how to copy and paste content, data and formats
  • how to open, save and print Excel files
  • how to insert, modify, align and format images and objects in Excel worksheets
  • how to insert charts into spreadsheets
  • how to customize the layout of the spreadsheet pages
  • how to use basic formulas (SUM, AVERAGE, COUNT, MIN, MAX, IF, …)
  • how to customize the view options of your worksheets

At the end you will be able to generate a report where data from different worksheets are linked together in formulas and the final result is displayed on another summary worksheet. We will also format the data as table and add charts to view the data graphically.