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: 1533120 ExcelIsFun
Hi There! I am excited to present a 5 part Live Video Series on Youtube for Data Analysis Series. In this Live video series, I would be teaching 1 video every Wednesday at 1:30 pm for 30 minutes and will also take answer your questions in that time. The 1st Live series will be done on 7th of September at 1:30 pm , India Time, in Hindi and the topic is How To Use Pivot table for Data Analysis in Excel 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU
Views: 2215 My E-Lesson
Key Takeaways for the session : Breaking junk using formula and generate reports VBA to manipulate data in required format Data extraction from external files Who should attend? People from any domain who work on data in any form. Good for Engineers, Leads, Managers, Sales people, HR, MIS experts, Data scientists, IT Support, BPO, KPO etc. Feel free to write me at [email protected]
Views: 24541 xtremeexcel
Learn what a Pivot Table is, what it can do, and how to use one to manipulate data in this tutorial. http://www.trainsignal.com/Office-2010-Training-Package.aspx?utm_source=YouTube&utm_medium=Social%20Media&utm_campaign=YouTubeOffice%20Referral&utm_content=excel%202010
Views: 2704 TrainSignal is now Pluralsight
Pivot tables let you analyze large amounts of data using a variety of functions. Excel 2013 makes it easy to create a new pivot table that suits your needs. Pivot tables let you summarize data without the hassle of creating formulas.
Views: 67344 fordummies
Pivot Table Example | Sales Data In this video, we have explained the Sales Data Analysis using Pivot Table in Excel and How to use Text formula and How to use a Sparkline in Excel. To watch more videos and Download that files at https://goo.gl/XHgHU4 Enroll our FREE Course at https://courses.yodalearning.com/p/free-office-2016-tips Keep yourself updated. Follow us now! Like us on https://www.facebook.com/yodalearning Tweet us on https://www.twitter.com/yodalearning Follow our boards at https://in.pinterest.com/yodalearning/pins/
Views: 4144 Excel Yoda learning
Pivot tables In Excel are great time savers if you know how to use them. In this comprehensive video Guruji introduces you to Pivot tables in the easiest possible manner. 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU To watch more videos and download the files visit : http://www.myelesson.org To Buy a Excel Course DVD visit : http://bit.ly/1CgLhku Subscribe to the channel : http://bit.ly/1tpIjXZ Like us on Facebook : http://www.facebook.com/excelmadeasy Follow us on Twitter : https://twitter.com/Excelmadeasy" 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU
Views: 683699 My E-Lesson
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: 170911 ActivePlanner
Check out my Blog: http://exceltraining101.blogspot.com This video shows how to create a 3D Table Cube. P.S. Feel free to provide a comment or share it with a friend! ---------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 71969 Doug H
Learn how Power Pivot simplifies data analysis. Topics include: multiple tables and relationships, editable linked tables, DAX formulas, custom calendars, and measure concepts, with a focus on demonstrating each of these capabilities. Follow us on Twitter - https://twitter.com/mspowerbi More questions? Try asking the Power BI Community @ https://community.powerbi.com/
Views: 13044 Microsoft Power BI
In this video, Billy Decker of StatSlice Systems shows you how to start data mining in 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a set of predictions for new customers using a Logistic Regression models based upon old customers. For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: https://dataminingaddins.codeplex.com/releases/view/87029 *This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Views: 21509 StatSlice Systems
Sorting data is an integral part of data analysis. You might want to put a list of names in alphabetical order or compile a list of product inventory levels from highest to lowest. Sorting data enables you to quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. To help you locate the data that you want to analyze in a PivotTable or PivotChart more easily, you can sort text entries (from A to Z or Z to A), numbers (from smallest to largest or largest to smallest), and dates and times (from oldest to newest or newest to oldest). When sorting data in a PivotTable report, you should be aware that: Data such as text entries may have leading spaces that affect the sort results. For optimal sort results, you should remove any spaces before you sort the data. Unlike sorting data in a range of cells on a worksheet or in an Excel table, you cannot sort case-sensitive text entries. You cannot sort data by format, such as cell or font color, or by conditional formatting indicators, such as icon sets. watchistan,excel,pivot tables,using pivot tables in qlikview,practice using pivot tables,how to use pivot tables to analyze data,what does a pivot table do,chart from two pivot tables,pivot chart from multiple pivot tables,pivot chart from 2 pivot tables,pivot tables with multiple worksheets,pivot table chart templates,two pivot tables one chart,pivot chart from pivot table,pivot chart scatter plot,pivot chart line graph
Views: 235 Watchistan
In this video, you will see how to do some basic data analysis with Microsoft Excel. You'll see how to use various functions and get an introduction to use pivot tables Data source: https://www.kaggle.com/c/titanic/data Please comment if you want such set of videos. Cheers!
Views: 3246 Windows Tech Channel
Several viewers asked me to demonstrate some other ways to -Group a Field- in a Pivot Table. In this tutorial, I show you how to create a Frequency Report by Age Bracket. Before I start the Pivot Table Demonstration, I show you how to calculate someone's age using the -undocumented- =DATEDIF() Function in Excel. In the Pivot Table, I change the result from -Summarize Values By- to the -Show Vales As- setting. Finally, I apply Conditional Formatting to the Pivot Table. I invite you learn more about my Pivot Table Video Tutorials. Visit my secure, online, shopping website - http://shop.thecompanyrocks.com Danny Rocks The Company Rocks
Views: 168121 Danny Rocks
(It's best to view this "Large" rather than the small default window") In this video we see an example of using dummy or bogus data. Often we get data sets that are hard to work with because it's got Employee IDs, Part Numbers, or other strings of characters that aren't easily comprehensible. I show how I often convert data like this into names of fish. As part of the process, we see a pivot table and a VLOOKUP. NOTE: my tutorials are still a bit crude. Hopefully they're improving. :-)
Views: 5512 Excel On Fire
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #20 Video topics: 1)PivotTables Pivot Tables Basics 2)Most Powerful Excel feature for summarizing data 3)Summarize Data Quickly 4)Group By Date 5)Format Fields 6)Format Pivot Table 7)Pivot the table 8)See Pivot Tables in Excel 2003 and Excel 2007 9)Page Filter 10)Show Page Filter 11)Report Filter 12)Show Report Filter
Views: 396172 ExcelIsFun
Learn how to manipulate PivotTable data in Excel. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Manipulating-PivotTable-data/116478/125087-4.html?utm_campaign=XRXkz5B3i-Y&utm_medium=social&utm_source=youtube-earned This tutorial is from the Excel 2013 Essential Training course presented by lynda.com author Dennis Taylor. In the complete course, find out how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Connect with lynda.com: Facebook: http://bit.ly/fbldc Twitter: http://bit.ly/ldctw Google Plus: http://bit.ly/gplusldc LinkedIn: http://bit.ly/linkldc
Views: 7564 LinkedIn Learning
Create Pivot Table report in Excel by connecting SQL Server My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 3736 SQL with Manoj
Right, let’s summarize what we have seen so far in this exercise. We started working with a raw SAP extraction in Excel. We carried out a mapping exercise and obtained two new columns – one containing months and another one showing years. Then, we were able to build a structure based on the data we had in our extraction and on what we wanted to show in the report we are building. After that, we formatted the output sheet nicely and added the necessary formulas that will calculate subtotal, total, absolute and percentage variances, etc. Finally, we inserted a Pivot Table that will allow us to extract the necessary numbers. The next two lessons will make working with Pivot Tables so much more valuable for you! Our goal here is to extract the data from the Pivot Table and populate the cells of the output sheet. Let’s start by filling the first cell in the report – Volume for 2015. I’ll link to one of the cells of the Pivot Table that we already have. We already know how GetPivotData works. The first argument shows the field for which we are extracting data. In this case, we are extracting data for Volumes. The second argument, which in this case is the cell A3, is the first cell of the Pivot Table to which we are linking. And then, all of the other arguments of the function give us directions to which cell exactly in the Pivot Table we are linking. Let’s take a look at the formula while we are in the sheet containing our Pivot Table. We have “Month” equal to 1, meaning we are extracting volume data for January. The year is 2015 and the brand is Buratino. You can see how easy it is to understand this formula. Each of the names has an easy to understand meaning. Sometimes, we can even work with this function without looking at the source sheet. And this is simply great, as it reduces the likelihood of mistakes significantly. But, that’s not everything. We can substitute each of these hard inputs with a reference. And this is when GetPivotData becomes awesome! For example, I will type 2015 in this row here and will then replace the hard input with a reference to this cell and everything will remain as it was, before we made the replacement. This is how we can make the function flexible and re-use it for the rows and columns in the entire table. I will simply type 2016 on the right. Copy and paste the function to the right. And this will provide us the volume in 2016. Very well. But wait, these are not the volumes of all the firms we want to show here, but just the ones for the Buratino brand. If we erase this criterion, we will stop specifying we are looking for a particular brand and Excel will provide us with the sales volume of the entire company. And in the same way, we need to eliminate the “month” field, as right now, the formula extracts volumes only for January. I’ll erase these two parameters of the function. Ok. So this is the volume of sales of the entire firm in 2015. As we have already specified the numbers are in thousands, let’s divide this figure by 1000. It will look much neater. All right. The question is: are we going to be able to paste this function in all blank cells that have to be filled in this report? The answer is that we are not ready to do that … yet. I’ll need to fix the row reference of the “Year” item, which will prevent it from changing its location when pasting the function downwards. The other thing that needs to be taken care of is the fact we still have one hard input at the beginning of the function – its first argument, which reads “Sum of Volume”. We need to find a way to allow us to change this argument for each of the rows we have below. So, for example, when we paste the function in the row below, the first argument will have to be “Sum of Gross Sales”. …because this is how it is named in the Pivot Table from which we are extracting data. So, why don’t we substitute this bit with an “&” function? I can separate the first part with parentheses, which indicate this is text and then add the & function and link to the cell B6. ………..…And here’s the proof that this approach functions. The first argument of the function will change dynamically when we paste it downwards and to the right. However, we forgot to add a dollar sign in front of the column reference of this argument. Without the dollar sign in front of it, it will change its column position when pasting to the right. I’ll add the dollar sign now. All right, perfect. Now we can paste the function for all blank cells in our report. GetPivotData is truly great, isn’t it?
Views: 22226 365 Careers
http://www.lynda.com/home/DisplayCourse.aspx?lpk2=55762&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports.
Views: 3568 LinkedIn Learning
Business Analytics with excel training has been designed to help initiate you to the world of analytics. For this we use the most commonly used analytics tool i.e. Microsoft Excel. The training will equip you with all the concepts and hard skills required to kick start your analytics career. If you already have some experience in the IT or any core industry, this course will quickly teach you how to understand data and take data driven decisions relative to your domain using Microsoft excel. Data Science Certification Training - R Programming: https://www.simplilearn.com/big-data-and-analytics/data-scientist-certification-sas-r-excel-training?utm_campaign=Data-Excel-W3vrMSah3rc&utm_medium=SC&utm_source=youtube For a new-comer to the analytics field, this course provides the best required foundation. The training also delves into statistical concepts which are important to derive the best insights from available data and to present the same using executive level dashboards. Finally we introduce Power BI, which is the latest and the best tool provided by Microsoft for analytics and data visualization. What are the course objectives? This course will enable you to: 1. Gain a foundational understanding of business analytics 2. Install R, R-studio, and workspace setup. You will also learn about the various R packages 3. Master the R programming and understand how various statements are executed in R 4. Gain an in-depth understanding of data structure used in R and learn to import/export data in R 5. Define, understand and use the various apply functions and DPLYP functions 6. Understand and use the various graphics in R for data visualization 7. Gain a basic understanding of the various statistical concepts 8. Understand and use hypothesis testing method to drive business decisions 9. Understand and use linear, non-linear regression models, and classification techniques for data analysis 10. Learn and use the various association rules and Apriori algorithm 11. Learn and use clustering methods including K-means, DBSCAN, and hierarchical clustering Who should take this course? There is an increasing demand for skilled data scientists across all industries which makes this course suited for participants at all levels of experience. We recommend this Data Science training especially for the following professionals: IT professionals looking for a career switch into data science and analytics Software developers looking for a career switch into data science and analytics Professionals working in data and business analytics Graduates looking to build a career in analytics and data science Anyone with a genuine interest in the data science field Experienced professionals who would like to harness data science in their fields Who should take this course? There is an increasing demand for skilled data scientists across all industries which makes this course suited for participants at all levels of experience. We recommend this Data Science training especially for the following professionals: 1. IT professionals looking for a career switch into data science and analytics 2. Software developers looking for a career switch into data science and analytics 3. Professionals working in data and business analytics 4. Graduates looking to build a career in analytics and data science 5. Anyone with a genuine interest in the data science field 6. Experienced professionals who would like to harness data science in their fields For more updates on courses and tips follow us on: - Facebook : https://www.facebook.com/Simplilearn - Twitter: https://twitter.com/simplilearn Get the android app: http://bit.ly/1WlVo4u Get the iOS app: http://apple.co/1HIO5J0
Views: 26507 Simplilearn
A common task for scientists and engineers is to analyze data from an external source. By importing the data into Python, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. See http://apmonitor.com/che263/index.php/Main/PythonDataAnalysis
Views: 166846 APMonitor.com
Interactive Dashboards with multiple pages in R. Data File: https://goo.gl/7PLsYx R Markdown File: https://goo.gl/a1bHYK Includes, - Interactive plots - Interactive data tables - Interactive pivot tables - Interactive geographic plots R is a free software environment for statistical computing and graphics, and is widely used by both academia and industry. R software works on both Windows and Mac-OS. It was ranked no. 1 in a KDnuggets poll on top languages for analytics, data mining, and data science. RStudio is a user friendly environment for R that has become popular.
Views: 9954 Bharatendra Rai
The Excel Data Mining Addin can be used to build predictive models such as Decisions Trees within Excel. The Excel Data Mining Addin sends data to SQL Server Analysis Services (SSAS) where the models are built. The completed model is then rendered within Excel. I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 73909 Steve Fox
This video lesson fully explains the concepts of Business Intelligence, OLAP, MDX and and how they apply to Excel 2013. At http://ExcelCentral.com you can view over 850 free Excel video lessons just like this one. All in full HD with vari-speed and human-transcribed subtitles providing the perfect Excel learning environment. You can also track your progress through the course and print a certificate upon completion. Separate videos are provided for Excel 2007, Excel 2010 and Excel 2013. The lesson begins with an explanation of OLAP and its purpose. You'll learn about OLAP Cubes and how they are divided into Dimensions, Measure and Hierarchies to create a multidimensional data structure. You'll also learn about how the MDX query language is used to extract values from OLAP cubes. This lesson also explains the concept of Business Intelligence and how it applies to OLAP. This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills free video training course). This session includes the following video lessons: ▪ Lesson 6-1: Understand primary and foreign keys (11m 27s) http://excelcentral.com/excel2013/expert/lessons/06010-understand-primary-key-foreign-key-relationships.html ▪ Lesson 6-2: Create a simple data model (6m 31s) http://excelcentral.com/excel2013/expert/lessons/06020-create-a-simple-data-model.html ▪ Lesson 6-3: Understand OLAP, MDX and Business Intelligence (10m 17s) http://excelcentral.com/excel2013/expert/lessons/06030-what-is-business-intelligence-and-an-olap-cube.html ▪ Lesson 6-4: Use the GETPIVOTDATA function (4m 31s) http://excelcentral.com/excel2013/expert/lessons/06040-use-the-getpivotdata-function.html ▪ Lesson 6-5: Use the CUBEVALUE function to query an OLAP cube (5m 40s) http://excelcentral.com/excel2013/expert/lessons/06050-use-the-cubevalue-function-to-query-an-olap-cube.html ▪ Lesson 6-6: Convert CUBEVALUE functions to include MDX expressions (5m 48s) http://excelcentral.com/excel2013/expert/lessons/06060-convert-cubevalue-functions-to-include-mdx-expressions.html ▪ Lesson 6-7: Understand OLAP pivot table limitations (10m 52s) http://excelcentral.com/excel2013/expert/lessons/06070-understand-olap-pivot-table-limitations.html ▪ Lesson 6-8: Create an asymmetric OLAP pivot table using Named Sets (4m 57s) http://excelcentral.com/excel2013/expert/lessons/06080-create-an-asymmetric-olap-pivot-table-using-named-sets.html ▪ Lesson 6-9: Understand many-to-many relationships (11m 5s) http://excelcentral.com/excel2013/expert/lessons/06090-understand-many-to-many-relationships.html ▪ Lesson 6-10: Create an OLAP pivot table using a many-to-many relationship (12m 47s) http://excelcentral.com/excel2013/expert/lessons/06100-create-an-olap-pivot-table-using-a-many-to-many-relationship.html You can watch any of the 850 Excel video lessons, free and without any required registration at http://excelcentral.com/excel2013/expert/tutorials/default.html.
Views: 243108 ExcelCentral.com
IMPORTANT: This tutorial was published on 09/02/2015. If you are using DevExpress libraries released after this date, you may notice slight differences in the Visual Studio design-time experience, product API, and user experience. Please refer to the DevExpress online help system for up-to-date information on all DevExpress libraries. In this video we'll cover all the basics of customizing the ASP.NET MVC PivotGrid extension from adding the extension into a project to the overview of the Pivot Grid features. To learn more, see https://documentation.devexpress.com/#AspNet/CustomDocument18054
Views: 7627 DevExpress
http://www.contextures.com/xlPivot07.html Visit this page to download the sample file, and for written instructions. In a pivot table, it is easy to group fields that contain dates or numbers. However, if you right-click on a text field's item, the Group command does not work. First, you have to manually select the text items that you want to group, and then use the Group command. After grouping, the group name can be changed, and you can add more items to the group. If you no longer need them, you can ungroup one or more of the groups.
Views: 37237 Contextures Inc.
Purchase the spreadsheet (formulas included!) that's used in this tutorial for $5: https://gum.co/satisfactionsurvey ----- Soar beyond the dusty shelf report with my free 7-day course: https://depictdatastudio.teachable.com/p/soar-beyond-the-dusty-shelf-report-in-7-days/ Most "professional" reports are too long, dense, and jargony. Transform your reports with my course. You'll never look at reports the same way again.
Views: 365904 Ann K. Emery
Say that you want to report actuals from last year and budget from this year. Regular pivot tables can't do that. Starting in Excel 2010, OLAP pivot tables can do that. But, that doesn't help you if you have regular old Excel data instead of OLAP cubes. However...take your regular Excel data through PowerPivot and it turns into an OLAP Cube! Thus, Named Sets become an option. Chapter 12 makes me want to run every single data set through pivot table. I need to turn back to Chapter 3 to remind myself of why not to do that...
Views: 38381 MrExcel.com
In this workshop, get an introduction to the latest analysis and visualization capabilities in Excel 2016. See how to import data from different sources, create mash/ups between data sources, and prepare the data for analysis. After preparing the data, learn about how business calculations - from simple to more advanced - can be expressed using DAX, how the result can be visualized and shared.
Views: 30564 Microsoft Power BI
More SSIS tutorials at http://www.analyticsinaction.com/category/data-integration/. Demonstration of how to pivot data in SQL Server Integration Services (SSIS). The pivot transformation in SSIS essentially performs the same end result as a pivot table in Excel or a crosstab query.
Views: 18546 Steve Fox
Excel Power BI offers analytics without programming. As a developer you can utilize it to deliver reports and data to end users. Find out how in this 2-hour video tutorial delivered by Dr. Nitin Paranjape, Office MVP and Microsoft Regional Director. Key highlights: - Pivot Table (2:00) - Why use Excel tables (4:56) - Pivot Table - deep dive (15:22) - Slicer (30:00) - Working with Multiple Pivot Table - Data Connection and Global Filter(32:10) - Cleaning up cross-tab data (35:34) - Power Query (41:00) - Certified Query - Sharepoint Data Steward (49:10) - Power Pivot (51:00) - Context-sensitive functions in Power BI (1:02:52) - Browser view options: reduce bandwith and increase performance (1:08:06) - The importance of naming sheets, tables, Pivot table (1:13:10) - Sharepoint versioning explained: Major version and Minor versions (1:15:32) - Conceptual difference between end-user BI and enterprise BI (1:17:19) - New Method of data analysis using Power View (1:19:30) - Scrollbars and slicers right in Power View (1:22:00) - Integrate images into reports and dashboards (1:26:35) - Visualize reports and dashboards in geographical distribution (1:29:22) - Power BI functionality on mobile and tablet devices - Ipad, Android devices (1:36:00) - Power Map (1:40:45) - Plotting data on 3D globe with geographical visualization (1:41:00) Dr. Nitin Paranjape (Office MVP)
Views: 39694 Efficiency 365
Data Analysis with Python for Excel User Part 2: Conditional Index and Pivot with Python and Pandas The previous part: https://youtu.be/CzuwQwI5zk8 In this tutorial we are going to learn how to conduct conditional Index and pivot in excel with python and pandas Python is a widely used high-level, general-purpose, interpreted, dynamic programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than possible in languages such as C++ or Java. The language provides constructs intended to enable writing clear programs on both a small and large scale. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles.It also supports modules and packages, which encourages program modularity and code reuse. The Python interpreter and the extensive standard library are available in source or binary form without charge for all major platforms, and can be freely distributed. Our money manager android app: https://play.google.com/store/apps/details?id=com.leazzy.moneymanagerleazzy
Views: 3037 Peasy Tutorial