excelisfun YouTube home page: https://www.youtube.com/@excelisfun This video given you a tour of the free Excel & Power BI Videos, Classes & Practice Files here on the Home Page of the excelisfun YouTube Channel. You can learn topics such as: Excel Basics Intermediate & Advanced Excel Formulas & Functions Dynamic Spilled Array Formulas Data Analysis PivotTables Power Query Build Models Data Models Power Pivot Power BI DAX Formulas in the Data Model M Code Formulas in Power Query SUMIFS function COUNTIFS function IF Function FILTER Function and Much More! #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #pivottable #dax #mcode #dynamicanalysis #dataanalysis #data #datamodeling #dataanalytics #formulas #functions #powerpivot #powerbi #powerbidesktop #sumifs #countifs #groupby #pivot_table #pivotby #ifformula #iffunction #filterfunction
Our members Thank you, channel members!
This free class teaches you how to use MS 365 Excel to make calculations, preform data analysis, and create any template you will ever need to get the job done! It is taught by Highline College Professor and excelisfun YouTuber (since 2008), Mike Girvin. The great thing about this class is that there downloadable workbooks so that you can follow along, homework so you can practice, and pdf notes that summarize the video. Even though the class is labeled "basic", Mike excelisfun Girvin is famous for teaching you all the important Excel features so you will actually be considered an advanced Excel pro. So have fun and gain power with Excel with this free YouTube class!!
This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike “excelisfun” Girvin. Mike is an Microsoft Excel MVP and a professor at Highline College. You can expect a couple videos each week from June 20, 2022 to August 20, 2022. This class will cover topics such as: 1. Introduction 2. Worksheet Formula Models 3. Data Analysis with PivotTable, Power Query, Data Model, Power BI… 4. Date and Time formulas 5. SUMIFS, COUNTIFS & Conditional Calculations 6. Logical Formulas: Comparative Operators, IF, AND, OR and IS functions 7. Lookup functions: XLOOKUP and FILTER, Data Validation 8. Array Formulas 9. LET and LAMBDA functions 10. Formulas to Build Reports 11. Visualizing Data with Conditional Formatting, Excel Charts and Power BI 12. Dashboards 13. Power Query, to clean, transform and import data 14. M Code 15. DAX 16. Much more
1. Create Formulas to make business calculations 2. Use Excel Functions like VLOOKUP & IF functions to make efficient business calculations 3. Format & create page setup for effective reports and dashboards 4. Understand and use Number Formatting in reports and calculations 5. Use PivotTables to create reports and dashboards 6. Use Sort, Filter and Flash Fill for data analysis tasks 7. Use Power Query to import and clean data 8. Use Power Pivot Relationships to make reports from multiple tables 9. Create charts and visualizations for dashboards 10. Complete comprehensive business tasks integrating multiple Excel features This is a free Excel class taught by Mike Girvin, Microsoft Excel MVP and Highline College Professor. This class will teach you the efficient and effective methods of using Excel so you can became great at using Excel to accomplish all your tasks at work, at home, and so that you can get that job you want that requires Excel skills!!! Excel Basics Playlist of Videos.
1) Develop Effective and Efficient and solutions in Excel. 2) Use Microsoft Excel to solve typical business related problems with an emphasis on: 1) Making effective and efficient numeric, logical and text calculations and 2) effectively and efficiently converting raw data into useful information. 3) Understand Data Analysis and Business Intelligence terms and use data analysis concepts to create useful information from raw data: 4) Understanding the structure of an excel file as: Cells, Worksheets, Sheet Tabs and Workbooks 5) Using keyboards to accomplish tasks quickly 6) Understand and Utilize Number Formatting as Façade 7) Use Style Formatting, Number Formatting and Page Setup to present information in an effect way. 8) Use Proper Data Sets and correct Data Types to leverage Excel’s full capabilities 9) Create Effective and Efficient Formulas that can make numeric, logical and text calculations and perform data analysis, including extensive coverage of types of formulas, formula elements, lookup formulas, array formulas and much more. 10) Preform Data Analysis and Business Intelligence with Excel’s Built in Data Analysis feature such as Sort, Filter, Power Query, PivotTables and Power Pivot. Learn the concepts and techniques for how to importing, clean and transform data from multiple sources in order to build refreshable reports, dashboards and other data analysis outputs. 11) Automate tasks using Recorded Macros and VBA from the Internet: 12) Use Finance Functions, Statistical Functions and Rounding functions to make specific calculations If you are watching videos to learn all about Excel, watch Excel Basics Playlist, first, then watch the Highline Excel 2016 Class, second.
1. Overview of all tools and concepts in the class. 2. Define Data Analysis and Business Intelligence. 3. Learn about the correct structure for data that enables efficient Data Analysis 4. Use Excel Spreadsheet Formulas and Functions to create reports. 5. Use Standard PivotTables to create reporting and dashboard solutions. 6. Create Visualizations using tables, charts, conditional formatting and dashboards. 7. Use Power Query to import, clean, transform and then load the data for use in reporting and dashboarding. 8. Create Data Models using VLOOKUP, Power Query and Power Pivot Relationships. 9. Use Power Query, Power Pivot and DAX Formulas to import Big Data from a SQL database to build dashboards. 10. Use Power BI Desktop to convert Big Data into interactive visualizations for reports and dashboards. 11. Upload and share Excel and Power BI reports to Power BI Online. 12. Build efficient and effective reports and dashboards that contain refreshable and sharable reports, visualizations and analytics. E-DAB Description We will use the Microsoft’s Power Tools: Formulas, PivotTables, Power Query, Power Pivot and Power BI Desktop to convert real world data sets into useful information (reports and dashboards) for business decision making.
This class is for matriculating students at Highline College, but videos and files are free at YouTube in this playlist: https://www.youtube.com/watch?v=cSs9jYudZBQ&list=PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4Videos (both old from 2010 and new ones for MS 365 Excel) to be posted over next three months. Topics: Chapter 1: Introduction Chapter 2: Financial Statements Chapter 3: Working with Financial Statements Chapter 4: Time Value of Money and Valuation Chapter 5: Discounted Cash Flow Valuation Chapter 6: Interest Rates & Bond Valuation Chapter 7: Equity Markets & Stock Valuation Chapter 8: NPV & Other Investment Criteria Chapter 9: Capital Investment Chapter 10: Some Lessons from Capital Market History Chapter 11: Risk & Return
Excel Statistical Analysis for Business Class Playlist of Videos from excelisfun Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College. Videos #1 to #50 use Microsoft 365 Excel, including spilled array formulas. Videos #63 to #72 use Excel 2013. Some of the topics: Learn: 1. Data, Data Analysis and Statistical Analysis 2. Excel Formulas and Functions 3. Power Query and PivotTables 4. Keyboards for efficient Data Analysis on Big Data 5. Number Formatting 6. Effective and efficient spreadsheet design, including Excel’s Golden Rule 7. What is Statistics (Descriptive and Inferential) 8. Descriptive Statistics: Tabular & Graphical Presentation 9. Descriptive Statistics: Numerical Measures (Averages and Variances) 10. Introduction to Probability 11. Discrete Probability Distributions 12. Continuous Probability Distributions 13. Sampling and Sampling Distributions 14. Interval Estimation 15. Hypothesis Testing 16. Simple Linear Regression 17. Comparisons involving Means, Experimental Design and Analysis of Variance 18. Comparisons involving Proportions and a Test of Independence
Videos about the amazing Excel Power Query, which allows you at import, clean and transform data from many sources and then load it to an Excel Sheet, Power Pivot's Data Model, or Power BI's Data Model. First 20 Videos give a great survey of what Power Query can accomplish. From Mike excelisfun Girvin at Highline College.
1. Building Good Spreadsheet Models 2. What If Analysis 3. Excel Data Analysis Tools 4. Frequency Distributions & Histograms 5. Averages, Variation, Probability & More 6. Power Query for Importing, Cleaning & Transforming Data 7. Excel Power Pivot for Big Data 8. Visualizing Data 9. Linear Regression 10. Time Series Analysis and Forecasting 11. Linear Programming 12. Monte Carlo Simulation 13. Not Just One Way To Analyze a Business Problem