I understand this is an Excel Genius group but I need help. I want to perfect my Excel skills. I am still a new learner, how do I do that please? Thanks

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

In General if you spend any more than five minutes on a repetitive task, there’s a faster way to do it. Google what you’re doing and then watch a YouTube video on how to do it faster. Do This for about five years.

likehelpful

Practical application of formulas and skills. You can stare off on a hundred or a thousand videos, but if you don’t actually have a need you won’t be willing to explore or perfect your formulas and skills. It’s all just theoretical.

My suggestion find a problem and then go fix it.

like

My go to for beginner Excel and PQ is usually getting someone to make a calendar table.

Adding the name of day and month, week ending (Sunday & Friday), month start by calendar and weekending and Financial & Fiscal Year. Then adding more columns like days in a month, weekdays in a month, etc and how that answer changes depending on how you define a month.

Then the usual putting filters on it and using a structured table so you get used to putting in good fundamentals and understanding syntax as well as nested IFS and other formulas.

You get to work with familiar data and outputs, every knows the calendar just that you've probably never had to make one from scratch and it leads into PQ/Pbi if that's something you want to exlore.

like

OP the way that I learned Excel was by taking a class at a local community college. It was cheap to take and it taught me so much about how to really use the program. There are features I didn't even know existed until I took the class.

like

Linked In learning has videos

Related Posts

Hello if anyone’s there 👋 I’m wondering what some of you have done after getting your PPL? I assume continue to learn/gain ratings, but how often do you fly once you’ve reached that milestone, do you look to get you own aircraft (or share), volunteer etc? Looking to eventually take the plunge, but want to know what things look like beyond PPL.

like

Hi Fishes, I am Market Research Analyst, can someone recommend what course or skill upgradation, will help me to grow my career in consulting.?

like

What is some advice you all can share to move up the corporate ladder quickly? If you can, share what we’re your timelines from position to position!

like

Hi Folks,

I have 2 YOE as Automation tester but I am more inclined towards devops.

Can anyone suggest me any course or any roadmap for this.

like

Is breaking into equity research/coverage teams as hard as breaking into traditional advisory/M&A IB being from a non target school with a non finance degree?

like

I’m one of the top performers in the company and got invited to the company’s emerging leadership program. I always meet all my goals and deliverables on time but still feel like half of the time I’m not even doing anything (or performing my best). How do I leverage this ‘off-time’ into something productive in order to progress faster?

like

What goes though you mind when thinking about quitting consulting ? Considering a move to industry

like

I am just starting my teaching career. I plan to enroll in the Alternate Teaching Certification program this fall. Looking for all the pointers I can get for my future class. Subbing 4 yrs

like

Has any creative here ever tried to make the leap to leave advertising and be a film maker, photographer, illustrator, etc.?? I’m so tired of ad agencies and how draining the “creative” can be. Happiness is more important than a nice paycheck for me. Any inspiration success stories advice would be so helpful right now...

likefunny

At what point are you too specialized to lateral to internal audit? (PA, consulting, or industry roles) Currently have 2 years of external audit experience and 2 years of forensics: I always thought of internal audit as a decent exit but I’m beginning to get worried about getting too specialized to make that move one day

like

Hi team, can anyone explain me about the job role of systems integration senior specialist?

like

My company is giving me a reimbursement while I go to school. It’s capped to induce me to study part time. I decided to go full time. Pay the difference out of pocket so I can graduate quicker. I have been working as a manufacturing engineer tech for 4 years without a degree but this May I will get my bachelors in Mechanical Eng. Currently making 63k a year, hourly. What should I ask for when I graduate? Living in Southern Pennsylvania.

like

Hi all, currently working as a Guidewire developer. Any idea what is the future of Guidewire developer? Will the experience count if I apply for java related roles?

like

Looking for a career opportunity that I can make $100k+. I have been in dental for about 10 years and held a ton of roles ranging from front desk to operations and training. I feel like I have so much experience and an amazing skillset to bring to an organization but struggling to know where to go, HELP! **open to leaving dental

