• 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
101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work.
Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented.Teaches you how to implement the required Excel formula Explains and details how the formulas work Lets you reuse or customize the given formula to address your particular needs Helps you make the formulas a regular part of your new, more efficient workflow
Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.