Digital Skills in the workplace: Intermediate Excel (Level 1 to Level 2)
Course Title: Digital Skills in the workplace: Intermediate Excel (Level 1 to Level 2)
Brief course description: Take your Excel skills to the next level with this intermediate course. Focused on data analysis, complex formulas, and advanced charting techniques, this course will help you handle more sophisticated tasks in the workplace. Perfect for those looking to deepen their Excel expertise.
Objectives:
- Apply intermediate formulas such as VLOOKUP and IF to perform more complex calculations.
- Analyze data using PivotTables and PivotCharts for better insights.
- Create advanced charts and graphs to visually represent data trends.
- Use conditional formatting to highlight key data points automatically.
- Link data across multiple worksheets and workbooks for better organization and analysis.
Entry requirements:
You will need to be able to show digital skills working towards the required level (Level 1+) at assessment.
Equipment required :
Please bring to every lesson:
- A folder
- Pens & pencils
- Lined A4 paper
- A smartphone (if you have one)
- A reusable water bottle
We will give you the WIFI details in the first lesson.
If you do not have access to a smart phone or a computer at home, speak to your tutor.
What courses can I go on to:
- Preparation for your Essential Digital Skills Level 1 Qualification
- Essential Digital Skills Level 1
- Functional Skills English Level 1/2
- Functional Skills Maths Level 1/2
- ESOL Level 1/2
- Digital Skills in the workplace: Using Excel, Word, Outlook, Powerpoint - Intermediate Level 1
- Digital Skills in the workplace: Using Excel, Word, Outlook, Powerpoint - High Intermediate Level 2
- Digital Skills in the workplace: Promoting and Selling your product or business online
What examination is there:
There is no examination for this course. You will agree learning goals with your tutor which you must achieve by the end of the course.
How will I know I am making progress:
At the start of the course, your tutor will talk with you about which of your digital skills you need to practise most and help you create an individual learning plan. Throughout the course, you will have a tutorial meeting to discuss your strengths, areas for improvement, and any problems you may have. You will keep a folder with your work, which will help you review your learning outside of class. Your tutor will give you regular feedback on your class work and homework to help you improve. To make progress, you need to attend all your classes and do work outside of class.
Other info:
One of our aims is to help you make progress in work or future studies. We also want to help you participate in your communities and become an active citizen. In our classes, you will develop important skills that employers value and that will help you in everyday life. Here’s what you will learn:
Communication Skills: You will learn to speak and write more clearly and confidently. This includes practising conversations for work, writing emails, and filling out forms.
Decision-Making: You will learn how to make good choices by evaluating different options and thinking critically about situations.
Teamwork: You will learn how to work well with others.
Problem-Solving: You will develop the ability to identify problems and find effective solutions, useful in both work and daily life.
Time Management: You will practice managing your time effectively, including setting goals and meeting deadlines.
By improving these skills, you will increase your chances of finding a job, advancing in your career, and becoming an active member of your community.
Extra support
We can help you if you tell us you have a learning difficulty, disability or other support needs. Please tell us when you enrol or in your first class.