VMware Workstation is a hosted hypervisor that runs on x64 versions of Windows and Linux operating systems[4] (an x86 version of earlier releases was available);[3] it enables users to set up virtual machines (VMs) on a single physical machine, and use them simultaneously along with the actual machine. Each virtual machine can execute its own operating system, including versions of Microsoft Windows, Linux, BSD, and MS-DOS. VMware Workstation is developed and sold by VMware, Inc., a division of Dell Technologies. There is a free-of-charge version, VMware Workstation Player, for non-commercial use. An operating systems license is needed to use proprietary ones such as Windows. Ready-made Linux VMs set up for different purposes are available from several sources.

VMware Workstation supports bridging existing host network adapters and sharing physical disk drives and USB devices with a virtual machine. It can simulate disk drives; an ISO image file can be mounted as a virtual optical disc drive, and virtual hard disk drives are implemented as .vmdk files.

Working with Formulas/Functions

  • Lookup and Reference Functions: VLOOKUP, HLOOKUP, Match and Index.
  • Logical Function: IF / ELSE, AND, OR, NOT, NESTED IF/ELSE.
  • Math Functions: ROUND, TRUNC, CEILING, FLOOR, MOD, SUM, SUMIF, SUMIFS.
  • Statistical Functions: AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN.
  • Text Functions: LEFT, RIGHT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, FIND, CONCATENATE, SEARCH, SUBSTITUTE.
  • Date and Time Functions