Excel inhouse

...sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration. Microsoft Excel 2002 Training Course (Intermediate)...

...Print the content of an Excel worksheet. Users wanting to learn Excel 2013. #text-block-10 { margin-bottom:0px; text-align:left; } Creating a Microsoft... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...Working with events Overview of event types, Event-handler procedures, Workbook events, Worksheet events, Chart events, UserForm events, Activate event... Learn about: Excel training, Excel on-site training, Excel in-house training...

...this course without any obligation. Learn all the Excel basic skills including: navigation, data entry, editing, saving your work, formulas and functions... Learn about: Beginners Excel, Using excel, Excel Formula...

...ranges Moving data Copying data Moving and copying data Inserting rows and ranges Moving data Copying data Formatting a worksheet Formatting a worksheet...

...Learn to use conditional formatting and styles. Excel Users wanting more experience. #text-block-10 { margin-bottom:0px; text-align:left; } Advanced Formulas... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...

...how to use this powerful Business Intelligence tool to gain useful new insights into their business data. PowerPivot Basics What is PowerPivot for Excel... Learn about: Excel training, Excel on-site training, Business Intelligence...

...Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns... Learn about: MS Excel, Date Functions, Calculated columns...

...including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper...

...Import and export data. Excel Users wanting more experience. #text-block-10 { margin-bottom:0px; text-align:left; } Using Pivot Tables Creating Pivot Tables... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...and introduction to power query formulas. Getting Started With Power Query What Is Power Query?, Installing And Activating Power Query, Overview Of Data Sources... Learn about: Excel Power Query on-site training, MS Excel, Excel Power Query training...

...To give users an extended knowledge of Excel’s advanced features and functions. Delegates will learn how to manage, automate and customise workbooks...

...forms, and reports. In this course, you will explore some of the more specialist and advanced aspects of Access, including writing advanced queries...

...work with data tools, protect documents for collaboration with others, and work with macros. Create basic worksheets using Microsoft Excel... Learn about: Microsoft excel training, Microsoft Excel, Ms Word...

...powerful tool to summarise and analyse data and then enhance it with formatting, custom calculations and filtering to produce unique and useful reports... Learn about: Excel Pivot Tables training, Excel Pivot Tables on-site training, Excel Pivot Tables in-house training...

...This course is suitable for users with a basic understanding of Excel who want to consolidate and expand on their knowledge of the basic features in a short space of...

...macros to buttons or a custom toolbar Recording Macros Entering a list of people's names Formatting a cell Adding a Header and Footer Naming the three...

...nested functions to build complex formulas. This Excel course also covers the auditing of formulas and and the handling of errors. Functions are at... Learn about: Excel Functions and Formulas in-house training, Excel Functions and Formulas on-site training, Microsoft excel training...

...a great deal before but wish to know how to not only use it, but create functions through formatting, organising data and using multiple spread sheets...

...The Locals Window, The Immediate Window Function procedures Sub versus function, User-defined functions, Declaring a function, Calling a function... Learn about: Excel training, Basic IT, Excel in-house training...