Excel for Accounting : Advanced

Activia
Aylesbury, Basingstoke, Birmingham, London, Milton Keynes, Reading, Slough, Staines, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Sorting and Filtering Data
Create a data list
Perform single and multi-level sorts
Apply a filter to a data list
Adding Charts and Pictures to a Workbook
Use the Chart Wizard to create a chart
Move and size worksheet charts
Change the chart type
Format chart elements
Change the source data for a chart
Preview and print charts
Insert, move and delete clip art and picture objects
Create and modify lines and objects
Using Named Ranges
Add and delete a named range
Use a named range in a formula
Importing and Exporting Data in Excel
Use Paste Special to import and manipulate data
Export worksheet data to other applications
Import data from a text file
Import a table from an HTML web page
Round trip HTML data in Excel
Lookup and Reference Functions
Use VLOOKUP and HLOOKUP to get values from multi-column tables
Sort values in rows or from left-to-right
Use the LOOKUP function
Prevent lookup errors
Customising Excel Toolbars
Hide and display a toolbar
Dock and float toolbars
Customise a toolbar
Create a new toolbar
Using Macros in Excel
Record a macro
Run a macro from the menu or the keyboard
Edit a macro
Assign a macro to a toolbar button or a menu
Implement macro virus file protection
Data Management
Extract data using advanced filters
Group and subtotal data using the outlining tools
Use Dfunctions for calculations on a data list
Query a database
Understand and work with a data source
Format external data
Query data from XML data sources
Pivot Table and Pivot Chart Reports
Analyze data using a Pivot Table Report
Create a Pivot Chart Report
Use Pivot Table AutoFormat
Create Pivot Table Lists for the web
Add fields to a Pivot Table using a web browser ...''

Phone:0845 230 6150

School Address:

Activia, Regus House, 268 Bath Road, Slough, Berkshire SL1 4DX


Jobs & Resumes: Aylesbury, Basingstoke, Birmingham, London, Milton Keynes, Reading, Slough, Staines
Houses & Roommates: Aylesbury, Basingstoke, Birmingham, London, Milton Keynes, Reading, Slough, Staines
Travel Agencies: Birmingham, London,

Search other schools for Excel for Accounting : Advanced training resources.

Conflict Management and Resolution
Facilitation Skills
Delegation Skills
Sage Payroll: Intermediate
Sage Payroll : Introduction
Sage Line 50 : Advanced
Sage Line 50 : Intermediate
Sage Line 50 : Introduction
Excel for Accounting : Introduction
Finance for Non-Finance Managers
Business Accounting
Budgeting
Business Finance
Financial Management: Introduction
Financial Management: Advanced
Access VBA

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.