Skip Main Navigation
Page Content

Save This Event

Event Saved

Self-Study Online Microsoft Excel 'Expert' Course

Aspira Training

Self-Study Online Microsoft Excel 'Expert' Course

Ticket Information

Ticket Type Price Fee Quantity
Self-Study Online Microsoft Excel 'Expert' Course £129.00 £3.88

Who's Going

Loading your connections...

Share Self-Study Online Microsoft Excel 'Expert' Course

Event Details

Protection and Sharing

·         Protecting and Current Sheet
·        Allowing Edits to Ranges
·         Protecting the Workbook Structure
·         Restricting Permissions
·         Permission Levels
·         Additional Permission Options
·         Requiring passwords to open a workbook

Maintain Shared Workbooks

·         Sharing Workbooks
·         Disabled Features While Sharing
·         How to merge Workbooks
·         Tracking Changes
·         Viewing and Reviewing Tracked Changes

Audit Formulas

·         Formula Tracing
·         Locating Invalid Data and Formulas
·         Correcting Errors in Formulas

Manipulate Formula Options

·         Setting interactive calculation options
·         Automatic Workbook Calculation

Data Summary Tasks

·         Using an array formula
·         Restrictions using an array
·         Array functions and formulas
·         Array Constants
·         Using Array constants
·         Using the SUMIF & SUMIFS functions

Functions in Formulas

·         Error Messages
·         Avoiding Errors in Functions
·         Using Various Functions

Advanced Chart Features

·         Trend Lines
·         Applying Trend lines
·         Formatting Trend lines
·         Applying Dual Axes
·         Chart Templates
·         Applying Sparkline’s

Data Analysis

·         Using Automated Analysis Tools
·         Descriptive Statistics
·         Histograms
·         Rank And Percentile
·         Random Number Generation
·         Sampling Data
·         Performing a What-if Analysis
·         Data Tables
·         Creating a one Variable Data Table
·         Creating a two Variable Data Table
·         Scenario manager
·         Managing and Merging Scenarios
·         Goal Seek
·         Configuring Goal Seek
·         Solver
·         Using Solver

Pivot Table

·         Creating a Pivot Table
·         Manipulating Pivot Table Data
·         Pivot Table Design
·         Using the Slicer on Pivot Table Data

Pivot Charts

·         Creating and Manipulating Pivot Charts
·         Pivot Chart Options
·         Layout and Format

External Data

·         Connecting to External Data
·         Connecting to Microsoft Access
·         Connecting to a Website
·         Connecting to a Text File
·         Connecting to an MS SQL Database
·         Using Existing Connections
·         Editing External Workbook Links

Macros and Forms

·         Macros
·         Recording a Macro
·         Running a Macro
·         When a Workbook is Opened
·         When a button is Clicked
·         Recording and Action Macro
·         Modifying a Macro
·         Forms
·         Available Form Controls

Do you have questions about Self-Study Online Microsoft Excel 'Expert' Course? Contact Aspira Training

Save This Event

Event Saved

Organiser

Aspira Training

Aspira Training is part of the Aspira Executive PA search consultancy based in London. 

Aspira Training is dedicated to providing training for personal assistants and support staff within the financial and investment sector. Our aim is to equip our delegates with the necessary knowledge and skills to become indespensible business assets within their organisation. 

We provide a range of courses tailored to each deleagte's needs to ensure that they leave with the ability to excel in their current role and deliver exceptional results. We work with industry experienced trainers, who deliver comprehensive and up-to-date courses relevant to current market trends.

 

 


  Contact the Organiser
Self-Study Online Microsoft Excel 'Expert' Course
Course Auto, Boat & Air

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.