Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery lists, tracking expenses, creating invoices and bills, accounting, balance checkbooks and other financial accounts, as well as any other purpose that requires a spreadsheet or table.
This course will cover the many features of Excel 2016 and will teach you how to use them, starting with the simple and working to the most complicated. The good news is that Excel 2016 makes everything easy. By learning how to navigate the program and where to find each feature, operating Excel can become a breeze.
Microsoft Excel training courses. If you are unsure of which Microsoft Excel course you should attend we have created a free 10-question quiz, which will take no more than 5 minutes to complete. Microsoft Excel 2011 for Mac training courses Microsoft Excel 2011 Level 1 - Office for Mac. Classroom 1 Day. Excel Exposure is a free online Excel training class designed to help you learn more about the features and functionality of Microsoft Excel. The site includes video lessons, tutorials and information to help improve your Excel skills.
This course will teach you how to:
· Create a spreadsheet
· Format cells, rows, columns, and entire worksheets so they fit and match your data
· Enter data into a spreadsheet
· Use formulas and functions for math, accounting, and totaling.
· Create formulas and functions
· Calculate data
· Create charts and diagrams for your data
· Create data lists and forms
· Create and use pivot tables and pivot charts.
· Work with Excel templates
· Share and protect your worksheets and workbooks
· Use What-If Analysis to determine possible outcomes. For example, sales goals
This course was designed to teach you skills you'll need to successfully use Excel 2016. Each lesson contains instructions and illustrations to show you how to use the features, then walks you through step-by-step so you can see how everything is done. You don't need previous experience with Excel to be able to complete this course. This course will start with basic skills, then move forward to more advanced features and techniques. Although you do not need access to Excel 2016 for this course; it is highly recommended. A free trial of Excel 2016 is available on the Microsoft website.
MS Excel Basics
Editing Worksheet
Formatting Cells
Formatting Worksheets
Working with Formula
Advanced Operations
MS Excel Resources
Selected Reading
Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.
Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.
By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.
This tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications.
Before proceeding with this tutorial, you should have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations.