Free shipping on all orders over $79* Limited Time Only
Track My Order
Help Centre
Likes
My Wish ListsLogin / Join
Booktopia
Australia's local bookstore
Get Free Shipping on orders over $79
The Microsoft Excel Data Analysis Toolkit Bundle - Simon Sez IT

The Microsoft Excel Data Analysis Toolkit Bundle

By: Simon Sez IT

eText | 29 July 2021 | Edition Number 1

At a Glance

eText

$193.59

or 4 interest-free payments of $48.40 with

 or 

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

In this four-course bundle, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business.

In Excel for business analysts, you will learn to clean raw data and look at a number of tools and functions that can be used to conduct analysis. Finally, we move onto some more advanced techniques designed to aid forecasting and use existing data to predict future trends.

In Advanced Excel 2019, you will gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

Advanced PivotTables starts with a PivotTable refresher and then goes on to discuss advanced sorting, slicers, timelines, calculated fields, pivot charts, and conditional formatting.

In Advanced Formulas, learn the Excel formulas and tools that enable you to perform complex tasks and analyses.

Filtering a dataset, sorting using formulas, creating multi-dependent drop-down lists, 2-way look-ups, text extraction, dynamic chart titles, and XLOOKUP are a few of the exciting concepts covered in the course.

By the end of the course, you will become an expert in data analysis with Excel.

You can find all the resources for the course at https://github.com/PacktPublishing/The-Microsoft-Excel-Data-Analysis-Toolkit-Bundle

on
Desktop
Tablet
Mobile

You Can Find This eBook In

Non-FictionComputing & I.T.Business ApplicationsSpreadsheet SoftwareEnterprise SoftwareDatabasesData Capture & Analysis

More in Spreadsheet Software

ITIL Service Management - Nathan Beckford

eBOOK

ITIL Service Management

eBook

$9.99

Smartsheet For Everyone - Ken Armstrong

eBOOK

Smartsheet For Everyone

eBook

$30.99

Generative AI with RAG - Compiled & Arranged by BRAHIM TIMEZGHINE

eBOOK

Generative AI with RAG

eBook

$37.99

This product is categorised by