Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Flash Fill

3:27

Create a Basic Pivot Table and Pivot Charts

4:46

20 Principles for Good Spreadsheet Practice

7:15

Navigation

8:08

Keyboard Shortcuts

10:26

Customize Your Quick Access Toolbar

11:23

Excel Options

12:40

Status Bar at the Bottom

13:40

Customized Status Bar

13:56

Online Templates

15:03

Templates

15:25

Conditional Formatting

22:08

Highlight Cells Rules

22:59

Duplicate Values Options

23:17

Conditional Formatting Highlight Cell Rules

24:16

How To Link to the Target Cell

33:52

Link to the Target Cell

33:58

Basic Functions

34:15

Autosum

34:35

Autosum Dropdown

35:54

Absolute versus Relative Referencing

38:22

Relative versus Absolute Referencing

38:42

Absolute Referencing

40:53

Sort and Filter Your Data

43:01

Sort Options

43:25

Sorting if Your Data Runs

44:34

Cleaning Data

45:57

Blank Rows

46:57

Delete Sheet Rows

48:04

Remove Duplicates

48:33

Format It as a Table

52:52

Creating a Pivot Table

53:57

Vlookup

56:45

Data Validation

58:31

Will There Be More in-Depth Webinar on Index-Match

1:05:35

Index Match Formula

1:06:14
Top 10 Excel Tips and Tricks for Accountants
386Likes
29,881Views
2018Nov 20
Are you an accountant or accounting professional looking to extend your Excel Skills? Do you know your VLOOKUPS from your INDEX MATCH? Do you often find yourself grappling with PivotTables and Charts trying to make sense of data? If so, then this webinar is for you! We will go through the Top 10 Excel tools that every accountant needs to know. For the follow-along exercise file, and our 'Top 100 Excel Tips' for FREE, click below: Exercise Files: https://drive.google.com/drive/folder... Want our 100 Definitive Most-Useful Excel Tips? You can get them here:  https://bit.ly/2sSUHas Website: https://bit.ly/2RroZem

Follow along using the transcript.

Excel with Business

12.2K subscribers