After learning the material in this tutorial, you'll become familiar with the fundamentals of creating precise and professional spreadsheets. You'll learn how to employ menu and toolbar commands, create a worksheet and import and combine data. You'll be able to work with cell ranges, manage rows and columns and implement formulas.

After learning the material in this tutorial, you'll not only be able to create your own spreadsheets, but you'll also know how to enhance the appearance of your data and protect it. This means you'll be able to create formatting effects such as, rotating text, applying frames, borders, and much more. You will be able to lock your workbook file to protect your data and even be able to create charts or maps for a worksheet.

After learning the material in this tutorial, you'll be able to create and work with named ranges, versions, databases or query tables as well as macros. You'll also learn how to embed data and make changes to it. Using 123's Internet tools, you'll be able to create hyperlinks to a Web site, use data from the Internet in your own spreadsheet, and convert a range of data to a Web page.

After learning the material in this tutorial, you will be able to use and work with a variety of formulas and functions ranging from financial to statistical. You will also be familiar with and be able to use Regression, What If tables, and the Backsolver to analyze data.

After learning the material in this tutorial, you ll be able to create charts and maps as visual references for your data that will not only enhance it, but also present it in an easy to understand format. You will also be familiar with and be able to use macros and scripts to make your day-to-day tasks in spreadsheets easier to perform.