excel, as a gp report writernetcomlearning.s3.amazonaws.com/webinars/...excel, as a gp report writer...
TRANSCRIPT
![Page 1: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/1.jpg)
Excel, as a GP Report Writer
Learning Excel Pivot Tables by building a
GP General Ledger Trial Balance
By Belinda Allen
Dynamics GP MVP
www.NetcomLearning.com
![Page 2: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/2.jpg)
2 www.NetcomLearning.com
What do we want to see?
Draw it on paper first!
![Page 3: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/3.jpg)
3 www.NetcomLearning.com
What do we want to see?
![Page 4: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/4.jpg)
Let’s get the data!
4 www.NetcomLearning.com
![Page 5: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/5.jpg)
Where would this data be in SmartList
www.NetcomLearning.com 5
![Page 6: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/6.jpg)
And now the data is an Excel Table
6 www.NetcomLearning.com
![Page 7: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/7.jpg)
And now the data is an Excel Table
7 www.NetcomLearning.com
A table is a range of cells that hold data, with each row corresponding to a single occurrence of an entity. When you create a table, you can manage and analyze the data in that table independently of data outside the table. http://www.excel-2010.com/tables-in-excel-2010/
![Page 8: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/8.jpg)
Build the Pivot Table
8 www.NetcomLearning.com
![Page 9: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/9.jpg)
Build the Pivot Table
9 www.NetcomLearning.com
![Page 10: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/10.jpg)
Build the Pivot Table
10 www.NetcomLearning.com
![Page 11: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/11.jpg)
Build the Pivot Table
11 www.NetcomLearning.com
![Page 12: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/12.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 12
![Page 13: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/13.jpg)
Let’s start with the Rows!
www.NetcomLearning.com 13
![Page 14: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/14.jpg)
Let’s start with the Rows!
www.NetcomLearning.com 14
![Page 15: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/15.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 15
![Page 16: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/16.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 16
We need to combine the account number and name into one field so they’ll show on the same line.
![Page 17: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/17.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 17
![Page 18: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/18.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 18
![Page 19: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/19.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 19
Concatenate tr.v., -nat·ed, -nat·ing, -nates.To connect or link in a series or chain. Computer Science. To arrange (strings of characters) into a chained list. adj. (-nĭt, -nāt') Connected or linked in a series. Read more: http://www.answers.com/topic/concatenation#ixzz1ZpgnTvZq
![Page 20: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/20.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 20
![Page 21: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/21.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 21
![Page 22: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/22.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 22
![Page 23: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/23.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 23
![Page 24: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/24.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 24
![Page 25: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/25.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 25
![Page 26: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/26.jpg)
Let’s Start with the Rows!
www.NetcomLearning.com 26
![Page 27: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/27.jpg)
Next the Data!
www.NetcomLearning.com 27
![Page 28: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/28.jpg)
Next the Data!
www.NetcomLearning.com 28
No Net Amount
![Page 29: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/29.jpg)
Next the Data!
www.NetcomLearning.com 29
![Page 30: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/30.jpg)
Next the Data!
www.NetcomLearning.com 30
![Page 31: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/31.jpg)
Next the Data!
www.NetcomLearning.com 31
![Page 32: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/32.jpg)
Next the Data!
www.NetcomLearning.com 32
![Page 33: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/33.jpg)
Next the Data!
www.NetcomLearning.com 33
![Page 34: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/34.jpg)
Next the Data!
www.NetcomLearning.com 34
![Page 35: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/35.jpg)
Next the Data!
www.NetcomLearning.com 35
![Page 36: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/36.jpg)
Next the Data!
www.NetcomLearning.com 36
![Page 37: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/37.jpg)
Now the Columns!
www.NetcomLearning.com 37
![Page 38: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/38.jpg)
Now the Columns!
www.NetcomLearning.com 38
What is period 0? What year is it?
![Page 39: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/39.jpg)
Finally “Report-wide” criteria!
www.NetcomLearning.com 39
![Page 40: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/40.jpg)
Finally “Report-wide” criteria!
www.NetcomLearning.com 40
![Page 41: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/41.jpg)
Finally “Report-wide” criteria!
www.NetcomLearning.com 41
![Page 42: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/42.jpg)
Finally “Report-wide” criteria!
www.NetcomLearning.com 42
![Page 43: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/43.jpg)
Are we done?
www.NetcomLearning.com 43
![Page 44: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/44.jpg)
One more Important Detail
Voided? Posted?
www.NetcomLearning.com 44
![Page 45: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/45.jpg)
One more “Report-wide” criteria!
www.NetcomLearning.com 45
![Page 46: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/46.jpg)
One more “Report-wide” criteria!
www.NetcomLearning.com 46
![Page 47: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/47.jpg)
Summary Trial Balance Finished
47 www.NetcomLearning.com
![Page 48: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/48.jpg)
Summary Trial Balance Finished, but…
48 www.NetcomLearning.com
Let’s now have some fun with this report!
![Page 49: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/49.jpg)
Show me the detail!
www.NetcomLearning.com 49
![Page 50: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/50.jpg)
Show me the P&L Accounts!
www.NetcomLearning.com 50
![Page 51: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/51.jpg)
Show me the P&L Accounts!
www.NetcomLearning.com 51
![Page 52: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/52.jpg)
Show me the P&L Accounts!
www.NetcomLearning.com 52
![Page 53: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/53.jpg)
Show me the Vendor or Customer!
www.NetcomLearning.com 53
![Page 54: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/54.jpg)
Show me the Vendor or Customer!
www.NetcomLearning.com 54
![Page 55: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/55.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 55
![Page 56: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/56.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 56
![Page 57: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/57.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 57
![Page 58: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/58.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 58
![Page 59: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/59.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 59
![Page 60: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/60.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 60
![Page 61: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/61.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 61
![Page 62: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/62.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 62
![Page 63: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/63.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 63
![Page 64: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/64.jpg)
Let’s Change to Calendar Periods
www.NetcomLearning.com 64
Don’t forget to sort the columns
![Page 65: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/65.jpg)
Sales Accounts only?
www.NetcomLearning.com 65
![Page 66: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/66.jpg)
Sales Accounts Only
www.NetcomLearning.com 66
![Page 67: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/67.jpg)
Sales Accounts Only
www.NetcomLearning.com 67
![Page 68: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/68.jpg)
Sales Accounts Only
www.NetcomLearning.com 68
![Page 69: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/69.jpg)
Sales Accounts Only
www.NetcomLearning.com 69
![Page 70: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/70.jpg)
Sales Accounts Only
www.NetcomLearning.com 70
Here, a negative is a credit and that’s a good thing.
![Page 71: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/71.jpg)
Q1 Sales Accounts Only
www.NetcomLearning.com 71
![Page 72: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/72.jpg)
Add a graph?
www.NetcomLearning.com 72
![Page 73: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/73.jpg)
Add a graph?
www.NetcomLearning.com 73
![Page 74: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/74.jpg)
Add a graph?
www.NetcomLearning.com 74
![Page 75: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/75.jpg)
Can I see each account as a % of the month?
www.NetcomLearning.com 75
![Page 76: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/76.jpg)
Can I see each account as a % of the month?
www.NetcomLearning.com 76
![Page 77: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/77.jpg)
Can I see each account as a % of the month?
www.NetcomLearning.com 77
![Page 78: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/78.jpg)
Can I see each account as a % of the month?
www.NetcomLearning.com 78
![Page 79: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/79.jpg)
Can I see each account as a % of the month?
www.NetcomLearning.com 79
![Page 80: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/80.jpg)
Make is easier to read?
www.NetcomLearning.com 80
![Page 81: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/81.jpg)
Make is easier to read?
www.NetcomLearning.com 81
![Page 82: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/82.jpg)
Make is easier to read?
www.NetcomLearning.com 82
![Page 83: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/83.jpg)
Make is easier to read?
www.NetcomLearning.com 83
![Page 84: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/84.jpg)
Make is easier to read?
www.NetcomLearning.com 84
![Page 85: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/85.jpg)
Better visuals without a graph?
www.NetcomLearning.com 85
Since Credits are good here, either change the sign or…
![Page 86: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/86.jpg)
Better visuals without a graph?
www.NetcomLearning.com 86
Create a new rule!
![Page 87: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/87.jpg)
Better visuals without a graph?
www.NetcomLearning.com 87
![Page 88: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/88.jpg)
Better visuals without a graph?
www.NetcomLearning.com 88
![Page 89: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/89.jpg)
Glossary
Ad Hoc Ad hoc is a Latin phrase meaning "for this". It generally signifies a solution designed for a specific problem or task, non-generalizable, and not intended to be able to be adapted to other purposes. http://en.wikipedia.org/wiki/Ad_hoc
Concatenate tr.v., -nat·ed, -nat·ing, -nates.To connect or link in a series or chain. Computer Science. To arrange (strings of characters) into a chained list. adj. (-nĭt, -nāt') Connected or linked in a series. Read more: http://www.answers.com/topic/concatenation#ixzz1ZpgnTvZq
Table A table is a range of cells that hold data, with each row corresponding to a single occurrence of an entity. When you create a table, you can manage and analyze the data in that table independently of data outside the table. http://www.excel-2010.com/tables-in-excel-2010/
89 www.NetcomLearning.com
![Page 90: Excel, as a GP Report Writernetcomlearning.s3.amazonaws.com/webinars/...Excel, as a GP Report Writer Learning Excel Pivot Tables by building a GP General Ledger Trial Balance By Belinda](https://reader034.vdocuments.us/reader034/viewer/2022043005/5f8b1a3b76ea4a312e486ee7/html5/thumbnails/90.jpg)
Belinda Allen
www.NetComLearning.com 90