For QR29 Master Basic & Advanced Microsoft Excel Skills with an Online Diploma Course! (QR2432 Value)

Excel at Excel!

So your CV says you’re a master at Excel but we know the truth… you don’t know all the ins and outs of Excel just yet, but you will! After this course, of course! It’s a small price to pay to learn one of the most used but complicated programs NEEDED to do your job well!

*Course Modules:*

*Lesson 1*

• 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

*Lesson 2*

• 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

*Lesson 3*

• 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

*Lesson 4*

• Performing Simple Calculations
• Introducing formulae
• Totaling columns and rows
• Calculating with formulae
• Calculating averages
• Find the highest & lowest values
• Understanding cell referencing
• Using explicit values in formulae

*Lesson 5*

• 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

*Lesson 6*

• 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

*Lesson 7*

• Managing Workbooks
• Switching between worksheets
• Renaming worksheets
• Moving and copying worksheets
• Inserting and deleting worksheets
• Referencing external data

*Lesson 8*

• 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

*Lesson 9*

• More Functions and Formulae
• Naming cells and ranges
• Common worksheet errors
• Displaying and printing formulae
• Using the COUNT function 5
• Using the IF function

*Lesson 10*

• Automating Your Work with Macros
• Recording a macro
• Replaying a macro

*Lesson 11*

• Importing Data
• Importing from text files
• Importing from Microsoft Access

*Lesson 12*

• Working with Tables
• Sorting a table of records
• Filtering a table of records
• Subtotaling a table of records

*Lesson 13*

• 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

*Lesson 14*

• 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

*Lesson 15*

• Using the Research Tool
• Using the Thesaurus to find synonyms
• Using research services

*Lesson 16*

• 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

*Lesson 17*

• Importing Data into Excel
• Importing from an external data source
• Using a database query
• Importing data from a Web page

*Lesson 18*

• Advanced Working with Tables
• Creating an modifying a table
• Using data forms to manage tables
• Using advanced filters
• Using subtotals
• Grouping and outlining data
• Using data validation
• Circling invalid data

*Lesson 19*

• Analyzing Data with Automated Tools
• Using the Analysis ToolPak
• Using Goal Seek
• Using a data table
• Using the Solver

*Lesson 20*

• Analyzing Data with Scenarios
• Creating and showing scenarios
• Merging scenarios
• Creating a scenario report

*Lesson 21*

• Using PivotTables and PivotCharts
• Creating a PivotTable report
• Specifying the data to analyse
• Modifying a PivotTable report
• Updating a PivotTable
• Grouping dates in a PivotTable
• Using the Report Filter area
• Drilling down to the detail
• Changing the type of calculation
• Filtering in a PivotTable
• Grouping data in a PivotTable
• Sorting PivotTables
• Formatting a PivotTable
• Charting a PivotTable

*Lesson 22*

• Analyzing Data with Functions
• Using the Lookup functions
• Using the Conditional Sum Wizard
• Using Database functions

*Lesson 23*

• Protecting Cells, Sheets, and Books
• Protecting cells
• Protecting worksheets
• Protecting workbooks
• Attaching and viewing digital signatures
• Adjusting macro settings

*Lesson 24*

• Collaborating with Others
• Creating a shared workbook Viewing and removing users
• Resolving conflicting changes
• Viewing the change history
• Comparing and merging workbooks
• Tracking changes to a workbook
• Accepting and rejecting changes
• Removing workbook sharing

*Lesson 25*

• Managing Data and Workbooks
• Publishing workbooks as Web pages
• Creating a workbook template
• Editing a workbook template
• Consolidating worksheets
• Hiding columns, rows, sheets, and books
• Saving a custom view
• Viewing and changing workbook properties

Assessment is continuous and you will receive an assignment at the end of the program. Assignments will be a mix of both written and practical work. The entire program is 10 hours in duration, with each module taking approximately 30mins to complete. The course is delivered “on demand” which means that you can learn at your own pace!

 

*NOTE:* This course is independently accredited by an internationally recognized body for CPD purposes. The CPD Certification Service also accredits this course, which is an independent body that ensures qualifications are in line with the most current professional standards.

 

The Shaw Academy is a professional training and higher education institution dedicated to making the highest quality, practical education accessible to all. They are committed to both excellence in teaching and support, enhancing the learning experience of each individual student. They provide cutting edge education, offering highly innovate topics, administered in a flexible nature.

 

 

*Microsoft Excel Online Diploma Course*
Pay QR29 instead of QR2432

• Better understand all aspects of the sometimes daunting Microsoft Excel program!
• Learn knowledge that’s most often crucially required for gaining employment!
• Explore everything from basic level Excel all the way to the most advanced charts, graphs, etc.!
• Receive course materials in smaller parts to divide up the massive amount of information better for practical convenience!
• Includes interactive downloadable workborks to ensure all points are grasped before moving on!
• Presented by highly qualified instructors with decades of professional experience!
• Join over 6,000 graduates who’ve loved and praised this course!
• 180 course topics covered in video-formats, making this the most comprehensive Excel program available!
• Suitable for first time Excel users to self-proclaimed Excel masters!
• Learn at your own pace with 24/7 access to recording of live sessions and weekly assessments to test your knowledge!
• Full support throughout and upon completion of course!
• Certificate and accredited diploma provided upon completion!

• Valid from 18 May 2015 - 18 Aug. 2015
• Redemption period: 3 months from deal's start date
• Limit 1 voucher per person
• May buy multiple vouchers as gifts
• Live sessions suitable for mobile devices
• Vouchers not redeemed by 18 Aug. 2015 will NOT be refunded
• Successful completion of the online course is required to gain officially certified recognized qualifications
• For more information visit: http://www.shawacademy.com/excel/voucher-redemption.php
• Internet access and audio required
• Not valid with other offers
• No cash value/No cash back/No refunds

 

*How to Redeem:*

To activate your voucher and assign your course:

1. Visit: http://www.shawacademy.com/excel/voucher-redemption.php before 18 Aug. 2015
2. Fill in the required fields with your information and Qgrabs Voucher Code
3. Select password and enter persoanl information
4. Receive automatic email confirmation

 

Please see the terms for all deals here