Best way to learn power query & power pivot?

like
Posting as :
works at
You are currently posting as works at

Microsoft legit has a whole manual (mini articles and videos) on their website that teaches you it all. Also learn from YouTube videos where necessary. You gotta keep practicing and applying it though, because if you only periodically reference it, it’s easy to forget a lot.

likesmart

Currently trying to learn PQ. I bought a course through udemy, it’s not too expensive and I think it’s helpful when you work along with the downloadable examples and material rather than just watching a tutorial. The instructor is Leila Gharani - if you’ve ever searched how to use certain features of excel on YouTube, you’ve likely seen a video or two of her material on your feed. It’s early in the course, but so far so good. Good luck!

like

Related Posts

like

When it comes to digital P2P solutions, what's the best way to handle blanket purchase orders in such tools?

like

I would appreciate any insight on management-side employment law in Dallas. I am a MLA at a large firm in LA pondering a move for financial/family reasons, but it doesn't seem like there are many open positions in DFW and I'm wondering if this area of the law is just not robust in Texas.

like

Associates, how did you balance your morning sickness and fatigue in early pregnancy with work? Thankfully I’m still WFH, but worried about receiving insane turnarounds that require me to stay up late/all night and the effect it might have on the baby. I’m past my hours for the year and feel like I should be able to say no, but the team I’m on has a tendency to push past no’s.

like

Hi all, I recently purchased a commercial property at WTC, Noida. As I look to grow my portfolio, I spoke to my consultant to see if I could get better prices. He worked with the sales folks at WTC and said that if multiple buyers come in, he could work out a deal. Wanted to check if anyone is interested? I could potentially get him to set up one-on-ones to help explain the commercial real estate market. Even if this property doesn’t seem interesting, I think an interaction wouldn’t hurt.. contd

like

Hello ,
My sister is looking for a job .She is well trained in Testing and SQL.
She is technically very good.
Could you please help if you have any references.

A best decision.....😛😉

Post Photo
funnylike

Looking for a woman AD with mid to senior experience to partner up on a couple of projects. Please DM me

What model do you use for coaching?

What is your uber rating ?

like

Anyone else has the feeling data science consulting is over glorified? Projects are so small they have little bottom line impact.

like

I’m currently working with a senior level HR candidate. This individual has a doctorate in business with a focus in HR, her SPHR, Federal, and private sector experience at the singer level, and has a fabulous personality. I’m curious is anyone else having difficulties play some candidates like this? At this point I’m starting to think it’s racial or her sex based of the lack of interest in this candidate. Any thoughts?

like

Has anyone successfully deferred their exam for the august window? If I defer now can I sit the exam in November?

like

Best legal/outside counsel spend tracking software? I have received buy-in to enthusiastically shoot Legal Tracker/Serengeti out of a cannon into the sun, so will be starting an RFP for a better program (bar is low if you have LT/Serengeti experience).

likehelpful

When to put in two weeks notice? I've received and signed my offer letter- best practices to wait for background check to clear?

like

In a personal injury case not involving a motor vehicle accident, how can a plaintiff settle a case if only one of defendants’ carriers covering one year has appeared when defendants...(cont)

like

Do pay ranges for Colorado job listings indicate base salary or total compensation?

like

Hi, Can Accenture supervisor block employee from joining again in exit process feedback?

like

Has anyone had success being a freelance account manager? I feel like most freelancers are creative, is there a market for freelance account?

like

Hi everyone 🎅! I'm looking to join online communities (like this one) for people in marketing agencies. Particularly Slack groups. Anyone have any recommendations? Thanks!

like

Additional Posts in Excel Genius

Hey, tips for where to look for good excel cheat sheets online? :)

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

how do you index or vlookup when the match isn't exact? like one cell has a comma or space after the value...?

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

What's the F4 analogy in Office 365?

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Index match question! Is there any way to add a sum function? Index match pulls the first value in the table, but I want the sum of all values in a row with the same header.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal