Image Mso Gallery Menu.

Lien | Publié le par | Tagué , | 1 commentaire

Excel VLOOKUP – The Massive Guide with Examples

Publié dans Excel, Informatique | Tagué | Laisser un commentaire

Excel Version History

Excel Version History

The table below lists the various versions of Excel for Windows that you may encounter.

Version Released Comments
1 1985 Version 1, for the Macintosh was released.
2 1987 The first Windows version was labeled « 2 » to correspond to the Mac version. This included a run-time version of Windows.
3 1990 Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features.
4 1992 The first « popular » version. Included lots of usability features.
5 1993 A major upgrade. Included multi-sheet workbooks and support for VBA.
7* 1995 Known as Excel 95. The first major 32-bit version of Excel**. Feature-wise, it’s very similar to Excel 5.
8 1997 Known as Excel 97. A new interface for VBA developers, UserForms, data validation, and lots more.
9 1999 Known as Excel 2000. Can use HTML as a native file format, « self-repair » capability, enhanced clipboard, pivot charts, modeless user forms.
10 2001 Known as Excel 2002, this is part of Office XP. It has a long list of new features, but most of them will probably be of little value to the majority of users. Perhaps the most significant feature is the ability to recover your work when Excel crashes.This version features product activation technology (i.e., copy protection). Please consider the ramifications of this before deciding whether to upgrade.

Read John Walkenbach’s Excel 2002 Review at PC World.

11 2003 It’s called Microsoft Office Excel 2003.The new features in this version are: (a) improved support for XML, (b) a new « list range » feature, (c) Smart Tag enhancements, and (d) corrected statistical functions. Most users will not find the upgrade worthwhile.
12 2007 Finally, some major changes in Excel. For some, the changes may actually be too major.
14 *** 2010 New features include sparkline graphics, pivot table slicers, an updated Solver, and a 64-bit version..
15 2013 New features include a single-document interface, charting enhancements, and recommended charts and pivot tables.

* There is no Excel 6. Beginning with Excel 7, the version numbering was changed so all of the Microsoft Office applications would have the same version number.

** There was also 32-bit version of Excel 5, but it was not widely distributed.

*** There is no Version 13 of Microsoft Office

En passant | Publié le par | Tagué | Laisser un commentaire

Environment Variables in Windows Vista, Windows 7, and Windows 8

http://windows7tips.com/environment-variables-windows-vista-7.html

Variable Typical value (may vary)
%ALLUSERSPROFILE% C:\ProgramData
%APPDATA% C:\Users\(username}\AppData\Roaming
%CommonProgramFiles% C:\Program Files\Common Files
%COMPUTERNAME% {computername}
%COMSPEC% C:\Windows\System32\cmd.exe
%HOMEDRIVE% C: or sometimes D:
%HOMEPATH% \Users\{username}
%LOCALAPPDATA% C:\Users\{username}\AppData\Local
%PATH% Varies. Includes
C:\Windows\System32\;C:\Windows\
%PATHEXT% .COM; .EXE; .BAT; .CMD; .VBS; .VBE;
.JS ; .WSF; .WSH; .MSC
%ProgramData% C:\ProgramData
%PROGRAMFILES% Directory containing program files, usually C:\Program Files
%ProgramFiles(x86)% In 64-bit systems, directory containing
32-bit programs. Usually C:\Program
Files (x86)
%PROMPT% Code for current command prompt
format. Code is usually $P$G
%Public% C:\Users\Public
%SYSTEMDRIVE% The drive containing the Windows root
directory, usually C:
%SYSTEMROOT% The Windows root directory, usually
C:\Windows
%TEMP% and %TMP% C:\Users\{Username}
\AppData\Local\Temp
%USERNAME% {username}
%USERPROFILE% C:\Users\{username}
%WINDIR% Usually C:\Windows
Note the changes from Windows XP for the locations of many of the personal files and settings. For example, the « Documents and Settings » folder is gone and there is now a « Users » folder. There are also four new environment variables listed in Table I. These are:

%CommonProgramFiles%
%LocalAppdata%
%ProgramData%
%Public%
The common dynamic variables are similar to those given for XP.

Changes in environment variables between Vista and Windows 7 or 8

There are few changes in the common variables in going from Windows Vista to Windows 7 or Windows 8. As far as I can tell, there is only one worth mentioning. Windows 7 and 8 come with the newer Microsoft command line shell called Powershell. There is an environment variable %PSModulePath% that gives the path to the files for the command line shell. This is usually C:\windows\system32\WindowsPowerShell\v1.0\Modules\

List environment variables in Windows 7 or 8 using PowerShell

In the classical command line, environment variables can be listed with the « set » command. Beginning with Windows7, Microsoft began including the newer command shell called « PowerShell ». The command for listing environment variables in this newer shell is Get-ChildItem Env:

Publié dans Informatique, Windows | Laisser un commentaire

Excel Project Protection Fr.

%,{F11},%,O,E,+,{TAB},{RIGHT},{TAB},{SPACE},{TAB},1,2,3,{TAB},1,2,3,{ENTER},%,F,F,

Publié dans Code, Excel | Tagué | Laisser un commentaire

Excel UnProtect Project Fr

%,{F11},%,O,E,1,2,3,{TAB},1,2,3,{ENTER},{ENTER},%,F,F,

Publié dans Code, Excel | Tagué | Laisser un commentaire

MVVM Tutorial From Start to Finish

Lien | Publié le par | Tagué , | Laisser un commentaire