Excel has become the primary analytical tool of the business world. But this is not just an Excel course: this course is about business analytics. It’s about turning business data into valuable information, using Excel as the tool. This course is designed for college students taking business courses. While giving a guest lecture at the University of Oregon, I learned that both students and faculty were not happy with the existing business courses that taught Excel. The courses were too focused on the mechanics of Excel, on the commands and menu paths. And they used contrived, artificial examples. Improve your grades in business classes. Be better prepared for interviews. So I designed this course around authentic case studies from my experience as a senior business executive. The first case study is based on sales reporting and analysis. Students are given all of the sales information for a small company for an entire year. Through applying Excel functions like VLOOKUP and IF, the data is prepared for analysis. Then using pivot tables, the data is summarized and analyzed. The results are displayed visually with charts. Finally, the results are explained in writing. And students learn some “Business Basics” along the way, about invoicing, credit memos, and sales analysis. Students learn Excel while answering real business questions. The second case study is based on service repair and analysis. Students are given text files with the repair history of two different service sub-contractors (more than 50,000 records). The data must be imported, cleaned, and harmonized, using Excel text, date, and logical functions. Finally, the data can be analyzed with pivot tables and the results displayed visually: Which sub-contractor repairs products more quickly? These are the skills employers are looking for! The course begins with an optional “Quickstart” Tutorial for beginners, or for those students who haven’t used Excel in awhile, to refresh their knowledge. The University of Oregon uses these case studies in two of their information management courses. And my other Udemy courses are recommended by the Oregon Business Education Association. This course covers these topics in Excel: Formatting Data Cleaning "Dirty Data" with Functions: Text, Date, and Logical Functions Filtering and Sorting Data with Table Functions Analyzing Data with Pivot Tables Visualizing the Results with Charts and Conditional Formatting Content and Overview In five hours of content including 50+ lessons, this course covers the important Excel functions to analyze business data. Most lessons have a practice session. I provide two Excel files for each practice session: the starting point and the finish point. I also provide the written script for most lessons. Upon completion, students will be able to analyze large sets of business data. Students will be able to import large text files with tens of thousands of records, use Excel functions to clean data, use logical functions to build complex expressions, use the VLOOKUP function to work with cross-reference tables, analyze the data with pivot tables, display the results visually with charts, and explain the results in writing, and with clarity. And you’ll know more than 80% of the casual Excel users in business today! Let’s get started!

WHY CHOOSE US? Hi there! How are you? Thanks for considering our course. There are at least 100 Excel and data analysis courses out there. Why choose ours? Because of the fact that we mix it with story telling. We integrate interesting stories to give Excel and data analysis some context. So do not expect a boring ride. Instead, expect an exciting ride. So expect context about for instance: Kellog's cornflakes' weird history Dutch Christmas traditions Tasty Brazilian fast food Albrecht brothers who founded Aldi supermarkt Atari and Nintendo The Navy SEALs Dutch theme park 'The Efteling' And much much more.... STRUCTURE This course is 2 courses in 1 . PART 1 In the first part you learn how Excel works. What exactly? Pivot charts and pivot tables Nested IF functions AND function Combining IF & AND function Cross sheet referencing Vlookup Freeze panes List functions Absolute and relative cell references Histograms Pareto charts Multiple line charts Bar charts Chart theory PART 2 In part two, you will learn the theory of statistical techniques for data analysis. You do not need any statistical or mathematical background. Subsequently, you learn how to execute these theories in Excel. The tools of data analytics which you will learn include for instance: Standard deviation Correlation Single OLS regression Multiple OLS regression Non linear regression At the end of this course, you obtain a certification of completion. Note: We use Excel 2016, but other versions are fine too. Thanks for considering us. Have a great day, wherever you are. Team SSAA

These videos are about spreadsheets, and it has been designed to give you a step by step detailed approach on how to build a spreadsheet from first design to completed projects. The video covers much more than spreadsheet, it includes Windows basics, spreadsheet design, data tables, PivotTables, Financial Accounting etc. - all are fully explained and discussed which will help in building your skills as you learn to perform increasingly specialized procedures and in the long run help you to build well-designed and professional spreadsheets.

When we are learning something new, we always need to start with the basics. This course will provide you with the basic skills to calculate and interpret the financial ratios of a company using Excel . After you complete this course you will be able to : Work with multiple spreadsheets and manipulate them for your preferences Use the cells easily and understand the basic functions Know how to use the basic formulas Know how to insert and use charts and spark lines Retrieve financial statements of various companies Use the liquidity, efficiency, leverage, coverage, and profitability ratios Perform analysis of a cash flows statement Able to continue to more advanced Excel and Financial Analysis courses I encourage you to take notes , and work together with me during the course. This is very important for you to become confident with application of your knowledge. I believe that everyone should have the appropriate basic Excel skills and to perform basic financial analysis. Once you complete the course, review it so that other students can enjoy it too. Enjoy the course!

This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You'll learn a wide variety of important Excel features, including Pivot Tables, sorting and filtering, keyboard shortcuts, as well as intermediate functions like VLOOKUP, INDEX & MATCH, IF statements, and many more (2016 PC Version used in course). Sample data sets provided for you to follow along and learn as you watch!

