Business Administration: Word, Excel, PowerPoint and Access (intermediate-level 2)

Course Dates: 19/06/23 - 31/07/23
Time: 10:00 - 13:30
Location: Keeley Street
Do you want to learn the digital skills needed for office and administration work? On this course, you will focus on completing the keys tasks required to be a business administrator. You will learn how to produce high quality and well-presented documents such as minutes, formal letters and flyers using Word. You will develop your skills in producing presentations with PowerPoint that are visually appealing, modern and effective. You will also work in depth on how to use Excel and Access for data handling, processing and analysing, including how to enter and edit data, arrange and present it effectively, make calculations and highlights data trends.
You need a pre-course assessment face-to-face or online. Contact (telephone temporarily unavailable) / universal.skills@citylit.ac.uk or click on the Start Assessment button on this webpage.
This course is FREE if a) you are on a Low Wage or b) you are either on Jobseekers' Allowance (JSA) or Employment & Support Allowance(ESA) or c) you want to get a job or progress into a better job and you receive other state benefits (including Universal Credit). For more information click here
Download
Book your place
In stock
SKU
201694
Full fee £269.00 Senior fee £215.00 Concession £135.00

Check your level

Course Code: CBA03

Mon-Tue, day, 19 Jun - 31 Jul '23

Duration: 13 sessions (over 7 weeks)

Before booking on this course, please register or log in to your account to complete a short online assessment. We need you to do this to check that this course is the right level for you.
Why do I need an advice session?

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

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.

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. These include:
• Digital skills for the workplace: using Excel (foundation)
• Essential digital skills for the workplace: Word, Excel and PowerPoint
• Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
• Business administration: how to be an administrator for beginners (with digital skills)
• Business administration: ICT skills for business (advanced)
• Business administration: how to organise with OneNote (intermediate)
• Business administration: how to organise and manage with OneNote, MS Outlook and OneDrive (intermediate)
• Touch typing and keyboard skills
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (intermediate-level 2)

There also many maths, English, employability and communication skills courses you can do. Ask your tutor or contact universal.skills@citylit.ac.uk / (telephone temporarily unavailable) for more detail. These include:
• Business Administration (with digital skills): English communication skills for administrators and office workers (level 1-2)
• Business Administration (with digital skills): English communication skills in a business environment (level 2)
• Professional communication skills: how to make your writing clear, concise and organised (level 2)
• Professional communication skills: reading, analysing, and comparing data and text (level 2)
• Professional communication skills: effective verbal communication in the workplace (level 2)
• Professional communication skills: effective written communication in the workplace (level 2)
• Business administration: maths for administrators (level 1-2)
• Becoming data literate: how to understand the data all around you (level 1-2)
• Becoming data literate: how to present data for work or study (L2+)
• Becoming data literate: understanding data and how it is presented from pie-charts to bell curves (level 2+).

We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.