Say I am done learning excel and I am pretty good at handling the basis. Which areas of specialization can i pivot to that will most likely be excel/google dependent?

P.S: I want a type of specialization that i can offer on freelancing platforms or as a consultant.

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

Would check out python in excel - Power bi

like

Tableau, power BI, data analytics

Power query could get you out of a jam, might be worth learning. PowerBI is an excellent choice too, even if just the very basics.

I am unclear on the question. Which areas in excel or outside of excel? If you are planning on being a consultant without a data science background I would stay away from any language. I would focus on identifying the mess in the data. Are all the numbers actually numbers, are blanks not reading as blanks? If you can clean data you are doing most of the work a data scientist does without having to have a CS degree or know code. And by working in excel you provide a relatable way to talk with those you are consulting with.

Related Posts

What makes the most sense if you are trying to become a data scientist? Working at Accenture as a digital analyst or going to a startup and take an offer an junior data scientist? Can’t decide!

likehelpful

Anyone with Jamf certificates ? Is there any scope and opportunity for one who completed this course...

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

Hi fellow PMs, Question for the group: has anyone here made the switch from being a creative agency PM to a digital producer or digital agency PM? I.e. going from managing creative projects like TV to managing website builds/UX projects. If so, what was the transition like and what helped you get your bearings in the new environment? I’m thinking about making the switch myself but I don’t have a digital background.

like

Any Walmart ASM(Assistant Store Manager) here? Current or ex? Want to move forward but feels stuck in retail.

Is anyone here an analytics engineer? If so what do you do, and what are the main differences between your job and a data engineer?

like

How tough is it to get internal switching from one role to other in CitiusTech?

I currently work at a medium sized firm and have about two years experience in personal injury litigation. The billable hours and lack of work life balance are really getting to me and I am looking to switch to something else out of litigation, preferably in house. I am also looking to relocate to a different state. How do I go about properly marketing myself to companies that might not take my relocation and minimal experience seriously?

like

Any tips on leaving a firm “correctly”? Was about to go “of counsel” with my firm of 6 years, but then another firm whose partners I really respect (and personally like) offered me a partnership position. I predict my current bosses will *flip* (cut off file access immediately, try to beat me to calling my clients, etc.), so how do I set myself up for a successful transition?

like

which is the best data science course?
Edx / Coursera / datacamp OR do training from local institutes.
Any experienced person can share Roadmap , it will help me/others

like

Leaving after one year to another biglaw firm?

like

I would like to hear from any UX Program Managers who are willing to share their experience.

How difficult is it to juggle a remote role with a hybrid role?

My current role is hybrid with at least two days a week in office. However, with the potential economic downturn, I'm considering holding on to the role to supplement my income.

I'm new to the overemployed movement, so I'm evaluating the feasibility of holding onto the hybrid role and the remote position.

like

Hi im having 3 yoe having 2 offer 1.Nice x+2 variable+1Joining bonus 2.Bitwise x+2 fix which one i should join plesae suggest in term of job security and learning wise

like

I am in the process of finding administrative assistant interns from our local universities. In an effort to make my job opportunity appealing, I am asking everyone in this bowl about an appropriate job title. Is "Administrative Assistant" outdated or unappealing? I certainly don't want to mislead anyone on the job responsibilities, but I do want to avoid any potential negative stereotypes attached to that job title. Are there alternative titles that you find more appropriate for 2022?

uplifting

Is it easy to transfer within Accenture, e.g. if you wanted to leave CEO & ES for another area?

like

I've decided to leave public for an Accounting Manager position in private. What are the different types of companies to consider and the pros/cons? What are the best ways to get the position? I'm leaning toward GL accounting at a publicly-traded company. My background is 3.5 years audit and 2.5 years technical accounting advisory.

like

What are some of your worst experiences working in the entertainment industry?

like

Anyone taken the CFF? Looking for advice on the first exam

Can any BCG 🐠🐠 share your experience working in federal/social sector? As younger staff, is it at all possible stick to to projects in these sectors?

like

Could someone explain what finance closing process is? I passed CPA and have audit experience but I don’t really understand how industry accounting cycle works :( What does it mean to close the books? Are they referring to 12/31 deadline? Do all JE have to be recorded within this date? How does one close it?

like

More Posts

Hi Fishes,

I need likes to enable the DM. Could you please hit a like ?

Thanks 😊.

likesmarthelpful

Need 6 Marriott nights to titanium (spend doesn’t matter). 1 - would any hotel manager cut you a deal? (Ie if 6 nights is 60k; let me pay 30k and get the nights and I won’t use the room?); 2 - where are cheapest Marriott hotels? I found 10k per night in burbs of Chicago? 3 - would any cheap Marriott let me run this scam remotely? (Ie call Abilene Texas, check me in without my showing up)

like

Does anyone know what it's like to work at insider ? Tech saas ai martech business. Read a few Glassdoor reviews that concerned me.

like

How do you respond when someone asks your salary? Give me both- where you tell a number and where you don't. Also if I'm giving out a number (obviously to a close one), should I say my package(including stocks)? or my in hand salary before tax? or in hand salary after tax?

like

Hello,

How much should I target in the market with following:

YOE: 3.9 years (first job)

Data scientist

CCTC: 9.5 FIXED

Offer in hand :18+1(variable) I'm confused about should I stop here or try more? 40 days on notice period left.

like

I have a love-hate relationship with DU.

like

What is the best, highest-paying company for cybersecurity companies?

likehelpful

Thoughts on SNAP puts ? I feel like Snapchat is the least utilized social media platform behind IG, tik Tok and Facebook. Yet it’s basically at a 52 week high

like

Anyone joining PwC AC Banglore on 6th September?
Have you got any mail for a laptop or any onboarding details?

Any good PM roles open? By good, I mean focused on PM activities and not covering down for unrealistic sales promises. Rapidly hitting my limit at my current org.

like

How is the transport facility in hsbc development center Hyderabad ?

like

I would love to start teaching and learning outside the classroom walls. I would like to start working with middle school U.S. SS classes in other parts of the US. I'm in NJ, let me know if interested

like

I’m thinking about moving up to a high school English position from 8th grade English. Mainly I’m looking for a change. Any thoughts on the differences I’d be facing?

I have high school children of my own, but disciplining high schoolers has always intimidated me for some reason. I have excellent classroom management, but I feel like high schoolers are a little smarter ab getting around rules and less worried about consequences.

I’m told by an hs tchr that the grading load is ab the same.

like

“Don’t worry about the budget. If we like the idea, we’ll find the money.”

Has anybody ever found that money?

likefunny

Looking for a fully remote job! I previously worked as a Care Coordinator with a hybrid schedule but that started becoming more demanding on f2f with clientele. I’d like something different than care coordination but still stay within the field. BA in psychology with 10 years experience working with Developmental and behavioral health. I’ve been searching for something and have yet to find anything aside from coordination! Any recommendations are appreciated!

Here’s a question for the recruiters out there: do you want to see my portfolio?
I just started freelancing after having been FT for a long time. Top agency experience, Cannes Lions, NYC-based, DM me!

I’m having trouble finding resources on operational due diligence - I’m trying to study for an interview and can’t seem to find a lot of good things online about it. Any advice / leads?

like

Did any one recently joined LTI chennai? Need to ask few regarding interview scheduling process ?

like

Can someone please let me know what is the maximum salary that Deloitte India offers to Consultant?
YOE : 4.5
Current offer from Deloitte: 16 fixed
Offer from another MNC: 18.9 fixed

Will Deloitte India be able to match the offer if I renegotiate?

like

Additional Posts in Excel Genius

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

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

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

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

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

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

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

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

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