Spreadsheets notes

17 notes by 13 users

This Spreadsheets notes page gathers user-made notes on formulas, cell references and Excel tips. It is for school students practising spreadsheet skills and teachers planning lessons, with resources mainly at school level. There are more than 10 notes from more than 10 users. Choose a note to get started.

Select topic

Advanced Excel Training Notes lynettles83
Excep Tips Change the shape of comment boxes in MS Excel When you go to any cell in Excel and upon right click, you will be seeing the option called “Insert Comment”, by clicking this you can insert your comment for that particu... Durga Prasad
Untitled A spreadsheet application such as Excel can store all its data in a single file. This file is called a 'workbook'. A workbook is made up of one or more 'worksheets'. A worksheet is a single tab in the spreadsheet work... hopeasaurus
Volume 1b Spreadsheet:Used in accounting for presenting business data like item quantity, cost and revenue in rows and columnsProduce accounting reports, financial models, inventory reports, quotation and personal mail listsE.g... Shek Sunny
Excel (Theory) - A formula in excel always starts with =. - Whenever working in a spreadsheet, always press the sqaure above row 1 and next to column A to autofit the whole spreedsheet.  - Refer to a cell by the column heading ... Mphokuhle Bukhwele
Intro press Alt key to get to shortcuts cell grid can be identifed by cellname : A3 | B10 ; or you can give a name for the cell by yourself in the Namebox window;this name can be used for calculating the formula; you can mo... Mukundhan Srinivasan
lesson plan Subject: Information Technology Teacher: Mr. C Thompson Form: 10 Topic: Spreadsheet Date: Week of 19/01/09 Previous Knowledge: Students already know how to insert basic formula in a spreadsheet. General Objectives: St... Craig Thompson
Text To Speech Converter In EXcel Hello Friends, you would have heard about text to speech coverting softwares. But did you ever notice tha the same feature is also available in Microsoft Excel? Excel has a great feature that converts text into speech... Durga Prasad
Hide and Unhide Worksheets securely Sometimes you would like to hide your worksheets. that means you don't want others to see some of your sheets in your excel workbook To do that, we generally hide the sheets by simply right clicking and choosing hide ... Durga Prasad
Useful Items To delete named ranges Excel 2007/2010: On the Formulas Ribbon, click Name Manager in the Defined Names group.  The Name Manager dialog box appears (pictured at the bottom of this post). Click an existing range n... faulkner.j
Untitled  Modeling: is about constructing a model. it is therefore about building representations of entities in the real world.Modelling software:   is software used for           &nbsp... Rhyse Crook
Relative Referencing Examples Relative Referencing Examples   Move from Cell A1 to Cell C4 using relative referencing:   ActiveCell.Offset(3,2).Select   Move from Cell F3 to Cell B7 using rela... Kennadie Long
Absolute Referencing Examples Absolute Referencing Examples   Select Cell C4 using absolute referencing:   Range(“C4”).Select   Move from Cell F3 to Cell B7 using absolute referencing:   Range(“B7”... Kennadie Long
Spreadsheet definitions Functions: Ready made formulas representing a complex calculations.Formulas: A formula is typed directly into the formula barNested Formula: Included more than one function or formula. Surrounded by brackets and will ... Ciarra jeffries
Spreadsheets/ Decision-making - created from Mind Map Decision-making process Organisation of data Presentation Christopher Hunt
Excel Shortcuts by Task Page 1 Page 2 Page 3 faulkner.j
Understanding Spreadsheet Terms Column Runs Vertically (Up/Down) which is circled in blue below Row runs Horizontally (across) which is circled in red belowCell is where the column and row "intersect" and is a single value and is circled in green be... j_w_7777777

More Spreadsheets resources

All Spreadsheets resources Quizzes 67 Mind maps 287 Flashcards 118

About spreadsheets notes

GoConqr Original

Using these spreadsheets notes

The notes offer different ways into spreadsheet work. Spreadsheet definitions explains terms including functions and formulas. Excel (Theory) covers how formulas begin and how to refer to cells. There are also separate notes on relative and absolute referencing examples.

For an introduction, start with Spreadsheet definitions and make a short list of unfamiliar terms. Then read Excel (Theory) alongside it to see how some of those terms are used. If you want to focus on a particular task, the notes include Excel shortcuts, worksheet hiding and text-to-speech features.

Move between formats

After reading a note, try recalling its main points without looking. Return to the relevant section when a term or step is unclear. If you want a different way to check your understanding, switch to a quiz or flashcards on the Spreadsheets unit page. Pick a note that matches the skill you want to practise.

Frequently asked questions

Which note is a useful place to start?

Spreadsheet definitions is a useful starting point if you want to become familiar with terms such as functions and formulas. Excel (Theory) can follow it, with notes on how a formula begins and how to refer to a cell. Choose the one that matches what you are practising.

What spreadsheet topics do the notes cover?

The notes cover definitions, formulas and cell references, as well as particular Excel tasks. There are separate resources on relative and absolute referencing, plus notes on shortcuts, hiding worksheets and text-to-speech. Advanced Excel Training Notes includes the IF function and using F4 in a formula.

Are these notes free to use?

Yes. Every note listed here is free to open and study without an account. The resources were made by GoConqr users, not by GoConqr. A free account also lets you save quiz scores and make your own quizzes, mind maps, flashcards and notes.