-1+1607 
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. Peetyboy
455. AshesOfDeadEmpires
456. keeneyes
457. ilhanca
458. theEMPTYlife
459. spatel2407
460. thatonechameleon
461. sjnh
462. incuboaquien
463. sa3atsky
464. tht2012
465. gcubed
466. mieczr
467. kimlafemme1
468. eommakesmadbeats
469. jsmith
470. Mishthefish
471. geetanvesh
472. Ximilez
473. katsuuu100
474. jraymay
475. Halkilt
476. IamAlfie
477. PolBunyan
478. dstambo
479. sagarshah992
480. cosq54
481. secretapril
482. Ryanhennessy_kh
483. jacobab43
484. esoluyemo
485. Boulos92
486. reddityesterday
487. master_Shifu
488. felipe.rosa
489. guder4me
490. oreoshakeman
491. SunnyvilleShitHawks
492. leoandskye
493. Labanczbm
494. lailai201214
495. goodstorytellitagain
496. michellcu03
497. Mistah-grey
498. naterific
499. missbee23
500. janette3
501. fcorozco
502. nukeduke
503. flotheking
504. JackieXL
505. cyberspetz
506. tonny
507. janart
508. elizabeta.vacariu
509. RK9fury
510. rgb0y
511. kcmdux88
512. Zeapis
513. Olliesmith90
514. 25013
515. jingles
516. Henley101
517. tarisilalahi
518. theflyingbrant
519. wangb
520. MintBerryFresh
521. nanacammie
522. dajunya
523. ohmysun
524. hiimstevezissou
525. nyvenomx19
526. Flackintosh
527. TLawrence0811
528. brandon_ball_z
529. szimelis
530. Wjmcnerney
531. jb047w
532. superoleo
533. rianaditia
534. rude_navigator
535. crgroening
536. _DK_
537. kuropixi
538. romek
539. rabani
540. alihussaini.syedshah
541. mithwyn
542. dnenov
543. Smalls32
544. tschi127
545. makis19
546. Chiron_
547. purplequestion
548. chaddenton
549. kreigos
550. nate5000
551. tekalon
552. mvresh
553. p3t3r.tnie
554. sillypuss
555. chuuke
556. riderist
557. mmathew
558. bunty44
559. Tain33
560. freewill1
561. Chandrashekar
562. mtschill
563. Petitexplora
564. xetari
565. alligator_aneurysm
566. Adelgarde
567. mjgerges
568. ct104
569. ayrton55
570. Justin_Obsurver
571. Sharliemt
572. blaaahmcblaahington
573. Roxana0474
574. chocolatedogs
575. neenaj
576. kaydea
577. Drew502
578. scatsthename
579. LeQuebecer
580. leo_rajeswari
581. kaimmej
582. slpeach
583. hkjairam
584. R.W.G
585. aspt
586. euphorialive
587. marcussandou
588. Shan
589. Cjmclean17
590. AIMBoss
591. anniew77
592. DasNasty
593. Nicoleweber2025
594. ddstitt
595. ashleyhicks1030
596. sanobar
597. maftoun95
598. Kuku4e
599. munichi
600. Appopo
601. wutabum17
602. sodainmycereal
603. geoful
604. sneeraj
605. AshishP89
606. ginabrock12
607. mjsodl
608. brich90
609. Hardik2014
610. elcaminoforreal
611. bryanc86
612. mischwag
613. groverinri
614. i_love_bearss
615. jthuso
616. SKaori10
617. bendigedigfran
618. taeyeonist
619. andrealval94
620. Uredditaccount5
621. f_puppo
622. RebeccaThompson
623. iamjay
624. cause
625. the_path_i_chose
626. Satrohan
627. Anneth
628. h.jehou
629. juberjack
630. TBLIXXXY
631. Melvin63100
632. DMedinov
633. bkthom1
634. ali-c21
635. Aarunus
636. drerossouw
637. Success20
638. Azharsuni
639. Jadams0617
640. carmen0851
641. Zlmiller
642. bigbadblue
643. alexsmahlii
644. chancebd7
645. A815104
646. SaraBettencourt
647. n78045
648. MeLearn
649. json492
650. elombat
651. QuirkyUser
652. mmurp36
653. nastrus
654. Mww726
655. deannad72
656. kcole722
657. babybestbelieve
658. rarepepe420
659. deodatovilla
660. Anj2017
661. anki1997137
662. provaguest
663. leen8
664. sushmapandey88
665. lorielie
666. R.ranjan.solenoid
667. gperamaih
668. robincrm
669. ataneski
670. dugastm
671. ascppl
672. bitterblue
673. himanisharma1309
674. pooperinoo
675. odachi
676. pareek
677. LazyResearcher
678. markkoeks
679. fhamidakeya
680. sakshi91
681. mlringer
682. dhershkowitz
683. jmax111587
684. dinaklarisse
685. bookphoenix
686. OrderOfTheAshes
687. williambrewer1
688. rastbryant
689. sanjukta.saha
690. lcf2108
691. jalibeanqueen
692. PRAVERO