Student Essentials Bundle Includes:
Why Office
Great for 1 PC or Mac, and 1 tablet, Office 365 Personal helps you get things done from virtually anywhere, on all your devices. And it’s always up to date, so you’ll never have to worry about getting stuck with old versions.
Get the all-new 2016 versions of Word, Excel, PowerPoint, OneNote, Outlook, and more, downloaded directly to your favorite devices. You can keep working even if you’re not online.
Get the full Office experience on 1 PC or Mac, 1 tablet (including Windows, iPad, and Android), and 1 phone.
Use OneDrive cloud storage to get instant access to your documents, photos, and videos. Edit and share them online anytime, anywhere, on all your devices.
Every new upgrade is included so you'll always have the most up-to-date version as soon as it's available.
Current versions are Office 2016 for PC and Office 2016 for Mac
Create, polish, and share beautiful documents.
Analyze and visualize your data in new and intuitive ways.
Create, collaborate, and effectively present your ideas.
Harness your thoughts in your very own digital notebook.
Organize email, coordinate schedules, and stay up to date with contacts.
Create your own custom database apps fast, and harness the power of your data.
PC only
Print and share professional-looking publications with powerful, easy-to-use tools.
PC only
Get 1TB OneDrive cloud storage for all your stuff.
Call mobile and landline phones with 60 monthly Skype minutes.
From basic Excel to advanced functions
Microsoft Excel can be incredibly powerful in the right hands however often it is more than a little daunting. Knowledge of Microsoft Excel is often crucially required for gaining employment and most roles require a working knowledge. The purpose of this course is to bring the student on a journey from basic level Excel use all the way through the most advanced charts, graphs, look ups and much much more.
Your Tailored Online Diploma in Microsoft Excel
The beauty here is the way the content is presented, in bite size chunks, which can be looked up at ease, almost like a video dictionary for Excel – practical convenience.
Interactive downloadable workbooks ensure all points are grasped in real time.
We feel that there is no other qualification currently available which will provide the depth of knowledge that the Shaw Academy will bring to the subject. This, coupled with our unrivalled student support, ensures that this learning experience will be second to none
Your purchase now also includes a Free Starter Pack tailored to your course when you register and attend the first Live Webinar
Module 1:
What is Excel? How to open and close Excel and a basic overview of Spreadsheet software.
Topics covered in this module include:
• Introducing Microsoft Excel
• Starting Microsoft Excel
• Understanding spreadsheets
• Understanding the Excel window
• Understanding the workbook window
• Using the Ribbon
• Using the Quick Access Toolbar
• Getting help on Microsoft Excel
• Exiting Microsoft Excel
• Exercise / Solutions
• Summary
Module 2:
What are Workbooks and Worksheets? How they work and what they assist with.
Topics covered in this module include:
• Creating and Saving Workbooks
• Creating a new workbook
• Saving a workbook
• Auto-saving your work
• Closing a workbook
• Opening a workbook
• Moving the cell pointer
• Moving around a worksheet
• Entering text 5 Entering numbers
• Entering dates and times
• Using the Zoom tool
• Exercise / Solutions
• Summary
Module 3:
How to alter Workbooks and make changes to the data held within them.
Topics covered in this module include:
• Editing Workbooks
• Selecting ranges of cells
• Editing cell contents
• Clearing cell contents
• Copying cell contents
• Moving cell contents
• Inserting and deleting cells
• Inserting columns and rows
• Deleting columns and rows
• Copying cells with AutoFill
• Inserting cell comments
• Checking your spelling
• Finding and replacing data
• Exercise / Solutions
• Summary
Module 4:
How to perform and generate different basic calculations upon data within Workbooks.
Topics covered in this module include:
• Performing Simple Calculations
• Introducing formulae
• Totalling columns and rows
• Calculating with formulae
• Calculating averages
• Find the highest & lowest values
• Understanding cell referencing
• Using explicit values in formulae
• Exercise / Solutions
• Summary
Module 5:
Changing the format of Worksheets by editing Fonts, Colours and other factors.
Topics covered in this module include:
• Formatting Worksheets
• Formatting with font and colour
• Formatting numbers
• Formatting dates and times
• Copying and pasting formatting
• Adjusting column widths and row heights
• Aligning cell contents
• Indenting and rotating cell contents
• Merging cells
• Adding borders, colour and shading
• Using styles
• Using document themes
• Exercise / Solutions
• Summary
Module 6:
Printing Worksheets and changing options to find the most efficient print formats.
Topics covered in this module include:
• Previewing and Printing Worksheets
• Previewing the worksheet
• Preparing pages for printing
• Creating headers and footers
• Specifying the print area and titles
• Controlling page breaks
• Printing a worksheet
• Exercise / Solutions
• Summary
Module 7:
How to manage a multitude of similar or related Workbooks to make storing and saving more effective.
Topics covered in this module include:
• Managing Workbooks
• Switching between worksheets
• Renaming worksheets
• Moving and copying worksheets
• Inserting and deleting worksheets
• Referencing external data
• Exercise / Solutions
• Summary
Module 8:
Using data stored in Workbooks and Worksheets to generate a wide array of charts to view data more efficiently.
Topics covered in this module include:
• Creating Charts
• Creating new charts
• Moving and resizing charts
• Using predefined layouts and styles
• Selecting and changing chart elements
• Changing the chart type
• Adding another data series
• Naming data series
• Formatting and aligning titles
• Controlling gridlines
• Controlling axes
• Adding borders and colour
• Working with 3-D charts
• Updating the data series
• Previewing and printing charts
• Exercise / Solutions
• Summary
Module 9:
A more complex look at the variety of available functions and formulae.
Topics covered in this module include:
• More Functions and Formulae
• Naming cells and ranges
• Common worksheet errors
• Displaying and printing formulae
• Using the COUNT function 5
• Using the IF function
• Exercise / Solutions
• Summary
Module 10:
How to generate and run Macros to make workflow more quickly and smoothly.
Topics covered in this module include:
• Automating Your Work with Macros
• Recording a macro
• Replaying a macro
• Exercise / Solutions
• Summary
Module 11:
Using Data from a variety of external sources and how to effectively import it into Excel.
Topics covered in this module include:
• Importing Data
• Importing from text files
• Importing from Microsoft Access
• Exercise / Solutions
• Summary
Module 12:
How to generate tables and use the versatile range of options to filter and view the data.
Topics covered in this module include:
• Working with Tables
• Sorting a table of records
• Filtering a table of records
• Subtotalling a table of records
• Exercise / Solutions
• Summary
Module 13:
Viewing data within a Workbook more efficiently by changing the format and additional formatting options.
Topics covered in this module include:
• Creating and Formatting Data
• Combining cell contents
• Using conditional formatting
• Creating a custom number format
• Creating a custom date format
• Creating and applying a style
• Exercise / Solutions
• Summary
Module 14:
Adding external or internal content to enhance Workbooks.
Topics covered in this module include:
• Creating and Formatting Content
• Inserting clip art
• Inserting graphics
• Moving graphics
• Resizing graphics
• Formatting graphics
• Creating and modifying diagrams
• Moving and resizing diagrams
• Formatting diagrams
• Annotating a chart
• Filling data series with pictures
• Changing the chart type
• Manipulating pie charts
• Selecting and saving a chart template
• Exercise / Solutions
• Summary
Module 15:
Using the Thesaurus and Research options to highlight and correctly collate external sources.
Topics covered in this module include:
• Using the Research Tool
• Using the Thesaurus to find synonyms
• Using research services
• Exercise / Solutions
• Summary
Module 16:
How to set Validation to ensure that errors are not introduced into a Workbook.
Topics covered in this module include:
• Validating Data
• Using totals as visual checks
• Using formulae for automatic checks
• Using the Range Finder
• Auditing a worksheet
• Using error checking
• Watching and evaluating formulae
• Exercise / Solutions
• Summary
Learn to master the skills of image editing and take your images to a new level.
Image editing is an essential and integral part of Digital Photography and essential to expand your creative abilities as a photographer, whatever level you are at.
Whether you are a landscape photographer who wants to enhance the colours and vibrancy in your images, or a portrait photographer wanting to cosmetically retouch a shot, a knowledge in Photoshop will equip you with the skills to carry out editing and enhancements to really take your images to a new level. A firm understand of the power of post-production and image editing will open up a whole new world of creative tools and techniques.
The course aims to equip you with the skills and knowledge to enhance and retouch images at a professional standard and add another layer to your skill set as a photographer.
Your purchase now also includes a Free Starter Pack tailored to your course when you register and attend the first Live Webinar
Lesson 1 looks at Photoshop’s powerful file management system, Adobe Bridge. Every year we shoot thousands of images and an efficient way to sort, organize and find your images is an essential part of your photography skill set. We will look how to utilize some of Bridges features such as labelling, rating and key wording which will allow you to create a workflow where you can find images in a matter of seconds.
Lesson 2 takes you around the Photoshop interface to familiarize you with this image editing power house. We will also look at some image editing fundamentals such as image size, resolution and file formats. This essential knowledge will give you an insight into the quality of the images you are working with and the possibilities for resizing.
Lesson 3 introduces you to one of the most important functions of Photoshop, Layers. Adjustment layers allow you to repair and enhance images in a non-destructive and continuously re-editable manner. We look at the basic principles and concepts of using layers and begin to dig into the core adjustments that will help give your images new life.
Lesson 4 continues our exploration of the core adjustment options offered by Photoshop and will give you an insight into how each one works, and when and where to apply them. A firm understanding of how these strong adjustments work, will allow you to enhance your images and give them a new creative edge.
Photoshop is renowned for its ability to put multiple images together, cut someone or something out of a background and drop them in another picture, or simply remove an unwanted object seamlessly. To begin to develop these hugely creative and practical skills, you need to understand image layers and selections. Lesson 5 introduces you to working with layers and basic selection tools, so that you can begin to understand the true potential of Photoshop.
Lesson 6 takes the subject of selections a step further. We look at some of more complex selection tools and how to refine these selections to make seamless adjustments and cut-outs. We will also look at how selections and layers work together with some of Photoshop’s retouching tools to begin to develop your retouching skills.
Shooting in the raw format will ensure you fully utilize your cameras potential and allow for much more control over your images during the editing process. When you shoot raw you add a raw processing stage to your workflow to take full control over your images. Adobe Camera Raw, which is built into Photoshop, is one of the most important processers available. Lesson 7 introduces you to the Adobe camera Raw platform and digs into some of its essential editing tools.
Lesson 8 digs even further into the incredibly sophisticated Adobe Camera Raw utility and explores more of its repair, enhancement and retouching tools. We also look at amazing batch processing features which allow you to edit and enhance 100’s of images at once without having to edit each one individually. Developing this skill set is invaluable and will save you hours upon hours of editing time.
*On demand lessons will be pre-recorded and will be made available at a later date.
You can participate using your own computer via the internet, both Windows and Mac devices will surfice.
You can access recordings via your student log in area found in menu tab.
Live lessons are not essential in order to pass diploma courses. You can view the recordings in your own time.
What is the duration of one webinar?
It lasts approximately 1 hour, not including questions and answers at the end of the live sessions.
What if I miss the lecture? Will I be able to catch up?
That's no problem. We also record each lecture as we broadcast them. We make these videos available to you within 24 hours of each lecture concluding and you will have unlimited access to the videos for up to 12 days after the entire course has been completed.
Are there any assignments?
We provide you with weekly quizzes in order to self-assess your progress. These are completely voluntary and a fantastic revision tool. Only live courses have weekly quizzes.
Upon course completion a final assignment will be made available. There is a €5 administration charge for non-members to complete the final assignment and receive the certificate. All certificates are free for members.
One, simple security solution to protect your PCs, Macs and Android smartphones and tablets with award-winning technologies from Kaspersky Lab.
Kaspersky Internet Security – Multi-Device provides award-winning security that’s customized to your everyday devices. Whether you connect with a PC, Mac, Android tablet or smartphone, our advanced real-time technology gives you an easy, worry-free experience that moves as fast as the web can take you.
See what’s inside Kaspersky Internet Security – Multi-Device:
Easy, one-license protection of your connected devices
With just one license you can easily set up protection on any of your devices - PCs, Macs, or Android tablets and smartphones.
Mix-and-match security to fit your needs
Conveniently secure any combination of your PCs, Macs, and Android tablets and smartphones – up to 5. For example:
You can also move your protection from one device to another.
Customized for device protection, performance and usability
Get customized, optimal protection, performance and usability for each of your devices. Our security won’t slow down your devices while giving you the freedom to enjoy the Internet to its full potential.
Real-time protection against all Internet threats
Whatever device you’re using, you’ll get immediate scanning of all applications and files that you open, save or download from the web. Potential threats are monitored and analyzed in real-time and dangerous actions are prevented before they can cause harm.
Premium anti-theft protection
If your Android smartphone or tablet is lost or stolen, you can remotely block, wipe and find your missing device
Required Processor
Required Operating System
Required Memory
Required Hard Disk Space
Required Display
Graphics: Graphics hardware acceleration requires DirectX 10 graphics card
Multi-touch: A touch-enabled device is required to use any multi-touch functionality. However, all features and functionality are always available by using a keyboard, mouse, or other standard or accessible input device. Note that the new touch features are optimized for use with Windows 8 or later.
Additional System Requirements
For PC:
XP Operating System:
Vista & Windows 7 Operating Systems:
Windows 8
For Mac:
Mac OS X 10.6 – 10.8
For Tablets:
For Smarthphones:
System Requirements for Security Essentials Suite
