Back to Courses

Microsoft Excel 2013 Advanced (Level 3)

ENDED

Short Course by Aspyra Training

Enquire Now

On-Site / Short Course

GBP 199.99

Enquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Enquire

Details

This Microsoft Excel 2013 Advanced (Level 3) course is designed for Microsoft Excel 2013 spreadsheets users who want to maximise the full use of the software. You will extend the knowledge and skills you acquired from the Intermediate (Level 2) course or previous knowledge and experience acquired from elsewhere. You will learn how to use the Advanced Features of Microsoft Excel through engaging in a range of activities associated with protecting worksheet data, performing advanced data operations, data considerations, filters and advanced Pivot Table techniques, macros, and much more.

This is a direct delivery course, offering you with interactive training in a small classroom setting. Packed with exercises and hands-on experiences, this course enables you to apply what you have learnt back in the workplace and professionally.

Outline

This Microsoft Excel 2013 Advanced (Level 3) course is the last of a 3 level programme that is designed for Microsoft Excel 2013 spreadsheets users who want to maximise the full use of the software. This course is for you if you want to extend the knowledge and skills you acquired from the Intermediate (Level 2) course or previous knowledge and experience acquired from elsewhere. You will learn how to use the Advanced Features of Microsoft Excel through engaging in a range of activities associated with protecting worksheet data, performing advanced data operations, data considerations, filters and advanced Pivot Table techniques, macros, and much more. Upon completion of this course you will develop your skills and knowledge in the following:

 Modifying Excel options
 Protecting data in worksheets and workbooks
 Importing and exporting data into Excel from Excel
 Using data linking for creating more efficient workbooks
 Grouping cells and using outlines for manipulating worksheets
 Creating summaries in your spreadsheets using subtotals
 Combining data from several workbooks into one
 Creating, using and modifying data tables
 Creating and working with scenarios
 Creating and Editing PivotCharts
 Constructing and operating Pivot Tables using some of Excel’s more advanced features
 Using advanced filters for analysing data
 Using a variety of data validation techniques
 Using a range of Information functions and Text functions
 Creating and using a range of controls in workbooks
 Sharing workbooks with other users
 Creating recorded macros in Excel

Speaker/s

Aspyra's highly qualified and occupationally competent Training Consultants will engage you in interactive learniing experiences. Our friendly, yet professional approach will contribute enormously to boosting your skills and competence.

Special Offer

15% Discount when you book 3 x delegates on the same course on the same day
20% Discount when you book 4 x delegates on the same course on the same day
25% Discount when you book 6 x delegates on the same course on the same day

Reviews

Be the first to write a review about this course.

Write a Review

Aspyra Training provides a wide range of ICT and online, distance learning training courses from beginner to advanced levels. Courses include ECDL, ECDL Extra, ECDL Advanced, E-type, CCNA Switching and Routing, A+ Certification, MCTS Configuring Microsoft Windows 7, MCTS Windows Server 2008 Administration, MC PRO Windows Server 2008 Network Infrastructure Implementation and Configuration, MCTS Windows Server 2008 Active Directory Implementation and Configuration, Cisco Courses, including CCNA Routing and Switching - all leading to a nationally and internationally recognised qualification.

Our offering also include tutor-lead courses in small classroom settings that include, Microsoft 2007 and Microsoft 2010 courses from Beginner to Advanced Levels in Excel Spreadsheet, Access Database, PowerPoint Presentations, Word Processing as well as Computerised Accounting Courses in Sage 50 Accounts Software, QuickBooks and Sage Payroll.

Our Trainers and Consultants are highly qualified and occupationally competent in their chosen field and provide the relevant support required by our clients. We adopt a flexible approach to the development and delivery of our courses and place our clients at the centre of what we do, thus ensuring that we meet their unique requirements. ...

View Complete Profile

Office Application & Computer System