Excel for Business Analysts
Microsoft Excel remains one of the best tools for Data Analysis. In this course, we focus on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We start by looking at how to take raw data and clean it so it’s in a usable format. Then, we look at tools and functions used to conduct analysis, displaying data in the most meaningful way and advanced techniques designed to aid in forecasting.
4.8 (5 Reviews)
389 student views
Course Goal
- Which formulas and functions in Excel help you to prepare data for analysis
- How to use Pivot Tables to perform data analysis in Excel
- How to display your analysis using charts, graphs, and Pivot Charts
- How to conduct forecasting in Excel using various forecast functions
- How to fill gaps in data using Goal Seek, Scenario Manager and Solver
Who This Training Is For
- Consultants
- End users
- IT/Business analysts
- Project Managers
Exam/Certificate
- Certificate of Completion (more certification info)
- Upon successful completion of this course, receive your Excel for Business Analysts certificate
This Course is In the Following Learning Paths:
Learn the concepts and fundamentals needed for a career as an IT / Business Analyst. In this learning path, you will lea...
Instructor
4.7 Average Rating
131 Reviews
910 Students
23 Courses
Teaching Business Software
The IT in Simon Sez IT stands for Information Technology. In a nutshell: We make business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design, and QuickBooks. Self-paced, affordable software training is what Simon Sez IT is all about. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you're new to a certain technology or just technology shy in general. Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.
Student Feedback
4.8
Average Rating