I'm starting a finance internship and am considering a 15-inch MacBook Air with an M5 chip. I already own a powerful Windows gaming laptop, but it is heavy, has mediocre battery life, and is inconvenient to carry around. The MacBook would mainly be for working away from home, running my online business, coding projects, and general productivity.
My biggest concern is Excel compatibility. I've read that running Windows 11 in a virtual machine on Apple Silicon can address many of the limitations. For people working in finance or investment banking, how well does that setup perform in practice? Can it reliably handle advanced Excel models, VBA macros, Power Query, Power Pivot, and finance-specific add-ins? Have you encountered situations where a virtual machine was not sufficient and a native Windows computer was required?
I'm also wondering whether the portability, battery life, and Apple ecosystem would genuinely make me more productive, or whether that is mostly a psychological preference. I want to avoid sacrificing long-term compatibility if I eventually work in a finance-heavy role where Excel is central to the job.
3 Answers
The main limitations are usually software-specific rather than general performance. Virtualization can be less suitable for applications that need low-level system access, certain hypervisor features, or other Windows-only integrations. For normal coding, web work, and portable productivity, the MacBook Air may feel much nicer than a gaming laptop, but a finance internship may provide a company Windows machine precisely because of Excel, security tools, and internal add-ins.
A Windows virtual machine should cover ordinary Windows applications, but finance compatibility depends heavily on the specific tools your employer uses. Standard Excel work and many macros may be fine, but specialized add-ins, unusual data connections, or features that expect traditional x86 Windows can still cause problems. Before buying, check which add-ins and workflows your internship actually requires. Keep the existing Windows laptop available as a fallback rather than assuming the virtual machine will be identical to native Windows.
That’s my main concern. I’m less worried about basic spreadsheets than discovering later that a bank-specific add-in or data tool only works properly on native Windows.
A lightweight Windows machine, such as a modern Surface-style laptop, could be a safer compromise if you want portability without giving up native Excel compatibility. Battery life may still fall short of a MacBook Air, especially under sustained workloads, but it avoids the uncertainty around virtualized Windows and Apple Silicon support. Since you already own a powerful Windows laptop, the MacBook option is most appealing if you value carrying comfort and battery life enough to justify keeping both systems.
That makes sense. I’m considering the MacBook more as a portable personal computer, while expecting that the internship itself may still require me to use a company Windows setup.