Description:Do you want to learn how to use Microsoft Excel, for a career boost or to better handle numbers, lists, and other data? The revised and expanded second edition of Excel Basics In 30 Minutes will quickly get you up to speed with basic spreadsheet concepts, tips, and tricks! Excel Basics In 30 Minutes, 2nd Edition is written in plain English, with lots of step-by-step instructions, screenshots, and examples that demonstrate exactly what to do. Instructions apply to recent versions of Excel, including Excel 2013, Excel for Office 365, and Excel Online. For users who don't own Excel, the guide explains how to use a free online spreadsheets program called Google Sheets.Topics include:* Screen layout, cells, and terminology* Formatting cells and text* AutoFill* Formulas and functions* Charts* Sorting and filtering* Printing* Exporting PDFsThe full table of contents follows:Introduction - Excel: Not just for nerds!Chapter 1 - The basics: cells, functions, and formulas* The different flavors of Excel (and Google Sheets)* Using this guide with Excel and Google Sheets* Firing up Excel and creating a new file* Spreadsheet terminology* Working with cells* Your first spreadsheet formula* Introducing functions with SUM* AutoSum and the one Greek letter you need to know* Quickly accessing other functions* Formatting cells and textExcel Ninja Skill #1: AutoFill* AutoFill magic* Formulas and AutoFill* Dragging to extend functionsChapter 2 - More basic Excel skills: percentages, pasting, and rows* Working with multiple worksheets* How to create a new worksheet* Copy, paste, and paste special* How to duplicate a worksheet* Adding rows* What happens to functions, formulas, and references* Using percentages* Parentheses and PEMDAS* Declining percentages* Static cell references* Spreadsheet division* Referencing other worksheetsExcel Ninja Skill #2: Charts* Chart wizards* Pie charts* Chart options and customizations* Editing charts in Excel* Editing charts in Google SheetsChapter 3 - Sorting and filtering* Sorting* Hiding rows and columns* Rearranging a list in alphabetical order* An alternate sorting scenario* Sorting with multiple criteria* FilteringChapter 4 - Printing, PDFs, and import/export features* Printing* Adjust column widths* Switch from portrait to landscape mode* How to set the print area * Printing cell outlines * Exporting PDFs* Importing and exporting* Importing data into Excel* Exporting data* Exporting chartsExcel Basics In 30 Minutes, 2nd Edition is authored by Ian Lamont, an award-winning technology writer and author of Google Drive & Docs In 30 Minutes.We have made it easy for you to find a PDF Ebooks without any digging. And by having access to our ebooks online or by storing it on your computer, you have convenient answers with Excel Basics in 30 Minutes. To get started finding Excel Basics in 30 Minutes, you are right to find our website which has a comprehensive collection of manuals listed. Our library is the biggest of these that have literally hundreds of thousands of different products represented.
Description: Do you want to learn how to use Microsoft Excel, for a career boost or to better handle numbers, lists, and other data? The revised and expanded second edition of Excel Basics In 30 Minutes will quickly get you up to speed with basic spreadsheet concepts, tips, and tricks! Excel Basics In 30 Minutes, 2nd Edition is written in plain English, with lots of step-by-step instructions, screenshots, and examples that demonstrate exactly what to do. Instructions apply to recent versions of Excel, including Excel 2013, Excel for Office 365, and Excel Online. For users who don't own Excel, the guide explains how to use a free online spreadsheets program called Google Sheets.Topics include:* Screen layout, cells, and terminology* Formatting cells and text* AutoFill* Formulas and functions* Charts* Sorting and filtering* Printing* Exporting PDFsThe full table of contents follows:Introduction - Excel: Not just for nerds!Chapter 1 - The basics: cells, functions, and formulas* The different flavors of Excel (and Google Sheets)* Using this guide with Excel and Google Sheets* Firing up Excel and creating a new file* Spreadsheet terminology* Working with cells* Your first spreadsheet formula* Introducing functions with SUM* AutoSum and the one Greek letter you need to know* Quickly accessing other functions* Formatting cells and textExcel Ninja Skill #1: AutoFill* AutoFill magic* Formulas and AutoFill* Dragging to extend functionsChapter 2 - More basic Excel skills: percentages, pasting, and rows* Working with multiple worksheets* How to create a new worksheet* Copy, paste, and paste special* How to duplicate a worksheet* Adding rows* What happens to functions, formulas, and references* Using percentages* Parentheses and PEMDAS* Declining percentages* Static cell references* Spreadsheet division* Referencing other worksheetsExcel Ninja Skill #2: Charts* Chart wizards* Pie charts* Chart options and customizations* Editing charts in Excel* Editing charts in Google SheetsChapter 3 - Sorting and filtering* Sorting* Hiding rows and columns* Rearranging a list in alphabetical order* An alternate sorting scenario* Sorting with multiple criteria* FilteringChapter 4 - Printing, PDFs, and import/export features* Printing* Adjust column widths* Switch from portrait to landscape mode* How to set the print area * Printing cell outlines * Exporting PDFs* Importing and exporting* Importing data into Excel* Exporting data* Exporting chartsExcel Basics In 30 Minutes, 2nd Edition is authored by Ian Lamont, an award-winning technology writer and author of Google Drive & Docs In 30 Minutes.We have made it easy for you to find a PDF Ebooks without any digging. And by having access to our ebooks online or by storing it on your computer, you have convenient answers with Excel Basics in 30 Minutes. To get started finding Excel Basics in 30 Minutes, you are right to find our website which has a comprehensive collection of manuals listed. Our library is the biggest of these that have literally hundreds of thousands of different products represented.