Learn Excel 101

by WAGmob

★ ★ ★ ★ ★ Over One million paying customer ★ ★ ★ ★ ★ WAGmob brings you Simple 'n Easy, on-the-go learning ebook for "Learn Excel 101". The ebook Snack sized chapters for easy learning. Designed for both students and adults. This book provides a quick summary of essential concepts in Learn Excel 101 by following snack sized •What is MS Excel?•What is Microsoft Excel used for?•Basic Operations•VBA Programming•Charts•File Formats Supported•Excel FeaturesGetting •Getting Started•The MS Excel Window•What are Spreadsheets?•Cell Rows and ColumnsWorking with Data •Working with Data•Text•Number•Boolean•Date and Time•Formula•Creating Formulas•Calculating with FunctionsWorking with Data •The IF function•Copy (Cut), and PasteToolbars •Toolbars•Title Bar•Quick Access Toolbar•Taskbar•Formula Bar•Status Bar•Ribbon Menu•Groups•Name Box•File Tab•Home TabToolbars •Toolbars II•Insert Tab•Page Layout TabToolbars •Toolbars III•Formulas Tab•Formulas II•Data Tab•Toolbars IV•Review Tab•View •Formatting I•Formatting in Excel •Working with Cells•Changing an Entry within a Cell•Cut, Copy, and Paste•To Cut or Copy•Formatting Cells•Formatting Rows and Columns•Adding Rows and Columns•Formatting II•Working with ChartsCreating Dropdown •Creating a Dropdown List in Excel•Using a Dropdown List for Data Validation in Excel•Click on the Down Arrow•Entering the Tutorial Data•Opening the Data Validation Dialog Box•Selecting a Type of Data Validation•Entering the Data Source and Completing the Dropdown List•Testing the Dropdown List•Changing the List Items•Options for Protecting the Dropdown ListHiding and Unhiding Columns in •Hide Columns in Excel•To Hide a Single Column•To Hide Adjacent Columns in the Worksheet•To Hide Separated Columns in the Worksheet•Unhide Columns in an Excel Worksheet•To Unhide a Single Column•To Unhide Column A in the Worksheet in Excel 2007 / 2010• To Unhide Multiple Columns in the Worksheet - All Versions of ExcelHow to Protect Data in •Protect Data in Excel•Lock/Unlock Cells in Excel• Unlock Cells in Excel•Protect a Worksheet in Excel•Turning Off Worksheet Protection

146 pages, Kindle Edition

First published September 11, 2013