-1+1499 
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. mnqcbrrs
171. mad5675
172. rs332602
173. midnyght219
174. guillefras
175. meadammatthews
176. wblxcskier
177. tereeves
178. ringob82
179. mightyblackstar
180. jone7up
181. araose
182. NerdyNella
183. scottsen
184. pookeye
185. fluxium
186. kateroo
187. Alsbet
188. VeniVidiDimmitui
189. athenstiger
190. shord143
191. Shankspony
192. brentshermana
193. NicoJuicy
194. probst.jon
195. bamadude66
196. DamnyouMongarians
197. vlad82
198. tpkalman
199. timlovelock
200. Chromaburn
201. jjjvanloon
202. chanheelee
203. Melkotnia
204. smallbusinesspage
205. xhulja
206. rifche
207. linkz
208. needlearn
209. Bloodrazor
210. lisak67
211. avuman
212. L2BSmart
213. jlarez
214. brucemilus
215. californiagrapin
216. eliams
217. happybanana
218. somethiax
219. thirstin4more
220. harukaze1337
221. MACROS
222. rony_995
223. Peroviendo
224. ayush1018
225. johnnl4
226. remington
227. Skidie
228. pegasusx47a
229. ConradKilroy
230. givesyoulink
231. battlebug
232. Janette
233. Ahmedjaber
234. jessiechew
235. rhodes_54
236. dirtdart504
237. ilovelampalot
238. typopsi
239. xiaoqbighunny
240. Joklom
241. thephotograph
242. intro_VERT13
243. nawalster
244. lihab
245. danyalamriben
246. iamsurbhi
247. vansmend
248. andy2ndlife
249. redbrigadier
250. bbmacarthur
251. crichm03
252. Sergeivlasov47
253. RicoSpartan
254. Djohnnok
255. Swu4us
256. lakshmij441
257. jesparzachau
258. buguoruci
259. mb4113593
260. tmascia
261. ucfgavin
262. Bnealis
263. MACROS14
264. crewguy35
265. thecrazyboyftw
266. da.amaya483
267. vineetverma
268. -dOuOb-
269. MrEtherBunny
270. The3rdIcon
271. renamshah
272. freeallbeings
273. naveen988
274. jbabs
275. samannay
276. Joka999
277. pendragon03
278. AfricanLandcruiser
279. lionvan
280. neibrewer
281. megadarkfriend
282. Antoaneta
283. wolfieCK
284. blt24
285. mickthemaniac
286. Theguybehindthescreen
287. hallac
288. sagyourjeans
289. fauxhemian5
290. burtgervis
291. dirtysmalls
292. vincentmakreel
293. thethirdtrappist
294. parrotchutes
295. sunfisches
296. Ozziemedes
297. stronggarya
298. Usagi
299. MatthewBailey
300. blake_simons
301. Alisher
302. Ishwari
303. dreadman86
304. Ajnanin
305. asingh21
306. kohilak
307. Bohemiandan
308. joemegill2
309. dipep
310. skapetis
311. alyss228
312. djk4800
313. sidhant.nayak
314. geezusfreak
315. g4r7h
316. Jelica
317. roarora
318. startupankur
319. gitsebas
320. mrmack00
321. smilingodessa
322. add
323. mherndon
324. kdlynch12
325. mozturk
326. mantrasuser
327. fezspinkguitar
328. mlebot
329. mattmottola
330. slangdon
331. sersdf
332. NX25
333. elijah10
334. _hondaaccord1996
335. Demented30
336. ddruger
337. aphodite
338. dguerrero1
339. Jody-Husky
340. ashis
341. Vexed
342. 20sat92
343. kvmahesh
344. DingDing
345. clarencekey
346. J3ferreira
347. orchidsage
348. aboutdabusiness
349. lrussock
350. hooray4alex
351. fuckpatricksmom
352. klasicar
353. learner1235
354. garymutherfuckingoak
355. MJBETZ
356. dungeonmasterbater
357. kjivkov
358. Mooremath
359. skweyete
360. Farhad_H_Reza
361. Kathi
362. arc12345
363. sheikhshadi
364. akram217
365. infurl
366. Tamagoyaki
367. tkra73
368. csraymer
369. reveh
370. mmbazel
371. lobo.caique
372. JulianneSmith
373. crunchycrackers
374. Kchris393
375. jedbob
376. puffpufflol
377. mrazz
378. skynet5000
379. rayna007
380. ross84
381. ethorlakson
382. rubyshakya
383. yaarchetan
384. juggler0
385. nomoremountains
386. crissa208
387. polgs
388. TimInDubai
389. ningen_desu
390. MutantSquirrel
391. tinavh
392. benmember
393. eric13ain
394. geoKC
395. morvans
396. Willemien
397. vinatoruroxana
398. TimmyPips
399. steveplender
400. tmoreontop
401. oana1sarbu
402. isocialoutcast
403. Revcass
404. seanknight
405. rachbern
406. BinkFloyd
407. septamush
408. Daysdisappear
409. Mastermind_Simpleton
410. mj228
411. LunaAndre
412. starskip
413. magvtepes
414. eduoli
415. custok
416. wishparab9
417. wizzdjo
418. Yourstruly99
419. Raj_Mandumula
420. dupeofadupe
421. mcirac
422. nikkozilla
423. springfvr2
424. immelda
425. intrepid
426. hueylewis0
427. dhirenshah3
428. messi
429. shaynee
430. Alsatian
431. kingkongjaffa
432. kingkongjaffa
433. bobbiburrows2
434. happytaco
435. anonimouz
436. keicruz
437. jschoch
438. erubiano8
439. Flora
440. CampCarthage
441. Bullockproof
442. sasikiranu
443. chvrlja
444. victorandrei
445. mushyp
446. PaulFinnigan
447. semajnosnhoj
448. spinsurgeon
449. DonOgre
450. COMIDA__
451. snigarm
452. Gtobin
453. easy_rider
454. indestructable
455. Peetyboy
456. AshesOfDeadEmpires
457. keeneyes
458. ilhanca
459. theEMPTYlife
460. spatel2407
461. thatonechameleon
462. sjnh
463. incuboaquien
464. sa3atsky
465. tht2012
466. gcubed
467. mieczr
468. kimlafemme1
469. eommakesmadbeats
470. jsmith
471. Mishthefish
472. geetanvesh
473. Ximilez
474. katsuuu100
475. jraymay
476. Halkilt
477. IamAlfie
478. PolBunyan
479. dstambo
480. sagarshah992
481. cosq54
482. secretapril
483. Ryanhennessy_kh
484. jacobab43
485. esoluyemo
486. Boulos92
487. reddityesterday
488. master_Shifu
489. felipe.rosa
490. guder4me
491. oreoshakeman
492. SunnyvilleShitHawks
493. leoandskye
494. Labanczbm
495. lailai201214
496. goodstorytellitagain
497. michellcu03
498. Mistah-grey
499. naterific
500. missbee23
501. janette3
502. fcorozco
503. nukeduke
504. flotheking
505. JackieXL
506. cyberspetz
507. tonny
508. janart
509. elizabeta.vacariu
510. RK9fury
511. rgb0y
512. kcmdux88
513. Zeapis
514. Olliesmith90
515. 25013
516. jingles
517. Henley101
518. tarisilalahi
519. theflyingbrant
520. wangb
521. MintBerryFresh
522. nanacammie
523. dajunya
524. ohmysun
525. hiimstevezissou
526. nyvenomx19
527. Flackintosh
528. TLawrence0811
529. brandon_ball_z
530. szimelis
531. Wjmcnerney
532. jb047w
533. superoleo
534. rianaditia
535. rude_navigator
536. crgroening
537. _DK_
538. kuropixi
539. romek
540. rabani
541. alihussaini.syedshah
542. mithwyn
543. dnenov
544. Smalls32
545. tschi127
546. makis19
547. Chiron_
548. purplequestion
549. chaddenton
550. kreigos
551. nate5000
552. tekalon
553. mvresh
554. p3t3r.tnie
555. sillypuss
556. chuuke
557. riderist
558. mmathew
559. bunty44
560. Tain33
561. freewill1
562. Chandrashekar
563. mtschill
564. Petitexplora
565. xetari
566. alligator_aneurysm
567. Adelgarde
568. mjgerges
569. ct104
570. ayrton55
571. Justin_Obsurver
572. Sharliemt