Complete Microsoft Excel 2016 Diploma - Beginner, Intermediate & Advanced

Gain a complete mastery of spreadsheets with this online Microsoft Excel course, with every function of the industry-standard software covered through bitesize video tutorials. Enhance your CV and gain proof of your expertise with a professional qualification covering everything from creating workbooks to advanced features such as designing formulas, implementing macros, link data across different sheets and running detailed data analysis reports.

Description

Certified by CPD Qualifications Standards and CiQ, this online distance learning course will give you a complete understanding of Microsoft Excel. Starting with basic spreadsheet skills before working through intermediary and then advanced workbook techniques, you benefit from video lessons which give real-world examples of how to apply your new knowledge. Upon successful completion, you will qualify for a professional certification as evidence of your skills.

Benefits of studying with Victoria Education include:

• Easy-to-understand course materials designed by industry experts, accessible through your smartphone, laptop, desktop or tablet device
• No hidden fees or costs - study a professional course and earn a professional e-certificate upon successful completion
• Get instant feedback from automated assessments and mock exams to gauge your progress
• No formal deadlines or teaching schedule, meaning you can learn at your own pace
• 24/7 help and support from your online tutors, through email and via our live online chat
• Qualify for an NUS Extra card and gain access to over 200 fantastic deals from high street brands and one free year of ISIC unlocking over 42,000 international discounts

Who is this course for?

Our course is aimed at anyone wishing to start working in a range of business and administration roles, or existing professionals wishing to boost their skills and employability.

Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT.

CPD

How is this qualification delivered?

Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.

The courses are delivered through

• Video lessons
• PDF handouts
• Mock exams
• Online assessment
• These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.

Course Curriculum

• Providing Administrative Support
• First Things First
• Preparation (1)
• Preparation (2)
• Time management
• The Importance of keeping to schedules
• Imperative Tasks
• Skills: Communicating Verbally
• Skills: Communicating non-Verbally
• Sanctioning yourself
• The power of teamwork
• Ensuring you are ready
• Plenary
• Personal Assistant (PA)
• First Things First
• The Manager
• Essential Skills - Administrative
• TIme Management
• Management of Meetings
• The Essential tools (1)
• The Essential tools (2)
• Powerful Gatekeeper
• Skills: Organisational
• Confidentiality
• Imperative Tasks
• Plenary
• Managing Administration
• First Things First
• The Administrative Process and its importance
• Ensure you're prepared
• Important Processes
• Our list of 5 processes
• Binder Essentials (1)
• Binder Essentials (2)
• Binder Organization
• Don't bother with these items in your process guide
• Distribute the Process guide
• Ensure high level of success when carrying out the process Guide
• Plenary
• Skills: Organisational
• First Things First
• Get rid of Things you don't need
• Arranging your work
• Time Management
• Managing your list of things to do
• The differences between virtual storage and physical storage
• Standardize your work area
• How not to procrastinate
• Managing your inbox
• Avoid Not Organizing
• Stay Focussed to keep Organized
• Plenary
• Developing Self-Esteem & Confidence
• First Things First
• The meaning of Self-Confidence
• Bumps in the Road
• Skills: Communication
• Establishing Targets
• It's a feeling
• It's also a Look
• And, of course, a sound
• The best Presentations
• Manage yourself
• Managing Problematic Misbehavour
• Plenary
• Writing for Business
• First Things First
• Word Management
• Plenary
• Developing Sentences
• Paragraph Development
• Agenda Schedules
• E-mails
• Letters for Business
• Proposals for Business
• Reports for Business
• Various Documents
• Ensuring Proofread for final Product
• Software: Microsoft Excel
• First Things First
• Excel Essentials
• The User Interface
• Starting a worksheet
• Reviewing your Data
• Constructing Formulas
• Utilising Functions in Excel
• Quick Analysis Essentials
• Data Formatting
• Styles, Themes and Effects Essentials
• Print & Share the workbook
• Plenary
• Software: Microsoft Word
• First Things First
• Word Essentials
• The User Interface
• Starting a Document
• Essential Editing
• Essential Formatting
• Paragraph Formatting
• Formatting - Advanced
• Styles Essentials
• Page Formatting
• Share the Word Document
• Plenary
• Software: Microsoft PowerPoint
• First Things First
• PowerPoint Essentials
• The User Interface
• Starting a Presentation
• Text Building Essentials
• Text Formatting & Paragraphs essentials
• Inserting Graphics such as pictures
• Formatting Tasks - Advanced
• Animations & Transitions Essentials
• Slide Show Preparation
• It's Time to Present
• Plenary

