How to Quickly Excel in the Basics of Excel
What you'll learn
- Confidently use basic functions and calculations in Excel.
- Successfully create professional looking and effective Excel spreadsheets from scratch.
- Create eye-catching charts and graphs to better visually represent your spreadsheet data.
- Be familiar with Excel spreadsheet terminology, layout and formatting.
Requirements
- Students will need a working copy of Microsoft Excel 2013 software (although Excel 2010 will also work just fine).
- No prior knowledge is required to commence this course. Just the desire to improve your own skills.
Description
*** All videos are under 5 minutes in duration and are straight to the point to help maintain your concentration ***
This course in Excel 2013 will allow a novice user to quickly become a confident spreadsheet user. Highly practical, you can be applying your new skills within minutes of learning a concept.
Having taught IT for over 20 years I've identified the key aspects and you will benefit from my experience. You will find my videos straight to the point and that I explain all concepts in simple terms rather than getting too technical or using IT jargon. Wherever possible I provide practical examples to demonstrate where the concept being explored can be applied. I have taught these concepts to 1000s of students during my career and now would like to give you the opportunity to also learn some new, valuable and employable workplace skills
The course consists of a brief overview of each concept and short, sharp videos covering the key points for all topics. Additionally, there is a practical, self-marked activity for you to complete and three videos showing me completing the task should you encounter difficulties.
Major topics include:
- Basics of Excel 2013 - simple arithmetics, formatting, shortcuts and tricks of the trade.
- Additional features to better utilise the power of Excel - absolute referencing and using cells in multiple ways.
- Using Common Formulas - sum, average, if, lookup, rank, countif, plus some more advanced functions available to assist you to create professional, efficient spreadsheets.
- A Challenge Activity - self-marked series of examples to try your new skills. Videos of solutions to all activities are also provided.
- Adding Charts / Graphs to improve the visual effectiveness of highlighting your information.
- Some additional concepts to further develop your spreadsheeting skills including using conditional formatting, generating random numbers and probability.
I look forward to assisting you in becoming a confident user of Excel 2013.
Who this course is for:
- Anyone from complete beginners to those who have done some work with spreadsheets so they can expand their skills.
- People who want to add these critical IT skills to their computing expertise. Spreadsheets are used in most professions in some form and are highly desirable to employers.
- As it is an introductory course, not recommended for those with a thorough knowledge of speadsheets.
Instructor
Hi, I'm Paul and I've been a full time teacher of Information Technology (IT) for 27 years. I am the Head of Digital Technologies at my secondary school and have a Bachelor of Information Technology and a Master of Educational Leadership specialising in IT.
I am a Google Certified Trainer and have completed the Google Certified Education Level 1 & 2 qualifications so you know that my courses are well developed and include all aspects of the software. Additional to my Google qualifications, I am also a Microsoft Innovative Educator Expert (MIEE).
I deliver real-world, highly practical courses drawn from my experience of having taught thousands of students over the last 24 years of teaching. I cut through the jargon emphasising the key points and tell you what you need to know as quickly as possible while not missing any critical skills.
I gain great pleasure teaching people how to better utilise technology in their life and work environment. The tools and skills explored in my courses are applicable in any workplace or for those just looking to improve their own IT skills.
I look forward to working with you as you develop into a more confident IT user. Enjoy.