Microsoft's Excel 2016 for Windows is a very useful and powerful piece of software - but it can appear daunting if you have never used it before. Jennifer will teach you step-by-step how to create a detailed Accountancy spreadsheet which is suitable for anyone who wants to take control of their finances. She covers how to create and format Excel tables, enter data, create drop-down lists, formulas (such as IF and SUMIF Statements), use data from different tables and worksheets, absolute referencing and conditional formatting - which will get you started quickly.
By the end of this intermediate course, Jennifer gets you feeling confident about creating your a detailed Excel spreadsheet.
Lecture Objective: To set up the first month of your spreadsheet
I will show you how to: Creating a new worksheet (tab), rename the tab, create a title for the worksheet using a formula (referencing information from another worksheet)
I have been creating websites for several years now and have been using WordPress as well as Serif software. I enjoy building websites for other people as well as myself.
I achieved my BSc(Hons) in 1996, and then my Post Graduate Certificate In Education in 2001. I am also a member of the Institute for Learning.
Since qualifying I have worked in education with a spectrum of ages and abilities in colleges, the workplace and though private work.
I am a specialist in teaching English, Maths, ICT and Food Studies, both off and on-line. I also have experience in curriculum design, e-Learning and assessing.
I use technology wherever possible in my courses and I try and cater for all learning styles.I have tailored my on-line courses to promote learning using small bite-sized steps so that the learner can work at their own pace and not to be baffled by terminology, nor bored by waffle!
When selecting FREE video tutorials within each course
1. Select video
2. Hit play button
3. Go to bottom right corner of each video player and change resolution from 320 to 720HD for best viewing.