-1+1307 
Power Pivot for the Excel user

Powerpivot for the Excel user is an online Microsoft Power Pivot tutor, written by an Accountant, focusing on beginner to advanced Power pivot skills tailored to suit the needs of both individuals (business owners, professionals, employees) and businesses (corporate).

Lectures
  1. Power Pivot for the Excel user

    Get a free Demo of this course and all our other courses by registering with The Professional Training Academy

Prerequisites

Excel knowledge

Syllabus

Time required to complete course and CPD hours/credits allocated - 6 hours

Chapter 1 Installing Powerpivot Import Data From Access Import Data From Custom Query Import Data From Excel Import Data From Txt File Saving Your File Chapter 1 Review 2 Working With Tables Relationships Calculated Columns Insert Pivot Table Insert Pivot Charts Slicers Chapter 2 Review 3 Understand Measures Creating Measures Chapter 3 Review 4 Dax An Introduction X Functions And Countrows Related And Related Tables Filter & Distince Calculate Function Chapter 4 Review 5 Time Intelligence Functions 1 Time Intelligence Functions 2 Chapter 5 Review

Additional information

Online course can be accessed any where any time - use the contact us form and request a discount

Teacher qualifications

CPA

Latest Update

none

Roster
1. proftraining
2. def30
3. gartac
4. thisismygame
5. ivers17872
6. Marionfrey
7. jwhathaway
8. kevinchoi
9. abrushing
10. jamalson
11. aamirazeem
12. asholic
13. pseaguy
14. My0hMy
15. penischarles
16. g0bananas
17. lioness818
18. Tongya_Kupana
19. gomezjrs
20. burninho
21. gscharanraju
22. Alixxr
23. donramses
24. Joshthejumperman
25. shwets
26. nrosie
27. TawnyPigeon
28. mmmarshawnlynch
29. officiallyme
30. smack
31. omniv
32. Mak
33. pvtfawkes
34. dhudzin
35. likevenice
36. WarmBro
37. fongkongtsoi
38. NMBobblehead
39. beansjr
40. ChaoticHavok
41. EXICON
42. elevenidiots
43. liamjmc
44. azzarel3
45. doongbuggy
46. ncastell77
47. Hapes
48. ryustreetfighter
49. ohh_no
50. viper1092
51. hundredacrewood
52. johnbak
53. BlueJadeLei
54. silly_lion
55. casemath21
56. frenken
57. lionheart21
58. sabazio
59. rebol2n
60. spurned1
61. obi_juan_shinobi
62. luttappi
63. phantazmadroidz
64. ravi4chahal
65. shahsali
66. alizonkiel
67. dylanb
68. Axlrize
69. cdasilva
70. nveed23
71. treeson
72. GeauxldenPP7
73. thanhthong
74. missy8995
75. thepurplesky
76. murphymj
77. sheikhbarabas
78. bluebox44
79. Cest_La_v
80. flemindk
81. corycruse
82. icameforthemusic
83. Rutski71
84. captmkg
85. Yossarian0022
86. bontist
87. Skender
88. rtadoyle
89. jnnfrdickson
90. DeDodgingEse
91. Tony116
92. MXVII
93. flannelbananna
94. buddia
95. ckj06
96. asaxena11
97. bhope3
98. pokAtok
99. jaendress
100. nglrossi
101. Fuzzybeard
102. navinuttam
103. lookingforsome
104. Hopeless-Wanderer
105. MaturaiX
106. ericqespiritu
107. SteveB526
108. joeeb22
109. Tapetfjes
110. chaitanya26
111. sidhrth
112. georgeman007
113. deapolis
114. Shazam4991
115. tdmckee
116. mixedrice
117. bamboocrush
118. alanaim
119. dougal6
120. aGrainOfSalt
121. lildre
122. blasphemerr
123. Rakinbade
124. williska
125. vm5valerie
126. Hbizzle
127. ctrengove
128. admiralgeneral
129. Chicabonita8
130. jamibacker
131. ecNate
132. tricolored_mantaray
133. jamesglen25
134. jatkins7629
135. renegadegenius
136. jillian
137. chishokl
138. royarmstrongmustang
139. kazekami13
140. bs01395n
141. poolsaregreatforholdingwater
142. mattellio
143. jecri
144. beaubc
145. Outlandish_Minn
146. prototype7live
147. cindyvincent
148. eliegirl
149. namangus
150. Fdjaynes
151. wogboy101
152. ficar
153. ineptsage
154. Groblox
155. Teddypost
156. makeitwain
157. NF11
158. myreprise
159. jpage1989
160. tikiman6
161. up678050
162. nathanseitz
163. majortennis
164. vau43
165. auszooker
166. mistuhg
167. suwatsuwat
168. longgoodknight
169. THEADMININTHEDARK
170. olds0ul
171. TangoDestroyer
172. mnqcbrrs
173. mad5675
174. rs332602
175. midnyght219
176. guillefras
177. meadammatthews
178. wblxcskier
179. tereeves
180. ringob82
181. mightyblackstar
182. jone7up
183. araose
184. NerdyNella
185. scottsen
186. pookeye
187. fluxium
188. kateroo
189. Alsbet
190. VeniVidiDimmitui
191. athenstiger
192. shord143
193. Shankspony
194. brentshermana
195. NicoJuicy
196. probst.jon
197. bamadude66
198. DamnyouMongarians
199. vlad82
200. tpkalman
201. timlovelock
202. Chromaburn
203. jjjvanloon
204. chanheelee
205. Melkotnia
206. smallbusinesspage
207. xhulja
208. rifche
209. linkz
210. needlearn
211. Bloodrazor
212. lisak67
213. avuman
214. L2BSmart
215. jlarez
216. brucemilus
217. californiagrapin
218. eliams
219. happybanana
220. somethiax
221. thirstin4more
222. harukaze1337
223. MACROS
224. rony_995
225. Peroviendo
226. ayush1018
227. johnnl4
228. remington
229. Skidie
230. pegasusx47a
231. ConradKilroy
232. givesyoulink
233. battlebug
234. Janette
235. Ahmedjaber
236. jessiechew
237. rhodes_54
238. dirtdart504
239. ilovelampalot
240. typopsi
241. xiaoqbighunny
242. Joklom
243. thephotograph
244. intro_VERT13
245. nawalster
246. lihab
247. danyalamriben
248. iamsurbhi
249. vansmend
250. andy2ndlife
251. redbrigadier
252. bbmacarthur
253. crichm03
254. Sergeivlasov47
255. RicoSpartan
256. Djohnnok
257. Swu4us
258. lakshmij441
259. jesparzachau
260. buguoruci
261. mb4113593
262. tmascia
263. ucfgavin
264. Bnealis
265. MACROS14
266. crewguy35
267. thecrazyboyftw
268. da.amaya483
269. vineetverma
270. -dOuOb-
271. MrEtherBunny
272. The3rdIcon
273. renamshah
274. freeallbeings
275. naveen988
276. jbabs
277. samannay
278. Joka999
279. pendragon03
280. AfricanLandcruiser
281. ilhanca
282. lionvan
283. neibrewer
284. megadarkfriend
285. Antoaneta
286. wolfieCK
287. blt24
288. mickthemaniac
289. Theguybehindthescreen
290. hallac
291. sagyourjeans
292. fauxhemian5
293. burtgervis
294. dirtysmalls
295. vincentmakreel
296. thethirdtrappist
297. parrotchutes
298. sunfisches
299. Ozziemedes
300. stronggarya
301. Usagi
302. MatthewBailey
303. blake_simons
304. Alisher
305. Ishwari
306. dreadman86
307. Ajnanin
308. asingh21
309. kohilak
310. Bohemiandan
311. joemegill2
312. dipep
313. skapetis
314. alyss228
315. djk4800
316. sidhant.nayak
317. geezusfreak
318. g4r7h
319. Jelica
320. roarora
321. startupankur
322. gitsebas
323. mrmack00
324. smilingodessa
325. add
326. mherndon
327. kdlynch12
328. mozturk
329. mantrasuser
330. fezspinkguitar
331. mlebot
332. mattmottola
333. slangdon
334. sersdf
335. NX25
336. elijah10
337. _hondaaccord1996
338. Demented30
339. ddruger
340. aphodite
341. dguerrero1
342. Jody-Husky
343. ashis
344. Vexed
345. 20sat92
346. kvmahesh
347. DingDing
348. clarencekey
349. J3ferreira
350. orchidsage
351. aboutdabusiness
352. lrussock
353. hooray4alex
354. fuckpatricksmom
355. klasicar
356. learner1235
357. garymutherfuckingoak
358. MJBETZ
359. dungeonmasterbater
360. kjivkov
361. Mooremath