Microsoft Excel 2013 for the Business Analyst

Name: Microsoft Excel 2013 for the Business Analyst
Availability: OutOfStock
ISBN: 9781285778884

ISBN-10: 128577888X

ISBN-13: 9781285778884

Edition: 2014

Authors: Larry Rockoff

List price: $29.99

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

As one of the most popular software tools in the world, Microsoft Excel is used by business analysts across the globe to keep track of details, look deeply into the data that drives business, and provide managers with the information and insights they need to keep their companies moving forward. MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is an introduction to Excel, written by a business analyst for business analysts. While providing a general overview of the features and functions of Excel, the book places special emphasis on helping users in the task of data analysis. The book begins with a conceptual overview and a discussion of Excel's main components--cells, worksheets, tables,…

Book details

List price: $29.99
Copyright year: 2014
Publisher: Course Technology
Publication date: 10/18/2013
Binding: Paperback
Pages: 416
Size: 8.00" wide x 9.50" long x 1.25" tall
Weight: 1.782
Language: English



Introduction



An Overview of Excel


Excel Components


Cells


Tables


Pivot Tables


Charts and Pivot Charts


External Data


Add-Ins


Data Analysis



The Excel User Interface


Worksheets and Cells


The Ribbon


Home Commands


View Commands


Page Layout Commands


Review Commands


The Backstage View



Getting External Data


Data from Text Files


Data from Microsoft Access


Managing Connections


Data from SQL Server


Microsoft Query



Tables


Table Basics


Table Tools


Sorting


Filters



Pivot Table Basics


The Field List


Field Arrangement and Layout


Expanding and Collapsing Fields


Showing Details


Filters


Slicers


Timelines


Sorting



Pivot Table Calculations


Subtotals and Totals


Grouping


Calculated Items and Fields


Percentages and Ranks


Summarization


Relationships and Data Models



Charts and Pivot Charts


Pivot Chart Basics


Layout Options


Column and Bar Charts


Pie Charts


Line and Radar Charts


Standard Charts


Sparklines



Data Commands


Sorting and Filtering


Subtotals and Grouping


Text to Columns and Flash Fill


Data Validation



Formulas


Formula Basics


Relative and Absolute Cell References


The Name Manager


Formula Auditing


Functions


Nested Functions



Text Functions


Case Conversion


Joining Text


Text Substrings


Finding and Replacing Text


Splitting Text


Converting to and from Text



Numeric and Date Functions


Arithmetic


Rounding


Unit Conversion


Financial Analysis


Dates and Time



Aggregate and Statistical Functions


Sums


Counts


Averages


Percentiles and Ranks


Frequencies and Variability


Correlation and Regression


Array Functions and the Sum of Products



Logical and Lookup Functions


Logical Functions


IS Functions


Lookup Functions



Analysis Tools


Data Analysis


Data Tables


Scenario Manager


Goal Seek


Solver


Index