Basic Excel Tutorial

Follow the links below to learn everything you need to get up and running with microsofts popular spreadsheet software.

Basic excel tutorial. Many useful excel basics are described in the links below but if you are a complete beginner you might also find some useful tips on the microsoft office basic excel page. Writing content on text editors does not only involve writing to finish the task but also to check on some of the writing requirements that include spacing font grammar wording. Each cell in excel is part of a row and a column. A worksheet is a collection of cells where you keep and manipulate the dataeach excel workbook can contain multiple worksheets.

Rows are designated with numbers 1 2 3 etc shown along the left side of the spreadsheet while columns are designated with letters a b c etc shown along the top. First you need to get all the basics in place and then you can learn to do advanced stuff in excel. This page introduces some of the basic excel skills that will help when you are using functions and formulas in excel. These basic excel skills are familiarity with excel ribbons ui ability to enter and format data calculate totals summaries thru formulas highlight data that meets certain conditions creating simple reports charts understanding the importance of keyboard shortcuts.

Excel formulas can be used for basic number crunching such as addition or subtraction as well as more complex calculations such as finding a students average on test results and calculating mortgage payments. This article applies to excel 2019 excel 2016 excel 2013 excel 2010 excel for mac and excel for android. To refer to a cell use the column letter and row number together such as a1 or w22 the column letter always comes first. Now a days any job requires basic excel skills.

These excel tutorials for beginners include screenshots and examples with detailed step by step instructions. I have also been honored with the microsoft excel mvp status for my expertise in excel. Learning excel becomes a cake walk when you do it the right way. I have been training people in basicadvanced excel and dashboards for more than 10 years now.

Excel selects the ribbons home tab when you open itlearn how to collapse and customize the ribbon. How to write two lines in one cell in excel. Take a tour download template formula tutorial download template make your first pivottable download template get more out of pivottables.