Data Management and Analysis with Advance Excel

Simpliv

Course

Online

£ 10 + VAT

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I would teach you on how to apply the formula and understand its business and analytical application as well.By the end of the course you'll be writing robust, elegant formulas and functions which would help you to analyze data by allowing you to:Understanding basics:AutoFill a Series
Creating a Custom ListData ToolsData Validation
Drop-Down Lists
Text to Columns
pmt
Goal Seek
Scenario Manager
Data Table
Vlookup
hlookup
Importing and Exporting Data
Identifying and deleting duplicatesOutline, Sort, Filter and SubtotalIntroduction
Group and Ungroup and subtotals
Subtotals
ConsolidatePivot TablesIntroduction
Creating Pivot Tables
Choosing Fields
Pivot Table Layout
Filtering Pivot Tables
Modifying Pivot Tables Data
Pivot ChartsSpecial FunctionsCount / Counta / Countif / Countifs
Sum /sumif / sumifsMacrosMail mergeWho is the target audience?This course is suitable for any individual who wants to go beyond the basics of Excel and learn to master excel
Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

After taking the course the students would be able to do Autofill, Data Validation
Analytical Functions like - Goal Seek, Scenario Manager and Data table
Functions like PMT, Vlookup, Hlookup, Multiple vlookup, Identifying and deleting duplicates
Importing and exporting data, creating subtotal based reports
Pivot tables, Pivot Charts
Functions like count, countif, countifs, sum, sumif,sumifs
Introduction to basic Macros and Mail Merge
Fun, interactive, and highly effective lessons from a best-selling Excel instructor
Unique tips, tools and case studies that you won't find in ANY other course
Lifetime access to reference materials and practice files

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Data Management
  • Excel
  • Data analysis
  • Database
  • Management Planning
  • Management Control
  • Information Systems
  • Information Systems management
  • Computing

Course programme

Introduction 2 lectures 11:51 Introduction Introduction to the course. Autofill and Custom Lists Introduction 2 lectures 11:51 Introduction Introduction to the course. Autofill and Custom Lists Introduction Introduction to the course. Introduction Introduction to the course. Introduction Introduction to the course. Introduction Introduction to the course. Introduction to the course. Introduction to the course. Autofill and Custom Lists Autofill and Custom Lists Autofill and Custom Lists Autofill and Custom Lists Data Tools 9 lectures 53:50 Data Validation PMT Function Data Table Scenario Manager Goal Seek Vlookup and Hlookup Approximate Vlookup Multiple Vlookup Identifying and Deleting Duplicates Data Tools 9 lectures 53:50 Data Validation PMT Function Data Table Scenario Manager Goal Seek Vlookup and Hlookup Approximate Vlookup Multiple Vlookup Identifying and Deleting Duplicates Data Validation Data Validation Data Validation Data Validation PMT Function PMT Function PMT Function PMT Function Data Table Data Table Data Table Data Table Scenario Manager Scenario Manager Scenario Manager Scenario Manager Goal Seek Goal Seek Goal Seek Goal Seek Vlookup and Hlookup Vlookup and Hlookup Vlookup and Hlookup Vlookup and Hlookup Approximate Vlookup Approximate Vlookup Approximate Vlookup Approximate Vlookup Multiple Vlookup Multiple Vlookup Multiple Vlookup Multiple Vlookup Identifying and Deleting Duplicates Identifying and Deleting Duplicates Identifying and Deleting Duplicates Identifying and Deleting Duplicates Subtotalling Data 2 lectures 08:30 Data Subtotal Data Consolidate Subtotalling Data 2 lectures 08:30 Data Subtotal Data Consolidate Data Subtotal Data Subtotal Data Subtotal Data Subtotal Data Consolidate Data Consolidate Data Consolidate Data Consolidate Summarizing Data through Pivot Tables 6 lectures 21:53 Branchwise Pivot Datewise Pivot Count of Account Types Pivot Bucketwise Pivot Pivot with Conditional Formatting Pivot Graphs Summarizing Data through Pivot Tables 6 lectures 21:53 Branchwise Pivot Datewise Pivot Count of Account Types Pivot Bucketwise Pivot Pivot with Conditional Formatting Pivot Graphs Branchwise Pivot Branchwise Pivot Branchwise Pivot Branchwise Pivot Datewise Pivot Datewise Pivot Datewise Pivot Datewise Pivot Count of Account Types Pivot Count of Account Types Pivot Count of Account Types Pivot Count of Account Types Pivot Bucketwise Pivot Bucketwise Pivot Bucketwise Pivot Bucketwise Pivot Pivot with Conditional Formatting Pivot with Conditional Formatting Pivot with Conditional Formatting Pivot with Conditional Formatting Pivot Graphs Pivot Graphs Pivot Graphs Pivot Graphs Special Functions 2 lectures 13:31 Count, Countif and Countifs Sum, Sumif and Sumifs Special Functions 2 lectures 13:31 Count, Countif and Countifs Sum, Sumif and Sumifs Count, Countif and Countifs Count, Countif and Countifs Count, Countif and Countifs Count, Countif and Countifs Sum, Sumif and Sumifs Sum, Sumif and Sumifs Sum, Sumif and Sumifs Sum, Sumif and Sumifs Macros and Mail Merge 4 lectures 21:28 Creating and Editing a Simple Data Entry Macro How to Mail Merge using Word and Excel How to Mail Merge to Email Downloadable Resources Downloadable Resources for Practice Macros and Mail Merge

Additional information

Microsoft Excel should be installed on your system, this course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016 Some experience with basic formulas is recommended, but not required

See related categories

Data Management and Analysis with Advance Excel

£ 10 + VAT

The best Other Database courses

See all

See all