MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 552 MB | Duration: 3h 19m

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

Learn how to start off with Microsoft Excel and start making your calculations on spreadsheets and do first reports
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

Requirements

use the computer

use windows or MAC OSX

have a copy of Microsoft Office

Description

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.

Who this course is for:

Anyone who wants to learn how to use Microsoft Excel as students in schools and univerities or for professional purposes

Anyone who needs to do reports in spreadsheets

Anyone who needs to do calculations and report results on spreadsheets or tables




DOWNLOAD
uploadgig.com