Category: Excel
-
MS Word and Excel Common Shortcut Key
•
MS Word and Excel Common Shortcut Key Bold Highlighted Selection(contents) Ctrl + B Italic Highlighted Selection Ctrl + I Insert Link Ctrl + K Underline Highlighted Select Ctrl + U Bring up the print dialog box to the printing Ctrl + P Undo last action Ctrl + Z Open the…
-
MICROSOFT EXCEL SHORTCUT KEYS
•
MICROSOFT EXCEL SHORTCUT KEYS Edit the selected Cell F2 Key Enter the current date Ctrl + ; Open the excel formula Window Shift + F6 Bring up search box Shift + F5 Minimize Current Window Ctrl + F9 Maximize Currently Selected Window Ctrl + F10 Switch Between open workbooks and…
-
A gateway to hidden and powerful features !
•
Do you use Paste Special every day? If not, you could be wasting a lot of time in Excel. Paste Special sounds boring, but it’s a gateway to many hidden and powerful features: Powerful features of Paste Special here! With paste special, we can easily: Convert formulas to static values…
-
Advanced Topics in Excel :
•
Excel over view The Date in Excel Excel Conditional Formatting Excel VLOOKUP Excel HLOOKUP Using Excel’s Goal Seek Feature Create Excel Pivot Tables Microsoft Excel Sort Feature Introduction to Using Macros in Microsoft Excel 2003 Protect Excel Sheet Data base in excel Copy, paste special function Links (Sheet / work…
-
Microsoft Excel – Course outline
•
Are you want to learn MS Excel online? A free training session available for short time. What topic you want to learn? comments here Question Y/N Question Y/N Write basic formulas, eg = A1*A2 Write formulas using brackets where required, eg =(A1+A2)/A3 Write basic functions, eg SUM, AVERAGE,MAX, MIN Selecting…
-
Excel training (online)!
•
https://www.fiverr.com/s2/845e59e2ce?utm_source=org.wordpress.android_Mobile