{"product_id":"2940148427223","title":"Learn Excel 101","description":"***** WAGmob: Over One million paying customer *****\u003cbr\u003e\u003cbr\u003eWAGmob brings you Simple 'n Easy, on-the-go learning ebook for \"Learn Excel 101\". \u003cbr\u003e\u003cbr\u003eThe ebook provides: \u003cbr\u003e\u003cbr\u003eSnack sized chapters for easy learning. \u003cbr\u003e\u003cbr\u003eDesigned for both students and adults. \u003cbr\u003e\u003cbr\u003eThis book provides a quick summary of essential concepts in Learn Excel 101 by following snack sized chapters: \u003cbr\u003e\u003cbr\u003eIntroduction:\u003cbr\u003e• What is MS Excel?\u003cbr\u003e• What is Microsoft Excel used for?\u003cbr\u003e• Basic Operations\u003cbr\u003e• VBA Programming\u003cbr\u003e• Charts\u003cbr\u003e• File Formats Supported\u003cbr\u003e• Excel Features\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eGetting Started:\u003cbr\u003e• Getting Started\u003cbr\u003e• The MS Excel Window\u003cbr\u003e• What are Spreadsheets?\u003cbr\u003e• Cell References: Rows and Columns\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eWorking with Data I:\u003cbr\u003e• Working with Data\u003cbr\u003e• Text\u003cbr\u003e• Number\u003cbr\u003e• Boolean\u003cbr\u003e• Date and Time\u003cbr\u003e• Formula\u003cbr\u003e• Creating Formulas\u003cbr\u003e• Calculating with Functions\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eWorking with Data II:\u003cbr\u003e• The IF function\u003cbr\u003e• Copy (Cut), and Paste\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eToolbars I:\u003cbr\u003e• Toolbars\u003cbr\u003e• Title Bar\u003cbr\u003e• Quick Access Toolbar\u003cbr\u003e• Taskbar\u003cbr\u003e• Formula Bar\u003cbr\u003e• Status Bar\u003cbr\u003e• Ribbon Menu\u003cbr\u003e• Groups\u003cbr\u003e• Name Box\u003cbr\u003e• File Tab\u003cbr\u003e• Home Tab\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eToolbars II:\u003cbr\u003e• Toolbars II\u003cbr\u003e• Insert Tab\u003cbr\u003e• Page Layout Tab\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eToolbars III:\u003cbr\u003e• Toolbars III\u003cbr\u003e• Formulas Tab\u003cbr\u003e• Formulas Tab: II\u003cbr\u003e• Data Tab\u003cbr\u003e• Toolbars IV\u003cbr\u003e• Review Tab\u003cbr\u003e• View Tab\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eFormatting:\u003cbr\u003e• Formatting I\u003cbr\u003e• Formatting in Excel \u003cbr\u003e• Working with Cells\u003cbr\u003e• Changing an Entry within a Cell\u003cbr\u003e• Cut, Copy, and Paste\u003cbr\u003e• To Cut or Copy\u003cbr\u003e• Formatting Cells\u003cbr\u003e• Formatting Rows and Columns\u003cbr\u003e• Adding Rows and Columns\u003cbr\u003e• Formatting II\u003cbr\u003e• Working with Charts\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eCreating Dropdown List:\u003cbr\u003e• Creating a Dropdown List in Excel\u003cbr\u003e• Using a Dropdown List for Data Validation in Excel\u003cbr\u003e• Click on the Down Arrow\u003cbr\u003e• Entering the Tutorial Data\u003cbr\u003e• Opening the Data Validation Dialog Box\u003cbr\u003e• Selecting a Type of Data Validation\u003cbr\u003e• Entering the Data Source and Completing the Dropdown List\u003cbr\u003e• Testing the Dropdown List\u003cbr\u003e• Changing the List Items\u003cbr\u003e• Options for Protecting the Dropdown List\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eHiding and Unhiding Columns in Excel:\u003cbr\u003e• Hide Columns in Excel\u003cbr\u003e• To Hide a Single Column\u003cbr\u003e• To Hide Adjacent Columns in the Worksheet\u003cbr\u003e• To Hide Separated Columns in the Worksheet\u003cbr\u003e• Unhide Columns in an Excel Worksheet\u003cbr\u003e• To Unhide a Single Column\u003cbr\u003e• To Unhide Column A in the Worksheet in Excel 2007 \/ 2010\u003cbr\u003e•                To Unhide Multiple Columns in the Worksheet - All Versions of Excel\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eHow to Protect Data in Excel:\u003cbr\u003e• Protect Data in Excel\u003cbr\u003e• Lock\/Unlock Cells in Excel\u003cbr\u003e• Example: Unlock Cells in Excel\u003cbr\u003e• Protect a Worksheet in Excel\u003cbr\u003e• Turning Off Worksheet Protection\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eExcel Keyboard Shortcuts I:\u003cbr\u003e• Keyboard Shortcuts\u003cbr\u003e• Navigate inside Worksheets\u003cbr\u003e• Work with Data Selections\u003cbr\u003e• Insert and Edit Data: I\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eExcel Keyboard Shortcuts II:\u003cbr\u003e• Insert and Edit Data: II\u003cbr\u003e• Formulas and Names\u003cbr\u003e• Manage Multiple Worksheets\u003cbr\u003e• Manage Multiple Workbooks\u003cbr\u003e• Various Excel Features\u003cbr\u003e• Work with the Excel Ribbon\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eWorking with Charts I:\u003cbr\u003e• What is a Chart? \u003cbr\u003e• Components of a Chart\u003cbr\u003e• Guidelines for Creating Charts  \u003cbr\u003e• Charting Non-Contiguous Data  \u003cbr\u003e• Locations for Charts\u003cbr\u003e• Creating a Basic Chart\u003cbr\u003e• Moving and Sizing Embedded Charts\u003cbr\u003e• Charting Tools - Contextual Tabs\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eWorking with Charts II:\u003cbr\u003e• 3D Charts \u0026amp; Rotating\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eMacros, Pivot Tables and inserting Hyperlink\u003cbr\u003e\u003cbr\u003eAbout WAGmob books:\u003cbr\u003e1) A companion ebook for on-the-go, bite-sized learning.\u003cbr\u003e2) Offers value for money (a lifetime of free updates).\u003cbr\u003e3) Over One million paying customers from 175+ countries.\u003cbr\u003e\u003cbr\u003eWAGmob Vision : Simple 'n easy ebooks for a lifetime of on-the-go learning.\u003cbr\u003e\u003cbr\u003eVisit us : www.wagmob.com\u003cbr\u003e\u003cbr\u003ePlease write to us at Team (at)wagmob.com\u003cbr\u003eWe would love to improve this ebook\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e","brand":"WAGmob","offers":[{"title":"Default Title","offer_id":47181555499248,"sku":"2940148427223","price":2.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/2940148427223_p0.jpg?v=1763702852","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/2940148427223","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}