Teach Excel to Do Your Work FOR YOU. . . Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there. In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets. Excel programming utilizes a simple but effective tool called "VBA" - the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use. I'll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you'll learn another essential skill that you can immediately use. You'll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there's one thing I'm good at - and my students are good at - it's AUTOMATION. My motto is, "If I'm not making everybody's job easier, quicker and more enjoyable, I don't deserve to have this job" - and that's what I live by. Take this course and access your true potential. Oh, and I want to be the first to hear about your New Raise you get once you're making Excel Programs and running everything on autopilot for your co-workers! -Dan Here's what some of the students are saying: “I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” - Jim C. “Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” - Marcela T. “I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I've improved my reporting exponentially and it's all thanks to this course!" - Ryan S. “You can't go wrong with Daniel Strong!” - Steven S. “The presenter explains in detail and demonstrates what he's covering, easy to follow along and learn!” - David B. “Teaches you the fundamental of VBA programming without any prior experience. Shows with easy to follow Example!. thanks for the video!” - Sean C. "I've taken several different VBA courses here on Udemy and this one from Daniel is by far the most interesting and easy to understand. I've done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I've been doing manually for years... I'm angry with myself because of the time I wasted by not buying this course earlier . I can't even imagine what I will be able to do after finishing the entire course :)" - Robert “Well explained, easy to understand lectures. Enjoyable and informative videos.” - Marlena “Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” - Gustavo P. “ Best course on VBA ever taken . Thanks a lot!” - Nikita L. “This is an excellent course!!!  There's a lot of good, useful "stuff" here.  The examples are practical and real-world!” - Todd W. “Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor .” - Scott K. “By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and "How-to" guides, but I have never seen something this complete , this throughout. I am amazed at how little I actually new about the VBA world. Thanks a million!” - Alex B. “Everything I have been looking for, you would have to buy multiple books for this level of instruction!” - Luke S. "Excellent VBA basic to advance tutorial." – Sandeep G. “This course is good for beginners and for experienced programmers .  Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet.  He goes over different events and triggers (like buttons) to execute code.  This is a really good course if you plan to do some pretty complex vba code with forms and reports.” - Christian H. “Very helpful if you do any type of data analysis.” – Jonathan D. “I think this is an excellent gateway to the tools we need to use going forward. I like the hands on nature.” – Andre C. “Much better than other classes and seminars. Great course.” – Mark S. “The instructor made VBA easy and straight forward to use.” – Min Z. “Very thorough and practical.” – Juan S. ***Now Available for Offline Viewing!***

Statistical Analysis and Research using Excel is a blended learning program of theoretical knowledge with its application in Microsoft Excel software. This course is a base to all the analytical studies and research studies. It is focused on more industry relevant examples and situations, where in you learn how you actually need to apply your research and analytical skills at workplace. This can also be considered as a foundation course if you are looking out for higher education in research and analytics. From the work perspective, this course is more suitable to jobs for data engineering, data analyst and marketing research jobs.

The course is presented in three parts. First, the course reveals the 3 environments forecasts and budgets are made and compare each one of them. Next, the course presents 6 challenges in budget modeling and reporting. They include: o How to accommodate Operation Team’s need to work from Excel while all budgets are in the Planning system? o How to build an interactive budgeting model in Excel? o How to write into a PivotTable? Last, we provide 6 solutions to the above 6 challenges in budget modeling and reporting. They include: o Building an interactive budgeting model that allows the Operation Team to make changes to forecasts and budgets and see the results instantaneously o Building an “editable” PivotTable that allows Operation Team to put forecasts and budgets directly in the PivotTable report. o Consolidating Actuals, Forecasts and Budgets from different data sources by using Power Query o Building integrated Slides from Excel Reports:

Excel is one of the most in-demand skills at all levels and having complete knowledge of this tool will help you to grow and earn. Data which is downloaded from softwares, survey forms have errors in terms of formatting, duplications, numbers saved as text, numbers saved as negative, etc., There is a need to clean all these data errors to prepare the data for a meaningful and insightful interpretation

Hello There !! Want to test your Excel Knowledge ? Are you afraid of Excel Tests ? Do you want to boost you Excel Knowledge Confidence ? Well you are at the right place ! This course is all about Excel Tests. Evaluate your knowledge by taking these Excel Multiple Objective Questions , where you will be given sets of practice questions where in you have  to answer and evaluate your Knowledge. These test contain questions ranging from Beginner level to Expert Level. This will give you a perfect mix of all the types of Excel Objective Questions. Once your Weak areas are identified work on them and improve on it. These Excel tests will give you a firm confidence to attend all excel questions asked in Job Interviews and Job Placement activities. Extra care has been taken to design these quizzes !! Its a 100 % Confidence Booster !! Bonus part is once enrolled you will get a chance to answer all the excel quizzes uploaded in the future in this course. Regular Excel quizzes will be uploaded in the future so that students can make the best use of it in the Academics , Interviews , Workplace & Knowledge Development. Enroll in this course and boost your confidence !! Happy Learning  !! LOGISTICS & Supply Chain World.