like

Need some guidance in general. I am a non tech recruitment who specialises in management consulting hiring mid and leadership levels and lead a team as well. Wondering what my next steps should look like. Do we have an experienced TA professionals here?

It is possible to change into some other aspect of HR post 5 years?
Is it worth doing an exec MBA from XLRI jamshedpur?
Have so many questions 😵

like

Need career advice. Trying to break into a finance role, preferably an Analsyt role but I have no transferable experience. I worked as a mortgage loan officer (which is sales) for 2 years after college, but since mortgage is such a niche industry, no hard skills transfer and have no relevant undergrad internships unfortunately. I know I can essentially get any sales job I want in finance IE: financial advisor etc. but don’t want to be stuck in sales forever. Any advice?

like

How to get a PSM certification

like

Are most companies paying for you to learn new skills? When acquiring new skills are you mostly self taught? What are your best go to sites for learning animation or video skills? Trying to gauge the norm on expectations for new hires who need to know everything from print, web, video, social and animation. Can you do it all?

like

For those who left big law for DOJ, SEC, etc., what do you see as the best benefit to have done so (other than the reduction in workload)?

like

More Posts

For those who observe - hope folks are having a great Good Friday and heading into a great Easter weekend! For those that don't, hoping today is a little quieter and you can recharge this weekend!

like

Relocating to SF and office will be in downtown. Does Foster City sound like a good option to live? Maybe need to commute only a day or two to office. Thanks!

like

Is it just me or do people drive like maniacs in the Denver metro? Constant tailgating no matter what the speed limit or if there’s traffic or construction. I’m appalled by how dangerous some people here drive. Relax, getting there a few seconds faster isn’t worth anyone’s life. Aren’t y’all supposed to be too high to be driving like this anyway?

like

Can we get Udemy Business access in Verizon? Or anyother learning portal access?

like

Going to Jamaica for a bachelor party Memorial Day Weekend...da hell do I wear?

Hey all - looking for help finding new men’s clothing for casual wear (all seasons). What’re your go-to brands?

Trying to expand my style & look at new brands - currently shopping at Zara, H&M, Bonobos, Banana Republic

Thanks for the help!

like

Alright fellas, hims vs keeps?

I’m 25 and still have a good head of hair, but can see myself greying and feel like more and more hair is falling out every day. Not noticeable but have heard prevention is everything for this and am following the exact pattern my grandfather did, who had thick hair like mine and then was bald by 30.

Appreciate all you stylish folk and hope everyone has a great day.

like

Best loafers bang for buck & quality? Let’s specify heel/flat and color

like

Anyone help support their parents small business? I often work with them on the weekends and work my weekday job at KPMG. Feeling burnt out but can’t say no to my parents bc they need the help. Looking for any advice.

And no I do not ask for pay, I help the business to provide free work for my family to save them money.

like

I hate California labor law,.., that is all :-) lol

likefunny

Doing documentation is the the adult version of Mad Libs

like

Does that super conservative guy from KPMG have any comment on Trump's "interview" with Fox and Friends? I just want to know how they ratioanlize Mr. Stable Genius

like

Does NTT data pays variable pay that they mention in the offer letter as PEP(0-14%)?

How is Novartis Management Consulting Domain? I have got an offer for 20.5L

YOE - 3.5yrs

like

Going to miss the bench come Monday ): been an awesome 3 weeks.

like

Can someone help with a list of ELSS scheme a newbie with investment start with.I am looking for tax saving but have no idea about these MF

Average starting comp for MM PE associate in bay area? 250k?

like

Is associate and junior the same? If not, what's the difference?

like

Did a bunch of agencies just go on a firing spree before Christmas?

like

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Anyone know what these badges are?

Post Photo
likefunny

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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

Scan your QR code to download
Fishbowl app on your mobile

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