Business administration: ICT skills for business (advanced)

Course Dates: 09/03/23 - 31/03/23
Time: 18:30 - 21:30
Location: Online
Are you already a competent administrator with the fundamental digital skills required to do the job successfully? Are you now ready to develop more advanced skills so you can become more efficient and productive and advance in your career? This course will help you learn how to use more complex functions in Excel so you can handle and analyse data precisely as well as provide bigger picture analyses. You will also focus on how to use the more sophisticated elements of PowerPoint to produce high quality presentations which meet the demands of the modern workplace. In addition, you will become familiar with key aspects of financial functions. By the end of the course you will have the skills to set you apart from other administrators and become an invaluable member of any team.
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
This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
Download
Book your place
Out of stock
SKU
196609
Full fee £149.00 Senior fee £119.00 Concession £75.00

This course has now finished

Course Code: CA04

Finished Thu-Fri, eve, 09 Mar - 31 Mar '23

Duration: 8 sessions (over 4 weeks)

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?

This course will enable you to develop the digital skills needed to be a highly competent lead administrator. You will focus on skills needed to handle, analyse and present data using financial calculation and charts in Excel use organisational flow charts in PowerPoint. You will work on how to identify trends, draw conclusions, create summaries and highlight specific features of the data. Within PowerPoint you will work on how best to present this data and work on features such as slide master templates, using formatting techniques such as animation and transitioning to draw attention to key points, plus different printout options.

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?

• using Excel for business functions to enable accurate data processing and analysis
• entering and editing data accurately and efficiently
• applying formulas and functions to make accurate calculations including AVERAGE, SUM/SUM IF, COUNT/ COUNTIF, VLOOKUP
• analysing data to identify trends, draw conclusions and create a summary
• formatting and presenting data to meet business needs via sorting, filtering, charts and graphs, pivot tables
• processing of Budget sheet
• maintaining accurate records of customers and suppliers by exporting/importing from Excel to Microsoft Access .
• keeping accurate and detailed financial records using Data Validation.
• creating business appropriate presentations
• use organisational flow charts in PowerPoint
• using slide master templates
• using effective formatting technique such as animations, transitions and timings
• using printing options effectively.

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

• use Excel for business functions to enable accurate data processing and analysis
• enter and edit data accurately and efficiently
• apply formulas and functions to make accurate calculations including AVERAGE, SUM/SUM IF, COUNT/COUNTIF, VLOOKUP
• analyse data to identify trends, draw conclusion and create a summary
• format and present data to meet business needs via sorting, filtering, charts and graphs, pivot tables
• processing of Budget sheet successfully
• maintaining accurate records of customers and suppliers by exporting/importing from Excel to Microsoft Access .
• keeping accurate and detailed financial records using Data Validation.
• create business appropriate presentations
• use organisational flow charts in PowerPoint
• use master templates
• use effective formatting technique such as animations, transitions and timings
• use printing options effectively.

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

This course is for those who are working or have worked in an administrative capacity who want to develop their skills and reflect on how to develop them.

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 file 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, at the same time or after this course. These include:
• Level 3 certificate in IT user skills (ICDL 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
• Business skills: how to collaborate using OneDrive and SharePoint (intermediate)
• Business skills: how to collaborate with Microsoft Teams (intermediate)
• Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for the workplace: how to present, organise and communicate with Word (intermediate)
• Digital skills for the workplace: creating newsletters, reports and tables with Word (intermediate)
• Digital skills for the workplace: how to integrate Word, Excel and PowerPoint to organise, present and communicate data (advanced)

• There also many maths, 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 in a business environment (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)
• Professional communication skills: business writing from memos to storytelling (level 2
• Business administration: maths for administrators (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.