The Microsoft Excel 2010 Advanced course will take learners one step ahead from previous versions covering advanced Excel topics. The course will teach learners new tools and techniques that save time and energy to analyse data, export charts and graphs and share it in the best presentation method. The Microsoft Excel 2010 Advanced qualification will give individuals the skill and knowledge on how to use different file formats and save an Excel spreadsheet file, and freeze rows and columns in a spreadsheet.
The Microsoft Excel 2010 Advanced course will cover key topics including how to create eye-catching charts and graphs, showcasing basic and complex trends, and learning the difference between data, relationships and charts.
The Microsoft Excel 2010 Advanced course will give insight into Excel tools whether it is about setting up live charts, learning how to use Pivot Charts and Tables and how to use numbers and columns so that the rows related easily. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2010 Advanced course.
As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.
1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.
At the end of the Microsoft Excel 2010 Advanced course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.
Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2010 Advanced.
The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.
Once you successfully complete Microsoft Excel 2010 Advanced you will be qualified to work in the following positions. The Microsoft Excel 2010 Advanced qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.
➤ Module 01: Logical and Statistical Functions | |||
Course Introduction | |||
1.0 Topic A: Logical Functions | |||
1.1 The IF Function | |||
1.2 Demo – A-1: Using the IF Function | |||
1.3 Demo – A-2: Using a Formula to Apply Conditional Formatting | |||
1.4 OR, AND, and NOT Functions | |||
1.5 Demo – A-3: Using OR, AND, and NOT as Nested Functions | |||
1.6 Nested IF Functions | |||
1.7 Demo – A-4: Using Nested IF Functions | |||
1.8 The IFERROR Function | |||
1.9 Demo – A-5: Using the IFERROR Function | |||
2.0 Topic B: Math and Statistical Functions | |||
2.1 The SUMIF Function | |||
2.2 Demo – B-1: Using SUMIF | |||
2.3 The COUNTIF Function | |||
2.4 Demo – B-2: Using COUNTIF | |||
2.5 The AVERAGEIF Function | |||
2.6 Demo – B-3: Using AVERAGEIF | |||
2.7 SUMIFS, COUNTIFS, AVERAGEIFS | |||
2.8 Demo – B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS | |||
2.9 The ROUND Function | |||
2.10 Evaluate Formula Dialog Box | |||
2.11 Demo – B-5: Using ROUND | |||
2.12 Unit 01 Review | |||
➤ Module 02: Financial and Date Functions | |||
1.0 Topic A: Financial Functions | |||
1.1 The PMT Function | |||
1.2 Demo – A-1: Using the PMT Function | |||
2.0 Topic B: Date and Time Functions | |||
2.1 Date Functions | |||
2.2 Demo – B-1: Using Date Functions | |||
2.3 Calculating Time | |||
2.4 Demo – B-2: Using Time Functions | |||
3.0 Topic C: Array Formulas | |||
3.1 Array Formulas | |||
3.2 Creating an Array Formula | |||
3.3 Demo – C-1: Using an Array Formula | |||
3.4 Applying Arrays to Functions | |||
3.5 Demo – C-2: Applying Arrays to Functions | |||
3.6 Modify an Array Formula | |||
3.7 Demo – C-3: Modifying the Array Formula | |||
4.0 Topic D: Displaying and Printing Formulas | |||
4.1 Displaying Formulas in Cells | |||
4.2 Hide Formulas from Users | |||
4.3 Show Hidden Formulas | |||
4.4 Demo – D-1: Showing, Printing, and Hiding Formulas | |||
4.5 Automatic Recalculation | |||
4.6 Edit Iteration Calculation Options | |||
4.7 Demo – D-2: Setting Calculation Options | |||
4.8 Unit 02 Review | |||
➤ Module 03: Lookups and Data Tables | |||
1.0 Topic A: Using Lookup Functions | |||
1.1 The HLOOKUP Function | |||
1.2 The VLOOKUP Function | |||
1.3 Demo – A-1: Examining VLOOKUP | |||
1.4 VLOOKUP for Exact Matches | |||
1.5 Demo – A-2: Using VLOOKUP to Find an Exact Match | |||
1.6 VLOOKUP for Approximate Matches | |||
1.7 Demo – A-3: Using VLOOKUP to Find an Approximate Match | |||
1.8 HLOOKUP for Exact Matches | |||
1.9 Demo – A-4: Using HLOOKUP to Find Exact Matches | |||
1.10 HLOOKUP for Approximate Matches | |||
1.11 Demo – A-5: Using HLOOKUP to Find Approximate Matches | |||
2.0 Topic B: Using MATCH and INDEX | |||
2.1 The MATCH Function | |||
2.2 Demo – B-1: Using the MATCH Function | |||
2.3 The INDEX Function | |||
2.4 Demo – B-2: Using the INDEX Function | |||
3.0 Topic C: Creating Data Tables | |||
3.1 One-Variable Data Tables | |||
3.2 Demo – C-1: Creating a One-Variable Data Table | |||
3.3 Two-Variable Data Tables | |||
3.4 Demo – C-2: Creating a Two-Variable Data Table | |||
3.5 Unit 03 Review | |||
➤ Module 04: Advanced Data Management | |||
1.0 Topic A: Validating Cell Entries | |||
1.1 Data Validation | |||
1.2 Demo – A-1: Observing Data Validation | |||
1.3 Setting Data Validation Rules | |||
1.4 Demo – A-2: Setting Up Data Validation | |||
1.5 Using Date Criteria | |||
1.6 Demo – A-3: Setting Date and List Validations | |||
2.0 Topic B: Exploring Database Functions | |||
2.1 Structure of Database Functions | |||
2.2 Demo – B-1: Examining the Structure of Database Functions | |||
2.3 DSUM and DAVERAGE | |||
2.4 Demo – B-2: Using the DSUM Function | |||
2.5 Unit 04 Review | |||
➤ Module 05: Exporting and Importing | |||
1.0 Topic A: Exporting and Importing Text Files | |||
1.1 Using the Save as Command | |||
1.2 Demo – A-1: Exporting Excel Data to a Text File | |||
1.3 Importing Data | |||
1.4 Demo – A-2: Importing Data from a Text File into a Workbook | |||
1.5 The Text Import Wizard | |||
1.6 Converting Text to Columns | |||
1.7 Demo – A-3: Converting Text to Columns | |||
1.8 Removing Duplicates | |||
1.9 Demo – A-4: Removing Duplicate Records | |||
2.0 Topic B: Exporting and Importing XML Data | |||
2.1 The XML Maps Dialog Box | |||
2.2 The XML Source Pane | |||
2.3 Importing XML Data | |||
2.4 Exporting Data to an XML File | |||
2.5 Deleting XML Maps | |||
3.0 Topic C: Querying External Databases | |||
3.1 Using Microsoft Query | |||
3.2 Demo – C-1: Getting External Data from Microsoft Query | |||
3.3 Web Query | |||
3.4 Retrieving Data from a Web Page | |||
3.5 Demo – C-2: Using a Web Query to Get Data from the Web | |||
3.6 Unit 05 Review | |||
➤ Module 06: Analytical Tools | |||
1.0 Topic A: Goal Seek and Solver | |||
1.1 Using the Goal Seek Utility | |||
1.2 Demo – A-1: Using Goal Seek to Solve for a Single Variable | |||
1.3 Activating Add-Ins | |||
1.4 The Add-Ins Dialog Box | |||
1.5 The Solver Parameters Dialog Box | |||
1.6 Demo – A-3: Using Solver to Solve for Multiple Variables | |||
2.0 Topic B: The Analysis ToolPak | |||
2.1 Analysis ToolPak | |||
2.2 Using the Sampling Analysis Tool | |||
2.3 Demo – B-1: Using the Sampling Analysis Tool | |||
3.0 Topic C: Scenarios | |||
3.1 Creating a Scenario | |||
3.2 Demo – C-1: Creating Scenarios | |||
3.3 Add a Scenario Manager Button | |||
3.4 Merging Scenarios | |||
3.5 A Sample Scenario Summary | |||
3.6 Unit 06 Review | |||
➤ Module 07: Macros and Custom Functions | |||
1.0 Topic A: Running and Recording a Macro | |||
1.1 Running Macros | |||
1.2 Demo – A-1: Running a Macro | |||
1.3 Recording Macros | |||
1.4 Demo – A-2: Recording a Macro | |||
1.5 Assigning Macros to Buttons | |||
1.6 Demo – A-3: Assigning a Macro to a Button | |||
1.7 Add Macro Buttons to the Ribbon | |||
1.8 Insert a Button | |||
1.9 Change Button Properties | |||
1.10 Demo – A-4: Inserting a Macro Button | |||
1.11 Create Auto_Open Macro | |||
1.12 Demo – A-5: Creating an Auto_Open Macro | |||
2.0 Topic B: Working with VBA Code | |||
2.1 VBA Code | |||
2.2 Observing VBA Code | |||
2.3 Demo – B-1: Observing a VBA Code Module | |||
2.4 Example of Editing VBA Code | |||
2.5 Demo – B-2: Editing VBA Code | |||
3.0 Topic C: Creating Functions | |||
3.1 Function Procedures | |||
3.2 Creating a Custom Function | |||
3.3 Demo – C-1: Creating a Custom Function | |||
3.4 Unit 07 Review | |||
3.5 Course Closure |
Essential Course
The course teaches you all the essential tools from Microsoft excel in a very easy and fun way.
EXCELLENT
Course content and structure are excellent and helps one to learn at an optimal rate. I can now do more with Microsoft Excel.
Great foundation
This course provides a great foundation of skills for Excel, additionally it can fill in a few gaps in your knowledge if you are a self-taught Excel user already.
useful and straight forward
I found this course to be extremely informative. The way the coursed is taught, and the quizzes are useful and straight forward.