Making Progress in MS Excel: Level Two

8 – 9 February 2023

If you have some existing knowledge of Excel functions and wish to enhance and refresh your skills, this course is for you.

 

Learn to organise table data, present data as charts and enhance the look and appeal of workbooks by adding graphic objects. Upon successful completion of this course, students will have the necessary skills to:

  • Organise worksheet and table data using various techniques
  • Create and modify charts
  • Manipulate more complex formulas and functions
  • Insert and modify graphic objects in a worksheet
  • Customise and enhance workbooks and the Microsoft Excel environment
Course Content:
  • Review of formulas and functions: Further formulas and functions: Working with dates and percentages: Functions and the formula palette: Absolute Cell Addressing: Displaying underlying formula
  • Printing and formatting: Custom formatting: Hiding columns and outlining
  • Worksheets and workbooks: Working with multiple worksheets: Creating a workspace
  • Working with lists: Filtering data: Sorting data: Analysing data using subtotals
  • Creating charts: Modifying charts: Printing charts: Further customisation
  • Other features: Sharing workbooks: Worksheet auditing: Adding comments
  • We finish by building our own spreadsheet, using the knowledge we have gained.

To get the best out of this online course the attendees should have access to a large screen device.

 

 

Is this course for me?

The main elements of our level two Excel training are listed below. If you feel ready to tackle these, you can probably jump straight to level two. If they look too difficult, you should probably take the level one course first.

  • USING DATES IN EXCEL: How Excel uses numbers to define dates. Using dates in formulas. How Excel displays the time. Finding days of the week.
  • THE EXCEL FORMULA PALETTE. Some examples, such as using ISBLANK, and SUMIF. The difference with SUMIF and SUMIFS. Other useful functions. Linking to a website or email address. Creating a web address.
  • THE IF FUNCTION. An in-depth look at one of Excel’s main formula tools – the IF function. Copying IF functions. Nested IF functions. IF functions with more than one condition. Using conditions that are mutually exclusive.
  • THE VLOOKUP FUNCTION. Another in-depth look at a really useful Excel tool – the VLOOKUP function. We finish by looking at how to combine the IF and VLOOKUP functions in one formula.
  • ABSOLUTE VERSUS RELATIVE ADDRESSING: The difference between Absolute and relative addressing in your formulas. Using Absolute addressing. Locking into a cell reference.
  • CHARTS AND GRAPHS. Chart designs. Basic charts types. Labelling your charts. Creating and labelling graphs. Formatting options for charts and graphs.

Attending the course

This course will be delivered on Teams and it will take place over two morning sessions:

Wednesday 8th February – 9.30am to 1.30pm
Thursday 9th February – 9.30am to 1.30pm

Places on the course are very limited and learners are expected to take part both days and join in hands-on activities. The course is funded by UNISON for members. 

To apply for a place please complete and submit the following form:

Tagged

Print / Translate

Print page Translate page

More on this

Lifelong learning co-ordinator

Branches, through their officers, have responsibilities to… provide opportunities for the education of members and the development of activists UNISON Code of Good Branch Practice The role of the lifelong learning co-ordinator is to lead on member learning in the branch. They work closely with the branch education co-ordinator and the same person might even […]

English, maths and IT

Are you interested in improving your English, maths or IT skills? Your employer has a responsibility to address your training needs in these areas. You can also contact your region for information about courses or providers in your area. UNISON has a national agreement with the WEA. GCSE maths and English courses are often free at […]

Our partnerships

UNISON works in partnership with a number of well-known organisations, networks, and programmes. Open University The Open University and UNISON partnership is based firmly on a shared goal – to widen access to education and training to extend learning opportunities to those who have previously been unable to access them. To achieve this goal, both […]

The Open University

In 2004 UNISON and The Open University joined forces to open up doors to learning for public service workers, and over nearly two decades thousands of UNISON members have taken advantage of our partnership to get qualifications, broaden their skills and knowledge, and move on in their careers. We’re now working together to review and […]

Return to Learn and Women’s Lives

These 10-week courses are designed for members who may have been away from learning for some time. They’re run for us by the Workers Educational Association (WEA) in a welcoming and supportive environment. There are no exams to take. It’s nothing like going back to school! At the end of the course you will receive […]

Member learning

UNISON has a proud history of providing high quality learning opportunities for our members. We work with trusted national institutions like The Open University and the Workers’ Educational Association (WEA) and a host of local providers, and we also deliver informal learning in-house. Whether you’re already a keen learner, or just beginning to explore the […]