Data Analysis and Business Modeling with Excel 2013

This is a high-level list of topics covered in this course. Please see the detailed Agenda below • Discover what Excel formulas are all about and how to use them in your spreadsheet development • Identify bad data and learn cleaning strategies • Create interactive spreadsheets that engage and appeal to your audience • Leverage Excel’s powerful built-in tools to get the median, maximum, and minimum values of your data • Build impressive tables and combine datasets using Excel’s built-in functionality • Learn the powerful scripting language VBA, allowing you to implement your own custom solutions with ease

  • No Rating
  • (0 Reviews)
  • 0 Students enrolled

Hours :

Hands on Labs

Requirements

  • This course is geared for attendees wants to learn various ways to model data for businesses with the help of Excel 2013 Pre-Requisites: Students should have • Basic to Intermediate IT Skills and Excel knowledge • Good foundational mathematics or logic skills

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. 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

Course Content

Recent Courses

blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free
blog
Last Updated 25th September 2020
  • 0
  • Free

About the Instructor

instructor
About the Instructor

Ernesto Lee is an impassioned blockchain entrepreneur and technologist from the Miami/Fort Lauderdale Area. For over 25 years Ernesto has been asking hard questions and pursuing tough answers. Ernesto was an original founding member, co-owner and the CTO of Blockchain Training Alliance and former Chief Solutions Architect at TechBlue.com. Presently, Ernesto is the CEO at Ernesto.Net and Engineer at Kaiser Permanente.  Ernesto’s career illustrates a lifelong commitment to pushing the envelope on innovation and growing opportunities for all around him.

As a graduate of Old Dominion University (BS, Physics), Virginia Tech (MS, Software Engineering), and Harvard Extension School (Graduate Certificate, Business Communication), Ernesto has always had a passion for technology and teaching. It has been a cornerstone of Ernesto’s career.