Excel Intermediate Test ????

macymoo

I have a job interview tomorrow for a County Council and have been told I will have to take an Excel Intermediate test does anyone know what sort of thing I will need to know????? Thanks

thomas01155

Not sure if this will help you i found it on here http://www.privatelessons.net/computer_excel_inter.asp

• Freezing Columns and Rows
• Inserting and Deleting Worksheets
• Consolidating Data with 3-D References
• Hiding and Protecting Worksheet Areas
• Saving Custom Views of a Worksheet
• Controlling Page Breaks and Page Numbering
• Creating a Hyperlink between Excel Files
• Saving an Excel file as an L Document
• Practice

• Planning a Macro
• Recording a Macro
• Running a Macro
• Editing a Macro
• Using Shortcut Keys with Macros
• Using the Personal Macro Workbook
• Adding a Macro as a Menu Item
• Creating a Toolbar for Macros
• Practice
• Using Lists
  • Planning a List
  • Creating a List
  • Adding Records with the Data Form
  • Finding Records
  • Deleting Records
  • Sorting a List by One Field
  • Sorting a List by Multiple Fields
  • Printing a List
  • Practice
  • Analyzing List Data
    • Retrieving Records with AutoFilter
    • Creating a Custom Filter
    • Filtering a List with Advanced Filter
    • Extracting List Data
    • Creating Subtotals Using Grouping and Outlines
    • Looking Up Values in a List
    • Summarizing List Data
    • Using Data Validation for List Entries
    • Practice
    • Unit 5: Enhancing Charts and Worksheets
      • Selecting a Custom Chart Type
      • Customizing a Data Series
      • Formatting a Chart Axis
      • Adding a Data Table to a Chart
      • Rotating a Chart
      • Enhancing a Chart with WordArt
      • Rotating Text
      • Mapping Data
      • Practice
      • Unit 6: Sharing Excel Files and Incorporating Web Information
        • Ways to Share Excel Files
        • Setting Up a Shared Workbook
        • Tracking Changes in a Shared Workbook
        • Applying and Removing Passwords
        • Creating a Worksheet for an Intranet or the Web
        • Creating Interactive PivotTables for the Web or Intranet
        • Creating Hyperlinks between Excel Files and the Web
        • Running Queries to Retrieve Data on the Web

PhilCo_2

vlookups are always good to know especially as a lot of people in offices struggle with them.

piggeh

Intermediate will be getting into functions, filters, vlookups, pivot tables, and probably basic macros. However also make sure you know the options in the drop down boxes etc., such as setting print areas, setting filters, conditional formatting, etc.

Mind you when I worked at the council people knew very little excel. It's only when I've left that I've realised how much time could have been saved with a couple of macros or just a couple of vlookups.

Poppy9

I would assume the test would be related to the job. Is it a finance job, if so make sure you know how to enter formulae.

I work in finance for County Council and I use excel for

Vlookup
Macros
Linking files
Importing/Exporting data to other systems
Filters etc.

PhilCo_2

Offset is another good one to learn, very useful especially when combined with other functions but very underused.

macymoo

Thanks for all your help, I have just got back from Interview and scored 90% so quite good, but 300 applicants for 4 positions so not holding my breath !!

Poppy9

What did the test involve?