Mandatory units

The Admin, Secretarial and PA Diploma Level 3 course consists of nine mandatory modules

• Admin Support
• Administrative Management
• Organisational Skills
• Personal Assistant Skills
• Business Writing
• Self Esteem and Confidence Building
• Microsoft Word
• Microsoft Powerpoint
• Microsoft Excel
• Video lessons
• Mock exams
• Online assessment
• These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.

Course Curriculum

• Essentials of Mirosoft Excel 2016
• Getting around the Excel Interface
• Essentials: Commands
• Basics: Create and Save
• F1: Help function
• Basics: Input Data
• How to perform calculations
• Essentials: Formulas
• Essentials: Functions
• Repeat the Formula or Function
• How to amend a worksheet
• Essentials: Insert, Delete, Adjust
• Essentials: Search Function
• Essentials: Proof Functions
• How to format a worksheet
• Essentials: Format for text
• Essentials Format for numbers
• Adjusting Contents
• Essentials: Styles
• Essentials: Conditional Formatting
• Template Developer
• Printing the entire workbook
• Essentials: Print
• Essentials: Page Layout
• Essentials: Headers and Footers
• Managing entire workbooks
• Worksheet Management
• Workbook and Worksheet Viewer
• Essentials: Adjusting the settings of Workbook
• Managing functions
• Essentials: Ranges Function
• Essentials: Specialized Functions
• Logical Functions
• Do you know the Date & Time functions?
• Text Function Essentials
• Managing lists
• Data Sorting
• Data Filtering
• Essentials Query
• Data Review
• Data analysis
• Table Creation
• Intermediate Level: Conditional Formatting
• Advanced Level: Conditional Fotmatting
• Envisaging Data with Chart tools.
• Chart Creation
• Modification of Charts
• AdvancedL Charts
• Essentials of PivotTables and PivotCharts
• PivotTable Essentials
• Analysis of Data
• Showing off your findings
• Slicer and Timelines Tools
• Management of several worksheets and workbooks
• Connections to external source
• Graphic References
• Check Data
• Utiising advanced functions: Lookup and formula auditing
• Essentials: Lookup
• Essentials: Tracing of cells
• Review Formulas
• How to share and protect workbooks
• Share your workbook
• Data Protection
• Managing the automation of workbooks
• Regulate the Data
• Error Checking
• Essentials Macros
• Utilising advanced functions: Sparklines and Data Mapping
• Sparklines Essentials
• MapData
• Estimation of Data
• Predicting results with Data Tables
• Predicting results with Scenarios
• Use the Goal Seek Feature
• Essentials Goal Seek

Mandatory units

The course consists of 17 mandatory modules, covering

• Identifying the elements of the Excel interface
• Developing formulas and inserting functions
• Using subtotal and database functions to calculate data
• Creating sparklines and mapping data
• Determining potential outcomes using data tables
• And more...

Assessment

The assessment at the end of each course is a multiple-choice exam taken through our online platform. The system is fully automated so you will receive your results instantly upon completion.

Certification

Upon successful completion you will qualify for the UK and internationally-recognised professional qualification. You can order a print copy sent by post for GBP12.

Victoria Education is a leading provider of online training, practical courses and professional accreditation.

Our mission is to make learning accessible, affordable, and available to all, regardless of experience or qualifications.