Learn how to visualize your data and get automated charts, totals and tables from selected data in a spreadsheet in Excel 2016 by simply clicking on one button. For more information, see also our website: http://kaceli.com More details on the video: The Quick Analysis tool will display charts, conditional formatting, pivot tables and and be able to display this data in a chart within each cell next to it. Learn more at http://learn.kaceli.com. Direct links to the videos: Excel 2016 Tutorial: https://youtu.be/8lXerL3DHRw Word 2016 Tutorial: https://youtu.be/TxLuuNprjXg PowerPoint 2016 Tutorial: https://youtu.be/lbc1HX8Jccw Access 2016 Tutorial: https://youtu.be/1IA4SeajZRw If you like the videos, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series. Keep in touch: Website: http://kaceli.com YouTube Channel: http://youtube.com/skaceli If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.
Views: 13684 Sali Kaceli
I misspoke twice that alpha is three. It should be 0.3. Also, I originally made a mistake in question 3: equal likelihood method in my first recording. I redid it and fixed it. But I didn't redo the rest 5 questions. Therefore, when you see equal likelihood part after 8'04" mark, that part is wrong.
Views: 40966 CQ
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( 00:53 min mark) 2. How Data Must Be Setup ( 02:53 min mark) Sort: 3. Sort with 1 criteria ( 04:35 min mark) 4. Sort with 2 criteria or more ( 06:27 min mark) 5. Sort by color ( 10:01 min mark) Filter: 6. Filter with 1 criteria ( 11:26 min mark) 7. Filter with 2 criteria or more ( 15:14 min mark) 8. Filter by color ( 16:28 min mark) 9. Filter Text, Numbers, Dates ( 16:50 min mark) 10. Filter by Partial Text ( 20:16 min mark) Pivot Tables: 11. What is a PivotTable? ( 21:05 min mark) 12. Easy 3 step method, Cross Tabulation ( 23:07 min mark) 13. Change the calculation ( 26:52 min mark) 14. More than one calculation ( 28:45 min mark) 15. Value Field Settings (32:36 min mark) 16. Grouping Numbers ( 33:24 min mark) 17. Filter in a Pivot Table ( 35:45 min mark) 18. Slicers ( 37:09 min mark) Charts: 19. Column Charts from Pivot Tables ( 38:37 min mark) Formulas: 20. SUMIFS ( 42:17 min mark) 21. Data Analysis Formula or PivotTables? ( 45:11 min mark) 22. COUNTIF ( 46:12 min mark) 23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark) Getting Data Into Excel 24. Import from CSV file ( 51:21 min mark) 25. Import from Access ( 54:00 min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 1584264 ExcelIsFun
Views: 282575 ozanteaching
This video demonstrates how to conduct and interpret a multiple linear regression (multiple regression) using Microsoft Excel data analysis tools. Multiple regressions return the contribution of multiple predictor variables on one outcome variable. Predicted values for the outcome variable are calculated using the estimated regression equation.
Views: 38653 Dr. Todd Grande
I have noticed that many people throughout the world have been interested in my training videos on Using Database Queries and Pivot Tables in Microsoft Excel. So this training video, while very helpful for Active Planner customers, is applicable to any Excel user who wants to create database queries and then analyze that data using Filters and Pivot Tables. And as an added bonus, we will go into SQL Management Studio to build and debug our query and I will show you how to create a PIVOT query. I have created a new video for Sage 300 users so check it out at: https://youtu.be/HXzm8s2mVhI And Sage 500 users check out this new video at: https://youtu.be/UWJ9UrTeEr8 Thank you, Doug Leasure
Views: 172666 ActivePlanner
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 7211607 Excel Campus - Jon
This video covers a few topics using the data analysis tool. After this video you should be able to: a) Find and use data analysis on excel to calculate statistics b) Calculate the mean, median, mode, standard deviation, range and coefficient variation on a variable set of data in excel. c) Conduct a confidence interval in excel. d) Complete a T-test in excel to help complete a hypothesis test. e) Conduct a linear regression analysis output from excel and create a scatter diagram.
Views: 110987 Me ee
Este vídeo muestra la utilización de dos herramientas interesantes que forman parte del Add In: Table Analysis Tools for Excel. Estas herramientas son Analize Key Influencers y What if (Scenario Analysis). Estas herramienta se ejemplifica con un ejemplo fictisio sobre RIC (Registro de Informacion Catastral) de aca de Guatemala.
Views: 376 Eduardo Quetzales
An Excel Data Table is a great way to see the results of substituting two values in a formula. For example, to see what your monthly payment will be by changing BOTH the Interest Rate and the amount that you borrow. However, reading about how to set up an Excel Data Table can be confusing. Where, exactly, do you place the Row Inputs and the Column Inputs? Seeing how a Data Table is constructed is SO much easier. I invite you to watch this short Excel Training Video Lesson to see how to set up and use an Excel Data Table to analyze your data. You can find additional resources on my website: www.thecompanyrocks.com - I look forward to your comments.
Views: 642266 Danny Rocks
A simple overview of how people use Excel to get reports from SSAS
Views: 4646 Randal Root
In this video, I will show you how to use Data Analysis tool in MS Excel to create correlation table of multiple numerical variables. We use Boston Housing dataset for demonstration. Please let me know if you have any questions. Thanks.
Views: 4743 THE IT CHANNEL
How to use the Excel What If Analysis tools - Scenario Manager Goal Seek Data Table Excel 2016 2013 Please subscribe to my channel http://www.youtube.com/user/TomFragale?sub_confirmation=1 Tom Fragale Microsoft Certified Trainer Microsoft Certified Office Master Available for Onsite Training, Private Webinars, Consulting, and Custom Software (215)280-1073 [email protected] To get the sample file from these videos, send an email to [email protected] Top 20 Most popular videos Create Mailing Labels from Your Excel 2010 data using Mail Merge in Word 2010 Christmas holiday 2016 https://youtu.be/-dh1KutksMY Using Excel Macros and VBA - Complete - Excel VBA 2010 2013 2007 2016 Tutorial Macros & Visual Basic https://youtu.be/mRCx7x4Tyfg Using An Excel If Function Formula With Multiple Conditions - Excel 2010 Tutorial Examples 2013 2016 https://youtu.be/BoGQD35gAUc How To Compare 2 Sheets Using The Excel Vlookup Function Formula 2007, 2010 , 2013, 2016 Tutorial https://youtu.be/nVxGFPDp53g Excel Pivot Table Tutorial - Create A Monthly, quarterly, Yearly Summary Report Excel 2013 2016 2010 https://youtu.be/9k1KKbOwCEM Creating a workflow in Sharepoint 2013 - How to create a workflow in Microsoft Sharepoint 2013 2016 https://youtu.be/lPnxHWNtL7w How to compare 2 tables in Access - Create a Find Unmatched Query in Access 2007 2010 2013 2016 https://youtu.be/TkZdfptGxu8 Access switchboard manager - creating a main menu in Access 2010 Tutorial Access 2013 2007 2016 https://youtu.be/zVm5W8h7HFk Linking Sheets - Linking Data from Different Excel Sheets and Workbooks - 2010 Tutorial 2013 2016 https://youtu.be/OIL6V2jzDRI Installing an odbc driver in Windows 10 - SQL Server ODBC Driver Excel 2013 2016 Microsoft Access https://youtu.be/ehVFtmhPwxs Installing an odbc driver in Windows 8 and Windows 8.1 and Windows 10 SQL Server ODBC Driver Excel https://youtu.be/yJWxwDBl8-Y How to reset autonumber in Access 2013, Microsoft Access 2010, and Access 2007 Access 2016 https://youtu.be/hI3wS5cPUcc How to add a great lookup field to An Access form using the combo box wizard. Access 2016 2013 2010 https://youtu.be/HzD1T6VLDM0 How to make an Access query using yes no fields - Access 2010 Tutorial Access 2013 Access 2007 2016 https://youtu.be/z6r6r91V5FY Word Basics - Tutorial for Beginners - Microsoft Word 2010, 2013, 2016 Office 365 Getting Started https://youtu.be/prpVvtHB24M Word - Adding a Picture To Mailing Labels - Create Christmas Holiday Labels Mail Merge 2010 2013 https://youtu.be/iD9LN_esiEw How to lock a field on an Access form field protection on a form Microsoft 2007 2010 2013 2016 https://youtu.be/zVqCtgQoF6s How to Use a sharepoint list in Access 2013, Microsoft Access 2010, and Access 2007 Tutorial https://youtu.be/yD5VF9h25mI Excel Pivot Tables, Pivot Charts, Slicers and Dashboards - Complete Excel 2010 2013 2016 Tutorial https://youtu.be/Yzk0-u0fCCE How to import a text file into Access - Access 2010 tutorial CSV file Access 2007 Access 2013 2016 https://youtu.be/ddbf4lh7fZQ Most recent videos Excel 2016 PowerPivot and PowerQuery , Measures and KPI Data Analysis Excel PowerPivot & PowerQuery https://youtu.be/ytvsPCEK32I Excel Database Part 1 - How to Use Excel as a database - Excel 2010, 2013, 2016 tutorial https://youtu.be/5DwKhLVnMEg Excel Database Part 2 - How to Use Excel as a database - Excel 2010, 2013, 2016 tutorial https://youtu.be/7K6y6Gf146c Installing SQL Server on Windows 10 - How to install SQL Server 2016 Express on Windows 10 Free SQL https://youtu.be/WRGV3FC4s9E Excel For Bankers - How to maximize using Microsoft Excel For Bankers - Excel 2010, Excel 2013, https://youtu.be/eTpm5RxufP0 How to Export from an Access Table or Query to SQL Server - Access 2010, Access 2013, Access 2016, https://youtu.be/RPMMZMDgYJY How to create an ODBC Driver in Windows 10 for SQL Server 2016 - Tutorial https://youtu.be/ZCUMS39xR8Q Making it so it is required to check out a document in a document library in SharePoint 2016 & 2013 https://youtu.be/Owr0xHKXFrk Displaying multiple windows in Windows 10 - How to display multiple windows in Windows 10, Windows 8 https://youtu.be/Pk_djG750y4 How to Create Rules in Outlook to automatically handle emails - Outlook Rules tutorial - 2016, 2013 https://youtu.be/Zj42e-omLwQ
Views: 568 Tom The PC Trainer Fragale
We demonstrate installing Data Analysis ToolPak excel addin and how to build a Karl Pearson Correlation Matrix easily. The data set used can be downloaded from http://www.learnanalytics.in/blog/?p=150 . Please subscribe to our channel to receive updates and also join our Linkedin Group for latest training videos and articles @http://www.linkedin.com/groups/Learn-Analytics-step-time-4240061
Views: 121315 Learn Analytics
Example of how to build a sensitivity analysis table in Excel 2016 to evaluate how changing two inputs simultaneously will affect an output (profit). Course discount (81%): https://www.udemy.com/excel-power-user/?couponCode=YOU-TUBE ________ Here is a link to download the practice file we use in the video: https://excelpoweruser.weebly.com/blog/youtube-file-download Sensitivity analysis in Excel is one of the skills that separates the common Excel user from the power user. In this tutorial, we learn how to build a sensitivity analysis table in Excel 2016 to evaluate how changing two inputs simultaneously will affect an output (profit). I hope you enjoy this tutorial and please let me know if you would like more videos on sensitivity analysis. If you'd like to learn more, I built a business-focused Excel course on Udemy that is stripped down to the core functions for being an analyst. The objective is to get people to the power-user level quickly. The course is about 2 hours and includes things like: -completely abandoning the mouse to increase speed 3X -data manipulation & visualization -conditional statements & pivot tables Course discount (save 81%): https://www.udemy.com/excel-power-user/?couponCode=YOU-TUBE For additional tutorials about Excel, check out my Quora profile: https://www.quora.com/profile/Eric-Andrews-5
Views: 149660 Eric Andrews
Views: 75 AMI MASHIANA
Download Start Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-02-Start-DataTablesFilterLogicTest.xlsx Download Finished Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-02-Finished-DataTablesFilterLogicTest.xlsx Pdf notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-02-DataTablesFilterLogicTest.pdf This video #2 in our class teaches about Data, Data Types, Proper Data Sets, Excel Tables, Soring, Filtering and Logical Tests. This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more. Topics: 1. (00:12) Introduction 2. (01:14) What is Excel? What about the Data in the Cells? 3. (08:30) What is Data, Raw Data? 4. (10:01) Understanding the Difference Between Data & Information. 5. (10:45) Define Proper Data Set. 6. (in pdf notes) Why Proper Data Sets are Mandatory. 7. (14:25) Tables are not Charts 8. (14:50) Use Excel Tables For Dynamic Data. Learn about Excel Table Feature. 9. (20:00) Data Types in Proper Data Sets in Various Tools 10. (24:00) How to Sort Data. 11. (26:07) Filtering & Extracting Data. 12. (28:47) Understand & Use AND Logical Tests and OR Logical Tests 13. (34:35) Summary The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 16558 ExcelIsFun
Illustrates how to Add-In the Data Analysis ToolPak in Excel. Excel statistics data analysis toolpak. Check out our brand-new Excel Statistics Text: https://www.amazon.com/dp/B076FNTZCV In the text we cover installing the Data Analysis ToolPak and much more. YouTube Channel: https://www.youtube.com/user/statisticsinstructor
Views: 245937 Quantitative Specialists
Learn how MATLAB can supplement the capabilities of Microsoft Excel. Get a Free Trial: https://goo.gl/C2Y9A5 Get Pricing Info: https://goo.gl/kDvGHt Ready to Buy: https://goo.gl/vsIeA5 Many technical professionals find that they run into limitations using Excel for their data analysis applications. This webinar will show you how MATLAB can supplement the capabilities of Microsoft Excel by providing access to thousands of pre-built mathematical and advanced analysis functions, versatile visualization tools, and the ability to automate your analysis workflows. With MATLAB, you can efficiently explore, analyze, and visualize your data. Through product demonstrations, you will see how to: -Access data from files and Excel spreadsheets -Visualize data and customize figures -Perform statistical analysis and fitting -Generate reports and automate workflows -Share analysis tools as standalone applications or Excel add-ins This session is intended for people who are new to MATLAB. Experienced users may also benefit from the session, as the engineer will be showing capabilities from recent releases of MATLAB including the new ways to store and manage data commonly found in spreadsheets.
Views: 60309 MATLAB
HEY GUYS !!! This Video explains the Use of What If Analysis Tools in Microsoft Excel which include Scenario Manager, Goal Seek and Data Table. If you love the Video, DO HIT THE SUBSCRIBE BUTTON !!!
Views: 21337 Study Help For All
One of my viewers asked for my help in creating an Executive Summary Report - because her manager will not allow her to use a Pivot Table. Here are the tips and techniques that I demonstrate in this lesson: 1) Use Excel's Advanced Filter to Extract a list of unique customer names from a filed with over 4,000 records. 2) Convert a normal range of data cells into an Excel 2007 / 2010 Table (as a List in Excel 2003) - so that range references will update automatically when you append records. 3) Create Named Ranges of Cells that you can use in Formulas & Functions. 4) Use the SUMIF, AVERAGEIF and COUNTIF Functions in the Summary Report. I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video tutorials. Danny Rocks The Company Rocks
Views: 1130624 Danny Rocks
Want all of our free Microsoft training videos? Visit our Learning Library, which features all of our training courses and tutorials at http://learn.infiniteskills.com?utm_source=youtube&utm_medium=youtube_video_description&utm_campaign=microsoft_excel_pivot_tables_creating_pivot_tables_quick_analysis_tool&network=youtube More details on this Microsoft Excel - Pivot Tables training can be seen at http://www.infiniteskills.com/training/microsoft-excel-pivot-tables-in-depth.html?utm_source=youtube&utm_medium=youtube_video_description&utm_campaign=microsoft_excel_pivot_tables_creating_pivot_tables_quick_analysis_tool&network=youtube. This clip is one example from the complete course. For more free Microsoft tutorials please visit our main website. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
Views: 491 O'Reilly - Video Training
Download file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create an interactive dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac. Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks
Views: 2126436 MyOnlineTrainingHub
Excel 2016 training video on how to quickly analyze a range of selected cells by using the Quick Analysis Tool, which includes shortcuts to: Formatting, Charts, Totals, Tables and Sparklines. All 160 of my Excel 2016 training videos contain everything you need to help pass both the Microsoft Office Excel 2016 Core (77-727), and Expert (77-728) exams and become certified! PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007. New videos will be constantly uploaded to Patreon so you will get new content: Visit and sign up at: https://www.patreon.com/KirtKershaw DVD & DOWNLOAD AVAILABLE: https://www.DreamForce.us SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts! http://www.youtube.com/subscription_center?add_user=videotrainingpro LET'S CONNECT! -- http://www.facebook.com/KirtKershaw -- http://www.linkedin.com/in/kirt-kershaw-33874410
Views: 2678 Kirt Kershaw
It is easy to quantify survey data when it is multiple choice You can use a pivot table to figure out what percentage each answer has But what about free-form text answers? These are hard to process if you have hundreds or thousands of them. Sentiment Analysis is a machine-based method for predicting if an answer is positive or negative. Microsoft offers a tool that does Sentiment Analysis in Excel - Azure Machine Learning. Traditional sentiment analysis requires a human to analyze and categorize 5% of the statements. Traditional sentiment analysis is not flexible - you will rebuild the dictionary for each industry. Excel uses MPQA Subjectivity Lexicon (read about that at http://bit. ly/1SRNevt) This generic dictionary includes 5,097 negative and 2,533 positive words Each word is assigned a strong or weak polarity This works great for short sentences, such as Tweets or Facebook posts It can get fooled by double-negatives To install, go to Insert, Excel Store, search for Azure Machine Learning Specify an input range and two blank columns for the output range. The heading for the input range has to match the schema: tweet_text Companion article at: http://sfmagazine.com/post-entry/may-2016-excel-sentiment-analysis/
Views: 5580 MrExcel.com
Learn how to access Quick Analysis tools in this Microsoft Office Excel 2013 training video. Contact K Alliance for more info. http://www.kalliance.com/ - 1.800.330.9111 Featured Instructor - Sheri Tingle Course Duration: 16 Hours 43 Minutes Link to Course: http://www.kalliance.com/desktop/microsoft/office/excel/2013/ Course Catalog: http://www.kalliance.com/catalog/ Request Your 7 Day Trial: http://www.kalliance.com/trial/ Twitter: https://twitter.com/#!/K_Alliance Facebook: https://www.facebook.com/KAllianceTraining Microsoft Office Excel 2013: New Features table of contents: 1.1 Importing Data into Excel 1.2 Exporting Data from Excel 1.3 Protecting Worksheets and Workbooks 1.4 Creating Surveys Using SkyDrive 1.5 Posting Spreadsheets to Social Networks 1.6 Recording and Running a Macro 1.7 Importing Data as a Table or Pivot Table Report 1.8 Using the Ribbon and Locating the Backstage 1.9 Setting up the Page Layout 1.10 Letting the Sum Button do the Math for You 1.11 Editing Formulas and Functions 1.12 Accessing Quick Analysis Tools 1.13 Removing Duplicate Records 1.14 Linking Data Between Worksheets 1.15 Adding Chart Titles and Legends 1.16 Sharing Workbooks
Views: 15948 K Alliance
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.xlsx Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.pdf This video introduces the topics that will be covered in this Highline College BI 348 Class: Name of Class: BI 348 – Microsoft Power Tools for Data Analysis: • Power Query • Power Pivot • DAX • Power BI Desktop • Excel For Creating: • Data Models, Reports, Dashboards and Analytics Taught by Mike excelisfun Girvin, Excel MVP 2013-2018 • A class about connecting to multiple source of data, transforming the data into a refreshable & dynamic data model, and building reports and dashboards to provide insightful and actionable information. Prerequisites for this class: • Busn 216: Excel Basics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k • Busn 218: Advanced Excel, https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw • Busn 210: Business Statistics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj What Version of Excel: • Office 365 (updated each month) What Version of Power BI Desktop: • Free Tool we will download (update each month) Over View of Topics for the class: 1. Data Analysis / Business Intelligence terms and concepts that we will learn in this class: • Proper Data Set • Fact Table • Dimension Tables • Relationships • Star Schema • ETL • Measures • Dashboards • SQL • Data Warehousing 2. Learn how to use Excel Power Query: • Import Data from multiple sources • Clean and Transform Data • Create Data Components for Star Schema Data Models • Load Data To Excel, the Data Model and Connection Only • Replace Complicated Excel Solutions with Power Query Solution • Use the Power query User Interface to create Power Query Solutions • Learn about the Case Sensitive, Function-based M Code Language that is behind the scenes in Power Query 3. Learn how to use Excel Power Pivot: • Excel Power Pivot provides: i. Data Model where we can have multiple tables, formulas and relationships (Star Schema) ii. Columnar Database to hold "Big Data" and process quickly over that "Big Data" iii. New Formula Language called DAX: 1. Many More Calculations than in Standard PivotTable 2. Build One Formula that can work in many reports 3. Add Number Formatting to Formulas • Excel Power Pivot to: i. Replace VLOOKUP Formulas and Single Flat PivotTable Data Source with Multiple Tables, Relationships in the Data Model to create more efficient Reports & Dashboards ii. Use Power Pivot Columnar Database to hold millions of rows of data iii. DAX formulas have more Power than Standard PivotTable Calculations 4. Learn about Building Star Schema Data Models: a. Why they are important in Power Pivot and Power BI Desktop b. How to build them using: i. Power Query ii. Power Pivot iii. DAX iv. Power BI Desktop 5. Learn how to author DAX Formulas for Excel’s Power Pivot & Power BI Desktop: a. Calculated Column Formulas for Data Model b. Measure Formulas for PivotTables c. DAX Functions like SUMX, CALCULATE, RELATED, and Much More… d. Lean why we must create Explicit rather than Implicit formulas e. Learn how Row Context works in formulas f. Learn how Filter Context works in formulas g. Learn about Scalar & Table Functions h. Use DAX Studio to visualize and analyze DAX Formulas 6. Learn how to use Power BI Desktop: a. Power Query to import, clean, transform and create Star Schema Data Models b. Create Relationships c. Create DAX Formulas d. Build Interactive Visualizations e. Build Dashboards 7. Learn how to use Excel: • Spreadsheet Formulas & Functions • Standard PivotTables • Power Query • Power Pivot • Build Data Model PivotTables and the resultant Reports, Dashboards and Analytics 8. Building Refreshable, Insightful Dashboards a. Build Excel Dashboards b. Build Power BI Dashboards 9. Case Studies to practice using Power Pivot & Power BI Desktop for Reporting, Building Dashboards and Building Business Analytics Solutions The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 33572 ExcelIsFun
Download Excel Files: Start File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcel.xlsm Finished File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcelFinished.xlsm Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm See how to Install Data Analysis Add-in using Excel Options and the Add-in Feature. This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin
Views: 228443 ExcelIsFun
Create as many "what-if" analysis scenarios as you wish - with just one formula! In this video lesson, you will learn how to set up a 2-input data table to find multple possible monthly loan payments. We are basing this on the =PMT() function. To see all of my video lessons I invite you to visit my website - http://thecompanyrocks.com/excels
Views: 90074 Danny Rocks
Learn the basics of Excel, one of the most popular data analysis tools, to help visualize and gain insights from your data. Take this course free on edX: https://www.edx.org/course/introduction-data-analysis-using-excel-microsoft-dat205x#! ABOUT THIS COURSE The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data. Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards. You don’t need any previous knowledge of Excel to take this course and you are welcome to use any supported version of Excel you have installed in your computer. After taking this course you’ll be ready to continue to our more advanced Excel course, Analyzing and Visualizing Data with Excel. WHAT YOU'LL LEARN - Create flexible data aggregations using pivot tables - Represent data visually using pivot charts - Calculate margins and other common ratios using calculation on pivot table - Filter data using slicers in multiple pivot tables - Create aggregate reports using formula based techniques
Views: 17210 edX
Download Excel Files: Start File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcel.xlsm Finished File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcelFinished.xlsm Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm See two of Excel's great Data Analysis tools: Sorting and Pivot Tables (PivotTables). This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin
Views: 42560 ExcelIsFun
This is an introduction to using Pivot Tables (or PivotTables) in Microsoft Excel. It works in Excel 2003, 2007, 2010, and 2013.
Views: 2294646 Jon Flynn
See how to create a Frequency Distribution, a Cumulative Freqency Distribution, a Histogram Chart and an Ogive Chart with the Data Analysis Add-in. Chapter 02 Busn 210 Business and Economic Statistics and Excel Class This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin
Views: 157314 ExcelIsFun
Direct links to file: START FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20Seminar-StartFileSoYouCanFollowAlong.xlsx FINISHED FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20SeminarAllFinishedExamplesAfterVideoDone.xlsm Keyboards 0:01:47 Jump: Ctrl + Arrow 0:02:20 Go To Cell A1: Ctrl + Home 0:02:36 Format Cells dialog box or in a chart Format Chart dialog box: Ctrl + 1 0:03:40 Currency Number Format: Ctrl + Shift + 4 0:04:08 Highlight column: Ctrl + Shift + Arrow0:04:20 Currency Vs Accounting Number Format 0:05:00 Alt keys: 0:05:47 PivotTable: Alt, N, V, T 0:05:47 PivotTable 2003: Alt, D, P 0:05:47 Page Setup: Alt, P, S, P 0:05:47 SUM: Alt + = 0:08:38 "Put thing in cell and move selected cell up": Shift + Enter 0:09:35 "Put thing in cell and keep cell selected": Ctrl + Enter 0:09:35 Select sheet to right: Ctrl + PageDown 0:11:11 Select sheet to left: Ctrl + PageUp 0:11:11 Number Formatting As Façade: 0:11:52 Decimal Number Format 0:12:38 Date Number Format 0:13:56 Keyboard for today's hard caded date: 0:13:56 Time Number Format 0:17:10 Percentage Number Format 0:21:25 Efficient Formula Creation 0:25:01 Excel's Golden Rule: If a formula input can vary, put it in a cell and refer to it in the formula with a cell reference 0:25:01 Formula elements, types of formulas, types of data 0:25:01 Monthly Allocation Formula: illustrate formula input that can be hard coded into formula 0:27:00 Tax (inefficient formula): illustrate formula input that can should NOT hard coded into formula 0:27:35 Tax (efficient formula): illustrate Golden Rule 0:27:35 Net Cash In formula: illustrate Golden Rule 0:27:35 Net Income formula: illustrate formula with built-in function within a larger formula 0:30:00 In Balance? formula: illustrate Logical formula 0:30:40 First & Last Name Join Formula: illustrate Text formula 0:31:54 COUNTIF formula: illustrate counting with criteria 0:33:29 COUNTIF & Label formula: illustrate counting with criteria and how the join symbol is used with criteria 0:34:19 Clear Formatting 0:35:50 SUMIFS to add with two criteria 0:36:21 SUMIFS to add between 2 dates 0:38:08 Count workdays formula to illustrate new Excel 2010 function NETWORKDAYS.INTL 0:41:46 Relative and Absolute Cell References 0:41:46 Mixed cell references in budget formula 0:43:58 Lookup Formulas 0:49:50 VLOOKUP to lookup product price: illustrate Exact Match lookup 0:49:50 Data Validation List: 0:53:10 VLOOKUP and IFERROR 0:55:13 VLOOKUP to lookup commission rate: illustrate Approximate Match lookup 0:56:45 Retrieve record (2-way lookup) with VLOOKUP and MATCH 0:59:53 MATCH, ISNA and ISNUMBER functions to compare 2 lists 1:03:38 INDEX and MATCH to lookup Left 1:07:00 Pivot Tables 1:10:02 Proper Data Set 1:10:02 PivotTables Pivot Tables are Easy 1:12:00 Visualize Table First 1:12:00 Adding with One or Two Conditions (Criteria) 1:12:00 Report Layout 1:16:58 Number Formatting 1:17:44 Style Formatting, Create Your Own 1:19:05 Pivoting 1:21:21 Listing Two Fields in Row Labels 1:21:21 Collapsing Pivot Table Row 1:21:59 Changing Calculation: SUM to AVERAGE 1:22:42 Adding with Three Criteria 1:23:29 Filtering a Row (Show Top Two Regions), Clear Filter 1:24:46 Filter whole report with Report Filter 1:25:55 Show Report Filter Pages (30 PivotTables with 1 click) 1:27:55 Filter whole report with Report Filter or Slicer 1:28:30 Compare Formulas and PivotTables 1:30:13 Grouping Dates in PivotTables 1:33:42 Difference between Grouping Integers and Grouping Decimals 1:35:41 Pivot Chart 1:39:00 Show Values As: 1:40:45 Copy PivotTable 1:41:43 Running Totals & % Running Totals 1:42:00 % of Grand Totals, % of Column Total, % of Row Total 1:43:01 Difference From, % Difference From 1:44:17 Multiple Calculation in one PivotTable 1:46:26 Creating Second PivotTable from Second Cache of data using Excel 2003 keyboard shortcut for 3-step Wizard 1:47:54 Blank in number field causes PivotTable to Count by Default 1:49:30 Text in Date field prohibits Grouping of Dates 1:50:09 Recorded Macros For Reports: Basic Recorded Macro 1:51:05 Absolute References and save in Personal Workbook 1:55:10 How to trick the Macro Recorder into seeing a variable height report using Relative References 2:00:51 Rearrange records from vertical orientation to proper table using Relative References 2:09:01 Charts 2:13:35 Chart Types 2:13:35 Column Chart and How The Chart Wizard Interprets Data From Cells 2:17:48 Chart keyboards (Create Default Chart) 2:18:10 Select Data Source Dialog Box 2:20:30 Linking Chart Title to Cells 2:23:09 Saving Chart Templates 2:25:43 Setting Default Charts 2:26:48 Copy Charts 2:27:45 Bar and Stacked Bar charts 2:27:57 Line Chart & Change Source Data 2:31:39 Number Formatting to show "K" or "M" 2:34:52 Line Chart vs. X Y Chart 2:35:53 X Y Scatter 2:36:45 X Y Scatter Line Break Even Analysis Chart 2:41:28 Multiple chart types 2:42:42
Views: 3497618 ExcelIsFun
Quick look at the Sort and Filter group within the DATA Excel ribbon tab. How to Sort and Filter a table worth of data be sure to learn more on the Data Analysis Tools in Excel here: http://www.analystcave.com/excel-data-analysis-excel-tools/
Views: 325 AnalystCave
Excel is a powerful tool but its usefulness can be expanded even further with the use of a data analysis tool Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial will show you how to get excel data analysis tool which can greatly expand the functionality of Excel. Step # 1 -- Open Options Start Excel and click on the "File" button in the top left hand corner. This will present you with a menu and you need to click on "Options". The "Excel Options" window will then load. Step # 2 -- Accessing Add-Ins Settings In this window you need to navigate to the "Add-Ins" option in the left hand menu. This will provide you with a list of all the available add ins for Excel. At the bottom there is a button called "Go...", click on this. This will open the "Add-Ins" window. Step # 3 -- Locating Data Analysis This window will give you several checkbox options. You need to click in the checkbox next to the "Analysis ToolPak" option then click "OK". That is essentially how to get excel data analysis tool and to access it you need to navigate to the "Data" tab and you will see a new box called "Analysis" and within it the "Data Analysis" option.
Views: 131455 Excel, Word and PowerPoint Tutorials from Howtech
View this demo to see how to use the What-If Data Table in Microsoft Excel. Want to see more tech tutorials? Subscribe to the Learning Tree Tech Tips and Tricks playlist: https://www.youtube.com/playlist?list=PLXrVfv7YnPHvbMWTl_91n645Me9E83rjo SUBSCRIBE to the LearningTree YouTube channel: https://www.youtube.com/learningtree Additional ways to get latest tech industry news: -Subscribe to blog: https://www.blog.learningtree.com -Follow on Twitter @LearningTree -Follow on LinkedIn https://www.linkedin.com/company/learning-tree-international -Like on Facebook https://www.facebook.com/LearningTreeIntl/ For more training, visit https://www.learningtree.com/ Learning Tree is recognized as Top 20 IT Training Company for 2016. From single courses to large enterprise solutions, Learning Tree can help your organization overcome skills gaps and accomplish individual and organization objectives.
Views: 8520 Learning Tree International
See how to use a Data Table for 1 variable for what if analysis. See the PMT function. See the Formula equivalent to a Data Table. Other What If Analysis videos: Excel Magic Trick 253: Data Table 1 Variable What If Analysis Excel Magic Trick # 254: Data Table Creates 100 Formulas Excel Magic Trick 255: Data Table 2 Variable What If Analysis YTLE#103: Excel Goal Seek Highline Excel Class 22: Scenarios & Scenarios Report This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Views: 66625 ExcelIsFun
Using the Rank & Percentile function on Data Analysis ToolPak.The data set used can be downloaded from http://www.learnanalytics.in/blog/wp-content/uploads/2013/04/car_sales.xlsx
Views: 13895 Learn Analytics