Главная
Study mode:
on
1
Keyboards
2
Jump: Ctrl + Arrow
3
Go To Cell A1: Ctrl + Home
4
Format Cells dialog box or in a chart Format Chart dialog box: Ctrl + 1
5
Currency Number Format: Ctrl + Shift + 4
6
Highlight column: Ctrl + Shift + Arrow
7
Currency Vs Accounting Number Format
8
Alt keys:
9
PivotTable: Alt, N, V, T
10
PivotTable 2003: Alt, D, P
11
Page Setup: Alt, P, S, P
12
SUM: Alt + =
13
"Put thing in cell and move selected cell up": Shift + Enter
14
"Put thing in cell and keep cell selected": Ctrl + Enter
15
Select sheet to right: Ctrl + PageDown
16
Select sheet to left: Ctrl + PageUp
17
Number Formatting As Façade:
18
Decimal Number Format
19
Date Number Format
20
Keyboard for today's hard caded date:
21
Time Number Format
22
Percentage Number Format
23
Efficient Formula Creation
24
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
25
Formula elements, types of formulas, types of data
26
Monthly Allocation Formula: illustrate formula input that can be hard coded into formula
27
Tax inefficient formula: illustrate formula input that can should NOT hard coded into formula
28
Tax efficient formula: illustrate Golden Rule
29
Net Cash In formula: illustrate Golden Rule
30
Net Income formula: illustrate formula with built-in function within a larger formula
31
In Balance? formula: illustrate Logical formula
32
First & Last Name Join Formula: illustrate Text formula
33
COUNTIF formula: illustrate counting with criteria
34
COUNTIF & Label formula: illustrate counting with criteria and how the join symbol is used with criteria
35
Clear Formatting
36
SUMIFS to add with two criteria
37
SUMIFS to add between 2 dates
38
Count workdays formula to illustrate new Excel 2010 function NETWORKDAYS.INTL
39
Relative and Absolute Cell References
40
Mixed cell references in budget formula
41
Lookup Formulas
42
VLOOKUP to lookup product price: illustrate Exact Match lookup
43
Data Validation List:
44
VLOOKUP and IFERROR
45
VLOOKUP to lookup commission rate: illustrate Approximate Match lookup
46
Retrieve record 2-way lookup with VLOOKUP and MATCH
47
MATCH, ISNA and ISNUMBER functions to compare 2 lists
48
INDEX and MATCH to lookup Left
49
Pivot Tables
50
Proper Data Set
51
PivotTables Pivot Tables are Easy
52
Visualize Table First
53
Adding with One or Two Conditions Criteria
54
Report Layout
55
Number Formatting
56
Style Formatting, Create Your Own
57
Pivoting
58
Listing Two Fields in Row Labels
59
Collapsing Pivot Table Row
60
Changing Calculation: SUM to AVERAGE
61
Adding with Three Criteria
62
Filtering a Row Show Top Two Regions, Clear Filter
63
Filter whole report with Report Filter
64
Show Report Filter Pages 30 PivotTables with 1 click
65
Filter whole report with Report Filter or Slicer
66
Compare Formulas and PivotTables
67
Grouping Dates in PivotTables
68
Difference between Grouping Integers and Grouping Decimals
69
Pivot Chart
70
Show Values As:
71
Copy PivotTable
72
Running Totals & % Running Totals
73
% of Grand Totals, % of Column Total, % of Row Total
74
Difference From, % Difference From
75
Multiple Calculation in one PivotTable
76
Creating Second PivotTable from Second Cache of data using Excel 2003 keyboard shortcut for 3-step Wizard
77
Blank in number field causes PivotTable to Count by Default
78
Text in Date field prohibits Grouping of Dates
79
Basic Recorded Macro
80
Absolute References and save in Personal Workbook
81
How to trick the Macro Recorder into seeing a variable height report using Relative References
82
Rearrange records from vertical orientation to proper table using Relative References
83
Charts
84
Chart Types
85
Column Chart and How The Chart Wizard Interprets Data From Cells
86
Chart keyboards Create Default Chart
87
Select Data Source Dialog Box
88
Linking Chart Title to Cells
89
Saving Chart Templates
90
Setting Default Charts
91
Copy Charts
92
Bar and Stacked Bar charts
93
Line Chart & Change Source Data
94
Number Formatting to show "K" or "M"
95
Line Chart vs. X Y Chart
96
X Y Scatter
97
X Y Scatter Line Break Even Analysis Chart
98
Multiple chart types
Description:
Master Excel for accounting with this comprehensive video tutorial. Learn essential formulas, VLOOKUP, INDEX, PivotTables, recorded macros, charts, and keyboard shortcuts. Explore efficient formula creation, data validation, and advanced lookup techniques. Dive into PivotTables for data analysis, including filtering, grouping, and creating pivot charts. Discover how to record macros for report automation and create various chart types for data visualization. Practice with provided start and finished files to enhance your Excel skills for accounting applications.

Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Accounting #Finance #Financial Analysis #Spreadsheets #VLOOKUP #PivotTables
0:00 / 0:00
1 of 98

Keyboards