Here's WHAT you'll learn:Manage your financial data and personal expenses Get started quickly with prebuilt templates Create formulas and functions to do the hard work Sort, filter, update, and copy your data Use charts and graphics to bring data to life Collaborate with colleagues by sharing spreadsheets online
Here's HOW you'll learn it:Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Focus on the expertise measured by these objectives:
Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service
This Microsoft Exam Ref:
Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI
Excel Basics In 30 Minutes, 2nd Edition is written in plain English, with lots of step-by-step instructions and screenshots that demonstrate exactly what to do. This MS Excel tutorial references Excel 2016, but most of the step-by-step instructions apply to earlier versions of MS Excel released as part of the Microsoft Office and Office 365 suites, including Excel 2013 and Excel 2010. If you don't own Excel, the book explains how to use two free online spreadsheets programs: Excel Online and Google Sheets (part of the Google Drive online office suite). The book also covers the Excel mobile apps: Excel for Android and Excel for iOS.
Topics in this top-selling Excel book include:
* Excel screen layout, cells, and terminology
* Excel 2016 vs. Excel Online vs. Google Sheets
* Basic Excel formatting
* Excel formulas and functions
* How to make charts in Excel
* Sorting and filtering
* Collaboration and sharing
* Exporting PDF, CSV, and other forms
* Printing tips
* Excel import and export formats (PDF, .CSV, .TSV, text, etc.)
This is not an Excel bible, but rather a basic Excel tutorial and reference that answers the core questions that any new Excel user will have:
* What is a spreadsheet?
* What are cells?
* What is the button with the Greek letter for?
* How can Excel spreadsheets create basic financial projections?
* How can certain data in a worksheet be highlighted?
* How can data be alphabetized or ranked?
* How to edit a chart in Excel
* How to print an Excel spreadsheet without cutting off columns
The second edition is up-to-date with new instructions and high-resolution screenshots of Excel 2016, Excel Online, and the new Google Sheets. It includes new sections about collaboration, OneDrive, and other features.
Here are some real reader reviews of Excel Basics In 30 Minutes:
“Fast and easy, this book is everything it claims to be. The material presented is very basic but it is also incredibly accessible with step-by- step screenshots and a friendly tone more like a friend or co-worker explaining how to use Excel than a technical manual.”
"One thing I particularly liked about 'Excel Basics in 30 minutes' is that it covers BOTH the MS Excel basics and the Google version basics. Explaining anything this intricate in 30 minutes is a challenge. (Can it be read in 30 minutes? Yes, I could do it, but I am not a typical user, I did not need to stop and practice the examples.) I was impressed that the book does go into some of the ‘meat’ of Excel while still being a book that someone with NO previous exposure to a spreadsheet can grasp.”
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, Twitter In 30 Minutes, and Dropbox In 30 Minutes.