Alternatively referred to as a worksheet, a spreadsheet is a file that consists of rows and columns to help sort data, arrange data easily, and calculate numerical data.
Alternatively referred to as a worksheet, a spreadsheet is a file that consists of rows and columns to help sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas by applying them to the data in cells. A good example of how a spreadsheet may be utilised is by creating an overview of your bank balance. Excel allows you to store, organise, and analyse information quickly and efficiently. In this lesson, you will learn how to find your way around the Excel 2010 environment, including the new Backstage view, replacing the Microsoft button menu version of 2007. In addition, you will learn how to use and modify the Ribbon and the Quick Access Toolbar and how to create new as well as open existing workbooks.
Course Content
- Identifying the elements of the Excel interface
- Navigate and select cells in worksheets
- Customise the Excel interface
- Create a basic worksheet
- Opening and saving
- Creating Formulas in a worksheet
- Insert functions in a worksheet
- Copying and pasting formulas
- Calculate formulas over multiple sheets
- Edit worksheet data
- Find and replace data
- Copy, cut, paste and BODMAS (Brackets over Division, Multiplication, Addition and Subtraction)
- Automatic fill
- Apply font properties
- Add borders and colours to cells
- Align content in a cell
- Apply number formatting
- Apply cell styles
- Adjust the row height and column width
- Insert and delete rows and columns
- Managing worksheets
- View worksheets and workbooks
- Define the page layout
- Print a workbook
- Printing the same row on each page
- Printing area
- Using comments
- Spelling
- Automatic word corrections
- Google sheets
- Non-accredited: Short course only
- Duration: 1h 55m
- Delivery: Classroom/Online/Blended
- Access Period: 12 Months
