Excel spreadsheet tutorial for beginners. To take advantage of this function you need to learn about formulas which are essentially math equations. Well discuss how to insert rows and columns and how to move around in a worksheet. The cells in the first row are a1 b1 c1 and so on. Select cells a1 to d1 to highlight them.
Grab your free exercise file here. Opening a spreadsheet 3. Managing your worksheets 5. An excel worksheet or spreadsheet is a two dimensional grid with columns and rows.
Working with the ribbon 4. This excel for beginners guide teaches you everything you need to know about excel spreadsheets and formulas to perform financial analysis. The column names are letters of the alphabet starting with a and the rows are numbered chronologically starting with the number one. If youre an excel beginner or an intermediate and want to learn excel this is the perfect place for you to start.
You dont need to sign up or do anything to get access to the course. This page gives you access to a completely free online excel training 26 video lessons with 12 hours of learning. A beginners guide to getting started 1. Click on the home tab of the ribbon.
Unlocking the power of functions 8. Look at the spreadsheet below. An excel spreadsheet is helpful for displaying information in an organized way but excel can be used for so much more. Excel made easy excel made easy a beginners guide greetings.
Watch the video and learn everything a beginner needs to know from what is excel to why do we use and what are the most important keyboard shortcuts functions and formulas.