Read Excel 2013 Mastering the Basics

Excel 2013 Mastering the Basics

Grant Gamble

4.9/5 (12089 ratings)

Description:Excel 2013, a key component of Microsoft Office 2013, is the latest version of the world's most widely used spreadsheet program. Excel 2013 Mastering the Basics uses a practical approach to learning this powerful software tool: analysis of key features, combined with step-by-step tutorials which will reinforce your understanding of what Microsoft Excel is all about. Aimed at beginner to intermediate Excel users, who may already be familiar with earlier Excel versions, this book will provide the practical insights, tips and shortcuts you need to start becoming an Excel power user. Topics include: Using Excel's powerful new features such as Recommended PivotTables, Recommended Charts, Quick Analysis Lens, Timelines, and Flash Fill. Understanding the Excel Interface: the Welcome Screen; the Ribbon, Tabs and Ribbon controls; the Quick Access Toolbar and working in Backstage view. How to build efficient Excel formulas using functions; nested functions; relative, mixed and absolute references; named ranges and 3-D formulas. Customizing the way worksheets appear on screen and at print time: freezing and splitting panes, working with multiple documents windows, using Page Layout mode, setting up headers and footers and creating PDF files. Creating and customizing charts and graphics: practical exercises on creating the different types of Excel charts, creating sparklines, importing and creating graphics and embedding formulas into graphic elements. Working with tabular data: sorting data numerically, chronologically, by colour and by custom order, filtering data and creating multi-level subtotals. Creating and customizing pivot tables, pivot charts and dashboards, featuring slicers and timelines which provide interactive data filtering and exploration. The book also contains an overview of macros and VBA: you will learn how to create macros, using both the Macro Recorder and the Visual Basic Editor.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 2013 Mastering the Basics. To get started finding Excel 2013 Mastering the Basics, 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: 659

Format: PDF, EPUB & Kindle Edition

Publisher: Createspace

Release: 2013

ISBN

Description: Excel 2013, a key component of Microsoft Office 2013, is the latest version of the world's most widely used spreadsheet program. Excel 2013 Mastering the Basics uses a practical approach to learning this powerful software tool: analysis of key features, combined with step-by-step tutorials which will reinforce your understanding of what Microsoft Excel is all about. Aimed at beginner to intermediate Excel users, who may already be familiar with earlier Excel versions, this book will provide the practical insights, tips and shortcuts you need to start becoming an Excel power user. Topics include: Using Excel's powerful new features such as Recommended PivotTables, Recommended Charts, Quick Analysis Lens, Timelines, and Flash Fill. Understanding the Excel Interface: the Welcome Screen; the Ribbon, Tabs and Ribbon controls; the Quick Access Toolbar and working in Backstage view. How to build efficient Excel formulas using functions; nested functions; relative, mixed and absolute references; named ranges and 3-D formulas. Customizing the way worksheets appear on screen and at print time: freezing and splitting panes, working with multiple documents windows, using Page Layout mode, setting up headers and footers and creating PDF files. Creating and customizing charts and graphics: practical exercises on creating the different types of Excel charts, creating sparklines, importing and creating graphics and embedding formulas into graphic elements. Working with tabular data: sorting data numerically, chronologically, by colour and by custom order, filtering data and creating multi-level subtotals. Creating and customizing pivot tables, pivot charts and dashboards, featuring slicers and timelines which provide interactive data filtering and exploration. The book also contains an overview of macros and VBA: you will learn how to create macros, using both the Macro Recorder and the Visual Basic Editor.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 2013 Mastering the Basics. To get started finding Excel 2013 Mastering the Basics, 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.

Special Offer | $0.00

Special Offer! | $0.00

Excel 2013 Mastering the Basics

Excel 2013 Mastering the Basics

More Books

Power BI Step-by-Step Part 1: Up and Running: Power BI Mastery through hands-on Tutorials (Power BI Step by Step)

Power BI Step-by-Step Part 1: Up and Running: Power BI Mastery through hands-on Tutorials (Power BI Step by Step)

unhurryUp! into Easter: A Lenten Pilgrimage

unhurryUp! into Easter: A Lenten Pilgrimage

A Wild and Precious Advent: Waiting, Accepting, Journeying, Birthing

A Wild and Precious Advent: Waiting, Accepting, Journeying, Birthing

InDesign CS5 Automation Using XML & JavaScript

InDesign CS5 Automation Using XML & JavaScript

Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials

Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials

By Grant Gamble InDesign CS5 JavaScript [Paperback]

By Grant Gamble InDesign CS5 JavaScript [Paperback]

Power BI Step-by-Step Part 2: Connecting to Data Sources: Power BI Mastery through hands-on Tutorials

Power BI Step-by-Step Part 2: Connecting to Data Sources: Power BI Mastery through hands-on Tutorials

The Affinity Principle: People First, Always: A Formula For Business Success Through Mindful Leadership

The Affinity Principle: People First, Always: A Formula For Business Success Through Mindful Leadership

Dating Cary Grant by Emelle Gamble (2014-10-23)

Dating Cary Grant by Emelle Gamble (2014-10-23)