Excel Exercises - Mastering and Moving Data

Get a free account on my website here:

Get the full experience with write ups and downloads where applicable here

Get Bulletproof Bookkeeping with QuickBooks Online here:

Knowledge Center:

Live Support and One to One Training:

Get templates:

Index

01:40 Make sure you have downloaded the CSV files Seth provided and save as xlsx file

02:00 Working on the contact list first

03:50 Key shortcut to highlighting cells

04:05 Make a table in excel

05:20 Importance of creating visual cues

05:54 Shortcut to highlight the entirety of the columns

08:42 Getting rid of phone numbers with dashes

13:25 Filter arrows

15:50 Right clicking commands

16:00 Getting access to all the commands

17:40 Special visitors on Nerd Enterprises

21:58 Clear all your filters out

22:59 Filtering to determine non tech people

25:20 Do your best to segment email lists

25;45 Kajabi app to filter and segment emails

27:40 Test question, show all the people in state South Dakota

28:16 Test question find all the people in Albany NY

31:27 Custom test filters

32:47 Sales data file

33:33 Convert to table

33:41 Clean up the dates in sheet

34:5o Changing raw dates

36:58 Applying the currency and other formatting on numbers

40:55 Present the discount as a negative number

44:50 Creating a pivot table starting with sum of net order total

46:26 Changing the pivot table color palette

49:57 Test question sales by country and by sales person grouped by year

52:55 Report layout customization

55:15 Customizing the Pivot Table fields

This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Nerd Enterprises, Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Nerd Enterprises, Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.