Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

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

You can change the settings in Bios if you want to flip the fn keys response. Not recommended. But that’s an alternative for that irritation. I had the same thing with HP Spectre.

like

Fn lock can be helpful while working in Excel, but it looks like your keyboard might not be conducive to that. External keyboard is probably going to be your friend. I have a super slim one that I travel with if I’m going to be using Excel a lot

helpful

I just like thinking control effin home or control effin end when I try to get to the top or bottom of the sheet. It’s the little things.

Related Posts

Thoughts on Toyota Superbowl spot?

Late 90s: Web designer. Early–mid 2000s: Digital designer. Nxt 15 yrs: digital strat & creative (AD). Dropped 15K for General Assembly’s UXDI. Being rejected for basic UX roles bc I have no apps....

like

Anyone joined cisco recently? Do they have virtual onboarding?

like

I teach Economics and Personal
Finance at a specialty school. I use NGPF for personal finance but I am seeking Economics lessons for G&T

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

I am a new associate (1 month in mid-tier firm) and I struggle to get work to fill up the whole day. In honest time, i get about 3-5 billable hours a day. Am I going to get in trouble or fired over this?? I am putting my best efforts when I do get work and I ask for work sometimes. At this point I feel like I am being annoying too…

like

I have been interviewed on 23rd April and was asked to upload documents on the same day. From that day my application status is Review in Progress. Does anyone have any idea till when I can expect call from HR.

like

How much is the shift allowance for each shift?
I heard there will allowance for overtime too!
Can you please clarify?

I have an offer to do some consulting for a company based out of the UK (I am in the US). The job would not go through a consulting company but would be directly with the company. I have not done any consulting before so I am not sure how it works, what I would need to set up (they mentioned that I would start a LLC and bill them directly, no idea how to do that), how to determine the tax implications of this, or what hourly rate I would expect. Can anyone offer advice?

What is a good website to use to create a whole custom baby site?

I have 2.5 years of experience as a BI consultant primarily working with SQL and Power BI. I feel a little underpaid while currently making $75k. All of my performance reviews have been positive and I have been the lead/only BI developer on two of our largest and most public projects this year. Any thoughts on what I could ask for at end of year reviews for a salary increase?

like

Hey what’s people’s experience with performance advertising for brands? Do you come up with multiple ideas for reaching out to new customers?

Do middle market firms struggle to get entry level talent and interns?

like

Went to a top uni, looking to move to banking after 12 months. Does anyone have experience with this?

like

Hey y'all, kind of a two part question:
1. I enjoy the people management more than individual contributor stuff. What career paths do you see in our industry for people who are managing support engineering teams?
2. What certifications are valued today? Seems like being a AWS Cloud Practitioner is a good general one, but are there others that stand out?

like

What is the average salary for a controller data analyst role in industry?

like

I’m a CPA and am weighing going back for my Masters, maybe an MBA?

Will I get any benefit from going back to get my masters?

like
like

Hi guys, Could you please help me out on what to be filled here, I've 3 years of experience and I don't think I would be falling under gratuity that will be '0'. But I'm not sure of what to be filled on "Leave Encashment Exemption". I've 170 hours of leave balance. My HRBP dose not respond at all I've been trying to contact her from weeks and there's no response to any of mails nor pings on teams. I really appreciate you for helping me fill this?

Post Photo

Student housing property management company recommendations in Southeast?

like

Additional Posts in Excel Genius

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?

like

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

like

What are some of the unique use cases you have leveraged excel for?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

like

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

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

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

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

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

why is index match superior to vlookup?

likefunny

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Do you have to activate excel almost every time you use it- or is it just me?

like

How can I use a cell value (user input) to control the number of rows in a table? For example, I want to make a dynamic table containing a number of rows specified by the user. Thank you!

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