Главная
Study mode:
on
1
) Introduction
2
) Calculations in Excel
3
) Worksheet formulas definition and elements
4
) Example of Number Formula
5
) ROUND function
6
) How Number Formatting Interacts with Numbers and Formulas
7
) Example of Text Formula
8
) TEXTBEFORE function
9
) FORMULATEXT function
10
) IFNA function
11
) Show Nothing with a Formula using Zero Length Text String “”
12
) Example of Logical Formula using Comparative Operators
13
) Don’t Get Tricked By Number Formatting
14
) Alt Keyboard Shortcuts
15
) Excel’s Golden Rule = Most Important Formula Tip
16
) Excel Models
17
) Percentage Number Format
18
) Style Formatting
19
) “Old School” Formula that Requires a Relative Cell Reference and a Manual Copy action.
20
) Angry Rabbit Copy Cursor
21
) “New School” Formula that Spills Results
22
) Dynamic Spilled Array Formula
23
) Beauty of Excel. Bricklin and Frankston and VisiCalc.
24
) Summary of Worksheet Formulas and Excel Models
25
) Define Data Analysis
26
) Define Data, Table, Field, Record
27
) Tools for Data Analysis
28
) Data Analysis Goals for Video
29
) Excel Table feature
30
) Define PivotTable
31
) PivotTable feature
32
) Grouping Dates to create Month Report
33
) PivotTable Cache
34
) Change Report Layout, Manually and Default Settings
35
) Calculations in Values Area of PivotTable
36
) Number Formatting for PivotTable
37
) Conditional Formatting in PivotTable
38
) Add New Data to Excel Table and Refresh PivotTable
39
) Default Settings For Expanding Excel Tables
40
) Excel Line Chart to Show Sales Trends from a PivotTable
41
) Formatting Chart
42
) Rules for Visualizing with Charts
43
) Add Slicer To PivotTable and Chart to visualize Sales Rep Sales Trends
44
) Excel Data Analysis Tools Summary
45
) Summary of Video
46
) Closing and Video Links
Description:
Dive into a comprehensive 1-hour 14-minute tutorial on Excel's powerful features, including worksheet formulas, functions, PivotTables, slicers, charts, and Excel tables. Learn essential calculations, formula elements, and functions like ROUND, TEXTBEFORE, and IFNA. Master number formatting, logical formulas, and Excel's "Golden Rule" for efficient modeling. Explore data analysis techniques, including Excel Tables and PivotTables, with practical examples of grouping dates, changing report layouts, and applying conditional formatting. Discover how to create and format charts, implement slicers for dynamic visualizations, and understand best practices for data presentation. Perfect for both beginners and intermediate users looking to enhance their Excel skills for data analysis and reporting.

Excel Formulas & Functions, PivotTables, Slicers & Charts

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Slicers #Spreadsheets #PivotTables
1 of 46

) Introduction