Read Anywhere and on Any Device!

Special Offer | $0.00

Join Today And Start a 30-Day Free Trial and Get Exclusive Member Benefits to Access Millions Books for Free!

Read Anywhere and on Any Device!

  • Download on iOS
  • Download on Android
  • Download on iOS

Excel Basics in 30 Minutes

Ian Lamont
4.9/5 (32676 ratings)
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.
Pages
102
Format
PDF, EPUB & Kindle Edition
Publisher
i30 Media
Release
2015
ISBN

Excel Basics in 30 Minutes

Ian Lamont
4.4/5 (1290744 ratings)
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.
Pages
102
Format
PDF, EPUB & Kindle Edition
Publisher
i30 Media
Release
2015
ISBN
loader