Microsoft Excel 2013 for the Business Analyst

ISBN-10: 128577888X
ISBN-13: 9781285778884
Edition: 2014
Authors: Larry Rockoff
List price: $29.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Sociology Online content $4.95 $1.99
Add to cart
Study Briefs
Business Ethics Online content $4.95 $1.99
Add to cart
Study Briefs
Business Law Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

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

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, pivot tables, and pivot charts. That material provides an understanding of how Excel summarizes data and paves the way for a detailed exploration of the software's formulas and functions. Written in an easy-to-grasp style, with plenty of helpful screenshots, MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is perfect for analysts who are new to Excel or experienced users who wish to learn more about Excel's business-analysis capabilities.

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

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×