**ANNOUNCEMENT January 2018: 1.5 Hours of Practice Problem Lectures Added!** This is a 100% example-based comprehensive Microsoft Excel training course with a special focus on speed, automation and efficiency (the keys to becoming a power-user). You’ll learn how to build models, write formulas, and perform analysis. Master Microsoft Excel Rapidly in this Comprehensive Course! As a finance professional, I built the curriculum based on the skills needed to succeed in today’s business environment, and I’ve excluded what you really don’t need to know. This course is a hack to develop advanced power-user skills in Microsoft Excel 2016 in a very short period of time. In this course you will learn how to: Increase Excel speed 3X by abandoning the mouse Clean, format, filter, and sort data sets Create dual axis charts to compare related data sets Investigate business questions using conditional statements Analyze the sensitivity of results to changes in variables using what-if analysis Slice, dice, and extract rapid insights using pivot tables - Why Excel Skills Matter Advanced Microsoft Excel skills can open up a whole myriad of career opportunities (especially analyst roles) in industries such as finance, consulting, analytics or other business roles. Excel is the primary tool used in financial modeling and ad-hoc data analysis. In this 100% example based course, you’ll develop highly marketable business-focused Excel skills to help you outperform competing candidates for promotions, job opportunities, and internships. You’ll learn what it means to be an Excel power-user, and why it can be such an unfair advantage to develop this skill set. How is the Course Structured? The course curriculum builds on itself, meaning that as we continue forward in the course we’ll re-use the concepts from previous sections to further reinforce them. All of the material is 100% example based and in many sections we’ll use one continuous example through multiple lectures. The course is composed of 27 short lectures (most between 2-10 minutes) each of which cover one concept at a time, and 8 lectures covering practice problems. The full course length is around 4 hours with 2.5 hours of concept lectures and 1.5 hours of practice problems. There are screencasts, business discussions, quizzes and a downloadable file of the full course curriculum to practice along with. I designed the course to be hands-on and engaging. Complete with working files, you’ll be able to follow along practicing each concept and receive a verifiable certificate of completion when you finish the course!

Master important topics such as Charts and Graphs, Working With Data, Dynamic Formula, and Named Ranges. A full 4.5 hours of expert instruction 39 individual video tutorials More advanced mastery of Excel Perfect for advancing at work Easy to follow instructions Step by step tutorials are easy to understand More advanced use of working with data Mastery of charts and graphs Covers Dynamic Formula and Named Ranges Helps you become an Excel power user Practice what you learned with included exercise files Learn Excel 2016 Intermediate takes you well beyond the beginner stage to become an Excel power user. Now you can possess the more advanced skills that will set you apart from others. The course consists of 39 individual video tutorials that last a full 4.5 hours. Work at your own pace and take as much time as you need. This lets you fit the course work with your work schedule and life. Or speed through the course to give yourself crash mastery. This Intermediate level course gives you the additional advanced skills you need to become more valuable at work. Also perform more impressive duties in your own business, for volunteer work, or to augment fun hobbies. Excel is part of the MS Office package that is used in business everywhere in the world. Now you have access to a step-by-step course that empowers you to become an impressive Excel power user. Instruction is professionally produced for clarity and ease of learning. Each process is explained in detail with lots of illustration. Step by step instruction makes functions easy to understand and remember. Contents and Overview Learn Excel 2016 Intermediate starts where the beginning Excel course concluded. This course gives you more advanced mastery of working with Excel. Rather than being limited to a few functions, this Intermediate course lets you go much deeper into the remarkable power and functionality of MS Excel. The course starts by explaining terminology, tips and tricks in the ribbon, hotkeys, and defining your Excel view. This approach to the beginning gets learners off on the right foot. You gain a better understanding of finding your way around Excel. The next few chapters present interesting video tutorials that fully explain Indexing and Lookups. The various functions are illustrated and discussed and case study lookups are explored. Additional chapters talk about intermediate creation of charts and graphs and working with data. DataTables, Data Slicers, Pivot Tables and much more. Video lengths range from around 3 minutes to 11 minutes. This lets you learn in small manageable blocks that can be studied around a busy schedule. *Updated July 2017: Close captions in English added.

This course provides a basic introduction to Excel via a case study. In the case study, you will analyze the product sales from a business, Cowboy Business Machines. Like other Excel courses, you'll learn the basics: data and number formats, formulas, copy/paste, insert/delete, printing, data filtering, pivot tables and charts. This course is different from most other Excel courses because it focuses on the use of Excel to answer real business questions like "Who were the top customers for the year?" "What were the top-selling products?" "Did sales increase or decrease?" So you'll also learn about business topics like invoicing and sales. At the end of the course, there is a lesson on how to write a basic business report to summarize the results from the product sales analysis: what topics to include, and some formatting tricks in Microsoft Word. So this course is not just about Excel: it's about how to analyze business data and communicate the results with clarity. I provide all of the scripts from the lessons. I provide all of the worksheets, with detailed answers to the practice questions. At the end of the course, there is an additional practice worksheet so that you can master the topics covered in this course. I also provide the full text from the sample business report, so that you can use it as a template in your job. The course has three hours of video content. Expect to spend about 8 - 12 hours altogether, over four or five days, to complete the course. The course is recommended by the Oregon Business Education Association.

