ratings 

Working in a hands-on learning environment, led by our Excel Data Analysis expert instructor, students will learn about and explore: Create formulas to help you analyze and explain findings.Develop interactive spreadsheets that will impress your audience and give them the ability to slice and dice data.A step-by-step guide to learn various ways to model data for businesses with the help of Excel 2013.

PRIVATE
Course Access

Unlimited Duration

Last Updated

January 12, 2021

Students Enrolled

Total Video Time

EXPIRED

Posted by
Certification

Course Description

Data Analysis and Business Modeling with Excel 2013 is one of the easiest to use data analysis tools you will ever come across. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level.

This course starts by walking you through creating your own data and bringing data into Excel from various sources. You’ll learn the basics of SQL syntax and how to connect it to a Microsoft SQL Server Database using Excel’s data connection tools. You will discover how to spot bad data and strategies to clean that data to make it useful to you. Next, you'll learn to create custom columns, identify key metrics, and make decisions based on business rules. You’ll create macros using VBA and use Excel 2013’s shiny new macros. Finally, at the end of the course, you'll be provided with useful shortcuts and tips, enabling you to do efficient data analysis and business modeling with Excel 2013.

Profile Photo
3.86 3.857142857142857
360

Studens

About Instructor

More Courses by Insturctor

Course Curriculum

    • Getting started with data 00:00:00
    • Manually creating data 00:00:00
    • Reading a table from MSSQL – the Microsoft SQL Server database 00:00:00
    • Reading multiple tables from MSSQL 00:00:00
    • Reading from MSSQL using SQL 00:00:00
    • Leading/trailing/in-between spaces 00:00:00
    • Capitalization 00:00:00
    • Duplicates 00:00:00
    • Text to Columns 00:00:00
    • Combine data from multiple columns into one column 00:00:00
    • Fixing similar words 00:00:00
    • Text to dates 00:00:00
    • Text to numbers 00:00:00
    • How to create formulas 00:00:00
    • Combining strings and numbers 00:00:00
    • Using built-in functions 00:00:00
    • If/else/then statements 00:00:00
    • Comparing columns 00:00:00
    • Gathering data 00:00:00
    • Preparing the data for analysis 00:00:00
    • Analyzing our data 00:00:00
    • Gathering data 00:00:00
    • Preparing data 00:00:00
    • Analyzing data 00:00:00
    • Data models 00:00:00
    • Activating the Excel Solver 00:00:00
    • Modeling our linear programming problem 00:00:00
    • Using the Excel Solver 00:00:00
    • What is VBA? 00:00:00
    • What is a macro? 00:00:00
    • Opening the VBA Editor 00:00:00
    • Your very first “Hello World” VBA script 00:00:00
    • Quick analysis charts 00:00:00
    • Charting options 00:00:00
    • Additional design options 00:00:00
    • What are slicers? 00:00:00
    • Final tweaks 00:00:00

    Course Reviews

    No Reviews found for this course.

    © 2021 Ernesto.  All rights reserved.  
    Loading...