Excel Tutorial pdf Free Download

Are you really eager to learn how to use Excel, the popular Microsoft spreadsheet app? You’ve come to the right place. Microsoft Office is actually a very powerful software application and has numerous features that will help you streamline your day-to-day work tasks.

Are you really eager to learn how to use Excel, the popular Microsoft spreadsheet app? You’ve come to the right place. Microsoft Office is actually a very powerful software application and has numerous features that will help you streamline your day-to-day work tasks.

Would you hunt for long without obtaining answers? Then you have just finished your search, because you no longer need to look. I ‘m giving you the latest information on this stuvera platform where you can access the books in computer software Excel Tutorial pdf Free Download at no cost or registration. You ‘re waiting for what? All the PDF books you need on the stuvera web, right now at your fingertips!

ABOUT Excel Tutorial pdf Free Download

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 PDFs



TABLE OF CONTENTS: Excel Tutorial pdf Free Download

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 text

Excel Ninja Skill #1: AutoFill
* AutoFill magic
* Formulas and AutoFill
* Dragging to extend functions

Chapter 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 worksheets

Excel Ninja Skill #2: Charts
* Chart wizards
* Pie charts
* Chart options and customizations
* Editing charts in Excel
* Editing charts in Google Sheets

Chapter 3 – Sorting and filtering
* Sorting
* Hiding rows and columns
* Rearranging a list in alphabetical order
* An alternate sorting scenario
* Sorting with multiple criteria
* Filtering

Chapter 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 charts

Excel 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. 

Leave a Comment