Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:15) Open Excel file using Windows Explorer
(00:46) Navigating through large Workbook File with many Sheet Tabs
(02:27) Structure of an Excel Worksheet and Workbook
(04:21) Conventions for Workbook files in this class
(06:09) Excel Ribbon Tabs
(07:11) QAT = Quick Access Tool Bar. How to build your own QAT.
(08:53) Default Data Alignment and why is it so important and how we can use it to track down errors
(15:40) Considering what sort of keyboard to use to become efficient with Excel and data analysis.
(16:34) Using Keyboard Shortcuts to work efficiently.
(18:38) What Excel does
(19:31) Conclusion
(19:43) Closing and Video Links
Видео Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more канала ExcelIsFun
Topics in video:
(00:00) Introduction
(00:15) Open Excel file using Windows Explorer
(00:46) Navigating through large Workbook File with many Sheet Tabs
(02:27) Structure of an Excel Worksheet and Workbook
(04:21) Conventions for Workbook files in this class
(06:09) Excel Ribbon Tabs
(07:11) QAT = Quick Access Tool Bar. How to build your own QAT.
(08:53) Default Data Alignment and why is it so important and how we can use it to track down errors
(15:40) Considering what sort of keyboard to use to become efficient with Excel and data analysis.
(16:34) Using Keyboard Shortcuts to work efficiently.
(18:38) What Excel does
(19:31) Conclusion
(19:43) Closing and Video Links
Видео Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building VideoExcel Statistical Analysis 01: Data & Statistics10 Excel Things You Should NEVER Do and What to do InsteadHSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative DataExcel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical DataFlip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun19 Advanced Excel Shortcuts (do you know them all?)14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s ParadoxExcel Tips 14 - Links in Excel to Quickly Navigate Between Worksheets with ButtonsExcel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of VariationExcel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752