Microsoft
Product ID: 1613406
Retail $899.98 $89.00

Electronic Software Delivery

Once order has been processed, this item is not returnable.


Student Essentials Bundle



Student Essentials Bundle

Student Essentials Bundle​ Includes:

  • Office 365 - Personal (1-year Subscription - Product Key Card)
  • Diploma in Microsoft Excel
  • Introduction to Photoshop Online Course
  • Kaspersky Internet Security - Multi-Device 5 Devices/6 Mo.

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.

Fully installed Office applications

Office 365 Personal A mouse, keyboard and monitor that is showing a screenshot of Outlook and logos of installed Office applications

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.

Install on multiple devices

Office 365 Personal Screenshots of Office applications on multiple devices, a Surface, laptop and phone

Get the full Office experience on 1 PC or Mac, 1 tablet (including Windows, iPad, and Android), and 1 phone.

Access from anywhere

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.

Always up to date

Every new upgrade is included so you'll always have the most up-to-date version as soon as it's available.

 

Office 365 Personal includes

Current versions are Office 2016 for PC and Office 2016 for Mac

 

 

 

 

 

Diploma in Microsoft Excel

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  

Course Outline:

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  

Lessons

1. Adobe Bridge

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.

2. Photoshop Walk Through

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.

3. Enhancing Images using Adjustment Layers

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.

4. Adjustment Layers continued

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.

5. Image Layers

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.

6. Selections and Retouching

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.

7. Raw Processing

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.

8. Raw Processing Part 2

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.

Frequently Asked Questions

How do I participate in the live webinars and access the recordings?

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.

Kaspersky Internet Security - Multi-Device 5 Devices/6 Mo. (Bundle Product Only)

One, simple security solution to protect your PCs, Macs and Android smartphones and tablets with award-winning technologies from Kaspersky Lab.

  • Easy, one-license protection of your connected PC, Mac, Android smartphone and tablet devices
  • Mix-and-match security to fit any combination of devices for true multi-device security
  • Customized for device protection, performance and usability
  • Real-time protection against all new and emerging Internet threats
  • Premium anti-theft/loss protection for your Android devices

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:

  • Protect your desktop, two laptops, and two smartphones.
  • Or protect two tablets, two smartphones, and a Mac.

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

Microsoft Office System Requirements:

Required Processor    

  • PC: 1 gigahertz (Ghz) or faster x86 or x64-bit processor with SSE2

Required Operating System    

  • PC: Windows 7 or later, Windows Server 2008 R2, or Windows Server 2012

Required Memory    

  • PC: 1 GB RAM (32 bit); 2 GB RAM (64 bit)

Required Hard Disk Space    

  • PC: 3.0 GB available disk space

Required Display    

  • PC: 1024x576 resolution 

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    

  • Non-commercial use. 
  • Internet functionality requires Internet connection. 
  • Microsoft account required.
  • Product functionality and graphics may vary based on your system configuration. Some features may require additional advanced hardware or server connectivity.

System Requirements for Kaspersky Internet Security - Multi-Device 5 Devices/6 Mo.:

For PC:

XP Operating System:

  • Processor: 800 MHz or higher
  • 512 MB available RAM

Vista & Windows 7 Operating Systems:

  • Processor: 1 GHz or higher
  • 1 GB available RAM (32-bit) or 2 GB available RAM (64-bit)

Windows 8

  • Processor: 1 GHz or higher
  • 1 GB RAM (32-bit) or 2 GB RAM (64-Bit)

For Mac:

Mac OS X 10.6 – 10.8

  • 1 GB RAM
  • 350 MB of available hard drive space (depending on antivirus database size)
  • Internet connection for activation and product updates

For Tablets:

  • Android 2.2 – 4.2
  • Minimum screen resolution 480*800

For Smarthphones:

  • Android 2.2 – 4.2
  • Minimum screen resolution - 320*480

System Requirements for Security Essentials Suite

  • Windows 8, Windows 7, Vista, XP (Windows Server 2003, Windows 2008 Server compatible with My Privacy Cleaner Pro, Windows 2000 compatible with PC Tune-UP)
  • Pentium or compatible system
  • 32 MB of RAM or more (For PC Tune-UP)