Take your Advanced Microsoft Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.
Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?
A sound model is essential to understand the drivers and implications of business decisions. Strategic Axis Academy Advanced Microsoft Excel course covers the fundamental skills needed to utilize Excel to the best effect and then illustrates these skills in the context of developing best practice business models.
Still writing those complex and sophisticated macros? Now you can easily create them, without writing a single line of code!
This intensive hands-on training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts to increase their knowledge and productivity.
Advanced Microsoft Excel users encounter repetitive tasks such as reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis.
Using “Macros” many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again).
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. We also know how difficult it is to find quality instruction that is:
Easy to follow
Gets you the results you want
Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Advanced Excel course. It’s split into clear sections to get the results you want right away. Your teacher is an Excel expert, and trainer for 20+ years, whose experienced instruction will transform your Excel skills in under a week with none of the usual frustration.
This course is endorsed and officially certified by Microsoft.
Not ready for Advanced Excel? Have a look at our Microsoft Excel Intermediate Course.
This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.
Students will receive official Microsoft Certificate.
Creating Pivot Tables
Working with Pivot Tables
Inserting Pivot Charts
Using the PivotChart Tools Tabs
Formatting a PivotChart
More Pivot Table Functionality
Use advanced PivotTable techniques to do more with your data
Calculated Fields and Calculated items
Using PivotTables as the calculation engine behind management reports
Using GETPIVOTDATA() and CUBE formulae to create flexible reports
Building and interactive dashboard using PivotTables and Slicers
Outlining and Grouping Data
Using the Subtotals Tool
Using the Scenario Manager
Creating and Editing Scenarios
Creating a Scenario Report
Using Goal Seek
Using One-Input Data Tables
Using Two-Input Data Tables
Defining a Problem
Solving a Problem
Generating a Report of Results and Alternate Solutions
Converting Text to Columns
Linking to External Data
Controlling Calculation Options
Excel and Hyperlinks
Using Custom AutoFill Lists
Using Automatic Outlining
Consolidating Information by Position or Category
Creating an Advanced Filter
Using Database Functions
Using the VLOOKUP Function
Using the HLOOKUP Function
The Excel Power Pivot add-in
PowerPivot data tools
Calculations in Power Pivot – an introduction to Data Analysis Expressions (DAX)
DAX in table columns
DAX to create new measures and calculated fields
Understanding advanced DAX expressions – functions that combine calculations and database techniques
Time Intelligence DAX functions – why you need a table containing all possible dates
Creating powerful reports with PowerPivot
Hierarchies, Perspectives, and Sets
Adding Key Performance Indicators (KPIs) to a Power Pivot report
Creating CUBE formulae to report on your data in just the way you want to
Use all these techniques to turn millions of rows of data into a dashboard that supports better decisions
Protecting Worksheets and Workbooks
Marking a Workbook as Final
About macros and VBA
Configuring Excel for Macros
Adding Macros to the Quick Access Toolbar
Understanding volatile functions
Trigger a macro when a particular cell is changed
Handling errors elegantly
Creating Dynamic Macros
Using Functions and Formulas in Macros
Macros for Data Entry
Exchanging information with VB code
Displaying a Message box
Asking for user input using an Input box
Create an Excel form with a List box containing values from a range of cells
Sample VB projects: an automatic index to sheets, printing selected ranges
Avoiding macros when they’re not really necessary
Preparing a Workbook for Internationalization and Accessibility
Importing and Exporting Files
Multi-Select Option in Slicers
Quick Shape Formatting
Sharing with SharePoint or OneDrive
Train the Trainer Train the Trainer - Training for trainers. Gain a practical, how-to overview of the entire training function. Through modeling of the best practices and latest techniques in training delivery, discover the 4Ps of.....View Detail
Project Planning, Scheduling & Cost Control Project Planning, Scheduling & Cost Control Professional This project management course teaches techniques that will help you plan, implement, and complete projects with desired results on time.....View Detail
Method of Measurement of Construction Works Method of Measurement of Construction Works is becoming increasingly used in civil engineering works, under the NEC, ICE and FIDIC forms of contract, both in the GCC and overseas. It has a format.....View Detail
Project Budgeting, Cost Estimating, Control, and Life Cycle Costing Project Budgeting, Cost Estimating, Control, and Life Cycle Costing. The cost of a project is the most significant factor in its becoming a reality. Costs are dealt with at the.....View Detail
Certified Cost Professional (CCP®) Certified Cost Professional is an experienced practitioner with advanced knowledge and technical expertise to apply the broad principles and best practices of Total Cost Management (TCM) in the planning,.....View Detail
Variations Management Training Variations Management Training session will take you the best practice contract procedures for the variation of a contract, using JCT 2016 as a basis, including how to issue the instruction, keeping records and how to.....View Detail
Certified Information Systems Security Professional A CISSP is an information assurance professional who defines the architecture, design, management, and controls that assure the security of business environments. The vast breadth of knowledge and.....View Detail
Primavera Contract Management Oracle Primavera Contract Management (PCM) is a web based, multi-user, multi-project database system for managing all aspects of a project relating to the contractual relationship. This contractual relationship is the.....View Detail
Primavera Risk Analysis On large and complex programs, risk analysis techniques and the use of tools like Primavera Risk Analysis are a must have. Ten Six offers this training class allowing attendees to focus on the real world application of.....View Detail
Primavera P6 EPPM Administrator Training Primavera P6 EPPM Administrator Training. If you’re new to P6 EPPM or are migrating from a Primavera P6 Professional client system to EPPM, this course is ideal for getting up and running fast using the.....View Detail