Business administration: using Word, Excel, PowerPoint and Access in the office (intermediate-level 2)

What is the course about?

On this course you will learn the key digital skills to be a business administrator. You will focus on administrative tasks typically done in an office and business environment so you become a confident user of the digital tools needed to complete these task with a clear understanding of their purpose. You will focus on producing high quality documents such as minutes, letters and flyers using Word. You will work on how to create visually appealing PowerPoint presentations that contain relevant information. You will focus in depth on how to use Excel and Access to handle, process and analyse data so you can make accurate calculations for example of sales or expenditure, present this information clearly and identify patterns and trends.

This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera is best (e.g. a PC/laptop/iMac/MacBook), or a tablet/iPad/smart phone/iPhone if you don't have a computer.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

What will we cover?

•creating high-quality well-presented documents such as letters, minutes and flyers using Word
•creating well-formatted documents and arrangement text appropriately including paragraphs, headings, footers and columns
• inserting and manipulating images within a document
• importing graphics to enhance a text
• creating, manipulating and formatting tables
• using mail merge tools to distribute documents
• previewing and printing documents
•creating visually appealing and effective PowerPoint presentations
• creating, formatting and modifying presentations using different slide layouts
• duplicating and moving texts, images, charts
• creating and modifying organisational charts
• applying slide transitions and animation effects
• applying slide designs using presets and templates
• applying various print options
•handling, processing and analysing business data using Excel and Access
• identifying the purposes and functions of spreadsheets
• inserting and formatting data so it is easy to read
• creating, formatting and adjusting charts including basic pivot tables and charts
• using formulae and functions and copying them to other cells
• applying settings for printing
• understand the basic concept and purpose of a database
• creating and modifying tables, forms, queries and reports within Access
• using queries to search and extract data based on specific criterion.
• importing data from different types of applications
•linking an Excel file within Access.

What will I achieve?
By the end of this course you should be able to...

•create high-quality well-presented documents such as letters, minutes and flyers using Word
•create well-formatted documents and arrangement text appropriately including paragraphs, headings, footers and columns
• insert and manipulate images within a document
• import graphics to enhance a text
• create, manipulate and format tables
• us mail merge tools to distribute documents
• preview and print documents
•create visually appealing and effective PowerPoint presentations
• create, format and modify presentations using different slide layouts
• duplicate and move texts, images, charts
• create and modify organisational charts
• apply slide transitions and animation effects
• apply slide designs using presets and templates
• apply various print options
•handle, process and analyse business data using Excel and Access
• identify the purposes and functions of spreadsheets
• insert and format data so it is easy to read
• create, format and adjust charts including basic pivot tables and charts
• use formulae and functions to make calculations and copy them to other cells
• apply settings for printing
• identify the basic concept and purpose of a database
• create and modify tables, forms, queries and reports within Access
• using queries to search and extract data based on specific criterion.
• import data from different types of applications
•link an Excel file within Access.

What level is the course and do I need any particular skills?

You should be a confident computer user with good file management skills and a familiarity with Word, PowerPoint and Excel. We have many level 1 foundational courses you can do to ensure you are at the right level for this course. See below or contact universal.skills@citylit.ac.uk.

How will I be taught, and will there be any work outside the class?

You will learn in a supportive and welcoming environment with an emphasis on your discovering how to do and complete tasks, with guidance from the tutor. You will work on your own and with other students on different tasks so you are always practising important in-demand life and work skills such as problem-solving, decision-making, prioritising, negotiating, collaborating and independence. You will learn in a step by step manner so you can complete challenging tasks in enjoyable and relaxing ways. Your tutor will also work with you individually so you know how to improve and how to work in a way that improves your learning. You will need to do work outside the classroom and use Google Classroom to help you.

Are there any other costs? Is there anything I need to bring?

You will need a pen, A4 paper and a folder to keep your work in. Your tutor will provide handouts and a code for Google classroom so you can communicate with classmates and access materials, videos etc. online.

When I've finished, what course can I do next?

There are many courses you can do before, during or after this course including our Business Administration series. These include:
• Business administration with digital skill: how to be an administrator (foundation)
• Business administration: ICT skills for business (advanced)
• Business Administration: how to be a PA (foundation)
• Touch typing and keyboard skills
• Business Administration: getting ready for level 3 certificate in IT user skills - ICDL Advanced (intermediate)
• Business Administration with digital skills: how to be organised, efficient and customer-focused using Outlook and OneNote (intermediate)
• Business administration: how to organise and manage with OneNote, MS Outlook and OneDrive (intermediate)
• Digital skills for the workplace: working with data - inputting, finding, sorting, filtering with Excel (foundation)
• Digital skills for business: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for business: visualising data with Excel - from column charts to scatter plots (intermediate)

You can also do classes in the maths and English areas. These include:
• Maths for business: the essential skills to run a company and make a profit (level 1-2)
• Workplace communication with digital skills: English for the office and business (intermediate level 1-level 2)
• Business administration with digital skills: communication skills in a business environment (advanced level 2)

For more information, talk with your tutor or contact universal.skills@citylit.ac.uk / 020 4582 0423.