-1+1412 
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. nveed23
70. treeson
71. GeauxldenPP7
72. thanhthong
73. missy8995
74. thepurplesky
75. murphymj
76. sheikhbarabas
77. bluebox44
78. Cest_La_v
79. flemindk
80. corycruse
81. icameforthemusic
82. Rutski71
83. captmkg
84. Yossarian0022
85. bontist
86. Skender
87. rtadoyle
88. jnnfrdickson
89. DeDodgingEse
90. Tony116
91. MXVII
92. flannelbananna
93. buddia
94. ckj06
95. asaxena11
96. bhope3
97. pokAtok
98. jaendress
99. nglrossi
100. Fuzzybeard
101. navinuttam
102. lookingforsome
103. Hopeless-Wanderer
104. MaturaiX
105. ericqespiritu
106. SteveB526
107. joeeb22
108. Tapetfjes
109. chaitanya26
110. sidhrth
111. georgeman007
112. deapolis
113. Shazam4991
114. tdmckee
115. mixedrice
116. bamboocrush
117. alanaim
118. dougal6
119. aGrainOfSalt
120. lildre
121. blasphemerr
122. Rakinbade
123. williska
124. vm5valerie
125. Hbizzle
126. ctrengove
127. admiralgeneral
128. Chicabonita8
129. jamibacker
130. ecNate
131. tricolored_mantaray
132. jamesglen25
133. jatkins7629
134. renegadegenius
135. jillian
136. chishokl
137. royarmstrongmustang
138. kazekami13
139. bs01395n
140. poolsaregreatforholdingwater
141. mattellio
142. jecri
143. beaubc
144. Outlandish_Minn
145. prototype7live
146. cindyvincent
147. eliegirl
148. namangus
149. Fdjaynes
150. wogboy101
151. ficar
152. ineptsage
153. Groblox
154. Teddypost
155. makeitwain
156. NF11
157. myreprise
158. jpage1989
159. tikiman6
160. up678050
161. nathanseitz
162. majortennis
163. vau43
164. auszooker
165. mistuhg
166. suwatsuwat
167. longgoodknight
168. THEADMININTHEDARK
169. olds0ul
170. TangoDestroyer
171. mnqcbrrs
172. mad5675
173. rs332602
174. midnyght219
175. guillefras
176. meadammatthews
177. wblxcskier
178. tereeves
179. ringob82
180. mightyblackstar
181. jone7up
182. araose
183. NerdyNella
184. scottsen
185. pookeye
186. fluxium
187. kateroo
188. Alsbet
189. VeniVidiDimmitui
190. athenstiger
191. shord143
192. Shankspony
193. brentshermana
194. NicoJuicy
195. probst.jon
196. bamadude66
197. DamnyouMongarians
198. vlad82
199. tpkalman
200. timlovelock
201. Chromaburn
202. jjjvanloon
203. chanheelee
204. Melkotnia
205. smallbusinesspage
206. xhulja
207. rifche
208. linkz
209. needlearn
210. Bloodrazor
211. lisak67
212. avuman
213. L2BSmart
214. jlarez
215. brucemilus
216. californiagrapin
217. eliams
218. happybanana
219. somethiax
220. thirstin4more
221. harukaze1337
222. MACROS
223. rony_995
224. Peroviendo
225. ayush1018
226. johnnl4
227. remington
228. Skidie
229. pegasusx47a
230. ConradKilroy
231. givesyoulink
232. battlebug
233. Janette
234. Ahmedjaber
235. jessiechew
236. rhodes_54
237. dirtdart504
238. ilovelampalot
239. typopsi
240. xiaoqbighunny
241. Joklom
242. thephotograph
243. intro_VERT13
244. nawalster
245. lihab
246. danyalamriben
247. iamsurbhi
248. vansmend
249. andy2ndlife
250. redbrigadier
251. bbmacarthur
252. crichm03
253. Sergeivlasov47
254. RicoSpartan
255. Djohnnok
256. Swu4us
257. lakshmij441
258. jesparzachau
259. buguoruci
260. mb4113593
261. tmascia
262. ucfgavin
263. Bnealis
264. MACROS14
265. crewguy35
266. thecrazyboyftw
267. da.amaya483
268. vineetverma
269. -dOuOb-
270. MrEtherBunny
271. The3rdIcon
272. renamshah
273. freeallbeings
274. naveen988
275. jbabs
276. samannay
277. Joka999
278. pendragon03
279. AfricanLandcruiser
280. lionvan
281. neibrewer
282. megadarkfriend
283. Antoaneta
284. wolfieCK
285. blt24
286. mickthemaniac
287. Theguybehindthescreen
288. hallac
289. sagyourjeans
290. fauxhemian5
291. burtgervis
292. dirtysmalls
293. vincentmakreel
294. thethirdtrappist
295. parrotchutes
296. sunfisches
297. Ozziemedes
298. stronggarya
299. Usagi
300. MatthewBailey
301. blake_simons
302. Alisher
303. Ishwari
304. dreadman86
305. Ajnanin
306. asingh21
307. kohilak
308. Bohemiandan
309. joemegill2
310. dipep
311. skapetis
312. alyss228
313. djk4800
314. sidhant.nayak
315. geezusfreak
316. g4r7h
317. Jelica
318. roarora
319. startupankur
320. gitsebas
321. mrmack00
322. smilingodessa
323. add
324. mherndon
325. kdlynch12
326. mozturk
327. mantrasuser
328. fezspinkguitar
329. mlebot
330. mattmottola
331. slangdon
332. sersdf
333. NX25
334. elijah10
335. _hondaaccord1996
336. Demented30
337. ddruger
338. aphodite
339. dguerrero1
340. Jody-Husky
341. ashis
342. Vexed
343. 20sat92
344. kvmahesh
345. DingDing
346. clarencekey
347. J3ferreira
348. orchidsage
349. aboutdabusiness
350. lrussock
351. hooray4alex
352. fuckpatricksmom
353. klasicar
354. learner1235
355. garymutherfuckingoak
356. MJBETZ
357. dungeonmasterbater
358. kjivkov
359. Mooremath
360. skweyete
361. Farhad_H_Reza
362. Kathi
363. arc12345
364. sheikhshadi
365. akram217
366. infurl
367. Tamagoyaki
368. tkra73
369. csraymer
370. reveh
371. mmbazel
372. lobo.caique
373. JulianneSmith
374. crunchycrackers
375. Kchris393
376. jedbob
377. puffpufflol
378. mrazz
379. skynet5000
380. rayna007
381. ross84
382. ethorlakson
383. rubyshakya
384. yaarchetan
385. juggler0
386. nomoremountains
387. crissa208
388. polgs
389. TimInDubai
390. ningen_desu
391. MutantSquirrel
392. tinavh
393. benmember
394. eric13ain
395. geoKC
396. morvans
397. Willemien
398. vinatoruroxana
399. TimmyPips
400. steveplender
401. tmoreontop
402. oana1sarbu
403. isocialoutcast
404. Revcass
405. seanknight
406. rachbern
407. BinkFloyd
408. septamush
409. Daysdisappear
410. Mastermind_Simpleton
411. mj228
412. LunaAndre
413. starskip
414. magvtepes
415. eduoli
416. custok
417. wishparab9
418. wizzdjo
419. Yourstruly99
420. Raj_Mandumula
421. dupeofadupe
422. mcirac
423. nikkozilla
424. springfvr2
425. immelda
426. intrepid
427. hueylewis0
428. dhirenshah3
429. messi
430. shaynee
431. Alsatian
432. kingkongjaffa
433. kingkongjaffa
434. bobbiburrows2
435. happytaco
436. anonimouz
437. keicruz
438. jschoch
439. erubiano8
440. Flora
441. CampCarthage
442. Bullockproof
443. sasikiranu
444. chvrlja
445. victorandrei
446. mushyp
447. PaulFinnigan
448. semajnosnhoj
449. spinsurgeon
450. DonOgre
451. COMIDA__
452. snigarm
453. Gtobin
454. easy_rider
455. indestructable
456. Peetyboy
457. AshesOfDeadEmpires
458. keeneyes
459. ilhanca
460. theEMPTYlife
461. spatel2407
462. thatonechameleon
463. sjnh
464. incuboaquien
465. sa3atsky
466. tht2012
467. gcubed
468. mieczr
469. kimlafemme1
470. eommakesmadbeats
471. jsmith
472. Mishthefish
473. geetanvesh
474. Ximilez
475. katsuuu100
476. jraymay
477. Halkilt