Advanced Excel & VBA for Business Analytics

Excel & VBA for Accounting, Financial Statement Analysis and Business Analysis!

3.83 (6 reviews)
Udemy
platform
English
language
IT Certification
category
instructor
Advanced Excel & VBA for Business Analytics
35
students
10 hours
content
Sep 2019
last update
$19.99
regular price

What you will learn

Work comfortably with Microsoft Excel

Be much faster carrying out regular tasks

Work with large amounts of data without difficulty

Create professional charts in Microsoft Excel

Format spreadsheets in a professional way

Create beautiful charts using Excel

Understand business insights from data set

Work with multiple workbooks and sheets easily

Automate process with simple VBA

Description

"A Business Analyst Career is one of the top-paying entry-level jobs on the market.” 

"Even in the toughest job markets, the best candidates find great positions.", Forbes

You simply have to find a way to acquire practical skills that will give you an edge over the other candidates.

But how can you do that?

You haven’t had the proper training, and you have never seen how analysts in large firms do their work ...

Stop worrying, please! We are here to help.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's AddIn, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA

  • Understand how to use the right syntax in VBA

  • Useful Excel VBA codes you can directly use for your work

  • Use the macro recorder for simpler tasks and improve the code

  • Working with the Visual Basic Editor

  • Debugging tools and error handling methods

  • Different ways to reference ranges and cells

  • Different methods to loop

  • How to work with data types

  • PivotTables in Excel using VBA

  • Importing data from other files and exporting data to text files

  • Interacting with other applications (Word, PowerPoint, Outlook)

  • ActiveX and Userforms to enhance the Excel interface

  • Basically all the knowledge you need to automate tasks in Excel

Content

Introduction

Introduction
Course Curriculum
Introduction to Excel
Excel Basics 1
Excel Basics 2

Excel Intermediate - Conditional Formatting and Charting Design

Table Conditional Formatting
Data Chart Design

Pivot Table and Filtering

Create Pivot Table and Table Chart
Practise - Bond Portfolio NPV Simulation

VBA basics and Programming

VBA Syntax and Foundamentals
VBA for loops and controls
VBA User defined functions
VBA User interaction techniques
VBA practice and debugs
Summary

Charts

Price

Advanced Excel & VBA for Business Analytics - Price chart

Rating

Advanced Excel & VBA for Business Analytics - Ratings chart

Enrollment distribution

Advanced Excel & VBA for Business Analytics - Distribution chart
2124136
udemy ID
1/3/2019
course created date
10/29/2019
course indexed date
Bot
course submited by