To become Master of your own personal finances, I think you need two things : 1) Fundamental understanding of how money WORKS , gets LOANED /lent, SPENT and more importantly COMPOUNDS! 2) A tool which helps you to crunch numbers effectively to put your ideas into reality . (No point in just having a theoretical knowledge) This course is for people who want to take control of their own finances in their own style! This is a truly TWO-IN-ONE course where you learn MS Excel and basic financial concepts together. The modules and the hands -on assignments are designed so that you will confidently come up with your own solutions to your personal financial scenarios. Caution : I strongly recommend you to work parallely in your MS Excel worksheet during the course. This is a practical course- you'll crunch numbers and you will make your own financial plans from the scratch. I will personally assist you to get your d What IS covered in this course? MS Excel fundamentals - Quickly learn the essential MS Excel skills like Conditional formatting, smart copy pasting, data filters Work smartly with the tips and tricks like Quick navigation, relative and absolute references, shortcuts to save time Impress your boss and colleagues with beautiful spreadsheets and follow best practices Basic financials you must know How bank loans work and how to smartly find out your repayment strategy Power of compounding - the " Mantra" to generate wealth Analyse your bank statement using data filters, get valuable insights on your spending habits Personal financial planning Link the basic ideas you have learnt to plan a grand plan suited to your personal scenario What is NOT covered in this course? 101 generic ways of money making/saving which you can anyway find it on internet easily: Let's keep it crisp, concise and clear. I feel I should not waste your time by lecturing you on 100 different money making techniques. Only a small fraction of those tips can benefit you, remaining "hacks" will most likely not be feasible for you to follow. Tax savings, Investment tips/advice on Stocks & mutual funds etc. : Without knowing your financial status, liabilities, responsibilities, risk taking limitations, it makes little sense for me to give direct advice. However, the course provides you with something more powerful - ability to gauge your financial status, ability to use a powerful tool -MS Excel to make your own calculations, ability to think in a financially smart way. Your two hours on this crash course may have a life-long impact! By the end of the course, If you are not able to you will be able to come up with your own goals, financial plans, your money will be refunded 100%. The Course includes: MS Excel tutorials, tips and techniques Carefully designed quizzes to compliment your learning Demonstration sessions on handling financial situations Practice MS Excel spreadsheets and support files Templates- xlsx financial calculators (which will be built during the course) Reference and support materials to understand basic concepts This course doesn't feed you fish; it teaches you how to fish!

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.

Microsoft Excel - Getting Started With The Basics , is an Excel Course where you can learn how to get the most out of Microsoft Excel , even if you are a complete Excel beginner! You will learn all about MS Excel cells, Excel rows & columns, how to speed up your work with Excel spreadsheets and easiest ways of sorting & filtering data in Excel 2010 and onwards. We will explore some of the most popular Excel charts and graphs, and Excel formulas and functions and from there we will dive into best practices to make sure you know Excel Essentials for the real world. "Useful and easy to follow. Great teacher. I'm self-taught on excel and have used for 17 years.... l earning so much from this course that is already speeding up my work! " -  G Wilkinson "This course is exactly as described: a beginner's tutorial on the most basic and fundamental aspects of Excell. I haven't used Excel in almost a decade and needed a refresher to see if I still remembered the most important aspects, and while I definitely do, I also learned a lot of new and interesting tips and techniques (like different ways to force a worksheet to print on a single page). The instructor was articulate, friendly, and concise. This was a perfect "Basics" course !" - Vivian P. "The pace of tutoring and interactivity made the information easy to understand. " - G Parker As your instructor, I will use my experience of Excel training in some of the top UK companies to guide you step by step on your way of mastering the Microsoft Excel Basics .  Whether you're looking to do your job faster, wow your boss, step up your Excel data analysis game using Microsoft Excel or to improve your resume, you are in the right place. Course access includes comprehensive workbook with examples, 1-on-1 tutor support, lifetime access and a 100% money-back guarantee! "The pace of tutoring and interactivity made the information easy to understand." - Garith Parker "Useful and easy to follow. Great teacher. Im self taught on excel and have used for 17 years.... learning so much from this course that is already speeding up my work!" -  Graham Wilkinson Learning Excel is a bit like building a brick wall. Many beginners have a basic foundation - they understand the essentials of spreadsheets. Then they start piling on a few bricks here and there. But as their wall of knowledge is constructed, it's full of holes. Eventually they hit a point where their wall can't sustain any more weight and it collapses. What a waste of time! This course takes a step-by-step approach to working with ms Excel . Each lesson builds upon the previous one, so your wall is solid. So whether you're looking to do your job better , or if you're looking to improve your resume , you are in the right place. A comprehensive workbook with examples is included to save you time. You can also ask me any questions via the course discussion board.