Completely mobile friendly.
• Basic Examples
• Advanced Examples
Cheater John is providing concise Cheat Sheets, Reference Sheets and Educational Documents for your everyday use.
At work, school and home.
This reference sheets (4 pages) include shortcut key combinations for Word, Excel and Power Point 2010.
As this sheet designed in vector graphics it has infinite resolution and could be printed in high quality.
It fits all levels and can be used for business and educational purposes.
All the topics in this book are elaborated in simple manner for easy understanding. Each and every topic in this book is covered with detailed illustrations followed by output.
What you will learn in this book
1) Introduction to Excel VBA-
2) Declaring Variables
3) Working with Ranges
4) If…Else Statements
5) Select Case Statements
6) For Next Statements
7) Do Loops
8) Operators in VBA
9) Understanding the VB Editor
10) Function Procedures
11) MsgBox and InputBox Functions
12) String Functions
13) Information Functions
14) Working with Internet Explorer
• Microsoft Office Basics
Display and use windows
Use dialog boxes
Use edit boxes with dialog boxes
Use the Open and Save As dialog boxes
Undo and redo actions
Access and use task panes and galleries
Access and use available actions
• Common Tasks in Microsoft Word
• Edit and Move Text and Graphics
Delete text and graphics
Copy and move text and graphics
Insert special characters
Insert characters by using character codes
Select text and graphics
Extend a selection
Select text and graphics in a table
Move through your document
Move around in a table
Insert paragraphs and tab characters in a table
Use overtype mode