Excel Training and Consultancy Solutions



MS Excel : Beginner Level

The following table of topics outlines what this course will be covering :

Main topics specific areas A brief description of what we'll be covering
     
1. What is a spreadsheet ?   What *exactly* a "spreadsheet" is, what they contain and why we use them
     
2. Opening a workbook new How to open a fresh workbook
 existing How to open an existing workbook
     
3. Entering data cells How to enter data into cells
 ranges How to enter data into ranges of cells
 comments How to enter useful comments as reminders
     
4. Sheet structure adding a new sheet Often, we need extra worksheets - here's how to add as many as is needed
 renaming a sheet Naming worksheets makes navigating your workbook much user-friendlier
 deleting a sheet Deleting un-needed worksheets keeps your workbook much user-friendlier
 moving a sheet Often, ordering your worksheets keeps your workbook much user-friendlier
     
5. Zoom in We can zoom into a worksheet to make viewing the details much easier
 out We can also zoom out on a worksheet for a more overall picture of the
  information on it
     
6. Editting data   We all make mistakes : here's how we easily edit, or change, existing
  information already inputted into our worksheet
     
7. Undo / redo   Ten minutes ago, we did something we shouldn't have : undo lets
  us reverse that particular entry in half a second. Redo lets us reverse
  any reversals
     
8. Deleting data delete key How to delete the info in a cell or a range of cells
 delete entire row Sometimes, we get a whole row of data we don't need : here, we
  delete that entire row
 delete entire column Sometimes, we get a whole column of data we don't need : here, we
  delete that entire column
 shift cells up/down/right/left The difference between deleting data from a cell and deleting the actual
  cell itself
     
9. Formatting data numbers The boss wants your numbers to be in a " 5,000.00" format rather than
  the existing "5000.0" format : it's easily done with formatting
 dates Again, Accounts prefer their spreadsheet dates in a "20/05/2004" format,
  rather than your "20-May-04" format : formatting takes care of this
 times Payroll need your worksheets to show an AM/PM indicator : again,
  formatting easily covers this
     
10. Formatting cells borders Put borders around your cells or range of cells : handy to show tables of info
 font colours Make certain sets of info different colours : surnames in blue, for example
 background colours Colour certain cell backgrounds different to the default white
 alignments How to create aesthetic-looking headers, totals and tables of
  info via alignment
     
11. Moving around keyboard Here's how to save maybe half an hour every day by making use of
  keyboard shortcuts to navigate around your workbook
 mouse Another way to save maybe half an hour every day by making use of
  the mouse to navigate around your workbook
     
12. Drag and drop   Moving info from one place to another easily
     
13. Copy clipboard An explanation of the clipboard when used in copy/paste and cut/paste
 paste How to copy info and its formatting from one place to another
 paste special options A look at this very useful option which can save hours of laborious work
     
14. Cut   Cutting info from one place to another
     
15. Autofill automatic Here's how to automatically fill a range with logical information, formulae
  and often-used info
     
16. Operators + (plus) How to use the addition operator
 - (minus) How to use the deduction operator
 / (divide by) How to use the division operator
 * (multiply by) How to use the multiplication operator
     
17. Links formulae same sheet Using links to other information begins to make your spreadsheet dynamic
  and time-saving
 different sheet You can also link to information on other sheets within your workbook
 different workbook Linking to other workbooks opens up lots of possibilities : here's how
  to do it and how to maintain those links
     
18. Goto special options comments How to use this time-saving option to locate all the comments in a range
  you highlight
 constants How to use this time-saving option to locate all the constants you specify
  in a range you highlight : ie just text, or just numbers
 formulae How to use this time-saving option to locate all the formulae in a range
  you highlight
 blanks How to use this time-saving option to locate all the blank cells in a range
  you highlight
     
19. Find   Using "find" to locate specific text within your worksheet : ie "Smith" within a
  list of entries 10,000 rows deep
     
20. Replace   Further to "find", use "replace" to replace specific text within your worksheet
  with something else: ie replace "Smith" within a list of entries 10,000
  rows deep with "Jones"
     
21. Tools / options zero values How to supress the showing and printing of any cells with a "0" in them
 gridlines How to supress the showing and printing of any gridlines
     
22. Print setup   Don't let a bad print setup ruin your worksheet when it's printed : here's
  how to set it up properly
     
23. Print preview   How to check your printed work before you send it to the printer
     
24. Toolbars showing How to display the toolbars that hold the icons you use regularly
 hiding How to hide the toolbars that you don't need
     
25. Functions =SUM How to sum a range of numbers
 =MAX How to find the maximum number in a range
 =MIN How to find the minimum number in a range
 =UPPER How to convert text to all uppercase (all capital letters)
 =LOWER How to convert text to all lowercase (no capital letters)
 =PROPER How to convert text to all propercase (capitalising each first letter)



[Place a provisional booking]






        Home        
                 
Frequently asked questions       Contact us       Course documentations
Course locations       About us       Consultancy details