phone

0371.781.781

The Microsoft Excel Step-By-Step Training Guide Book Bundle

De (autor): C. J. Benton

review Goodreads
The Microsoft Excel Step-By-Step Training Guide Book Bundle - C. J. Benton

The Microsoft Excel Step-By-Step Training Guide Book Bundle

De (autor): C. J. Benton

review Goodreads

3 books in 1 a consolidation of three books in the Microsoft(R) Excel(R) Step-By-Step Training Guide Series

This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft(R) Excel(R) formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft(R) Excel(R) at your own pace.

In addition to the following, this book bundle also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro .

Part 1 - Excel(R) Formula Fundamentals

  • SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
  • AVERAGE
  • MIN & MAX
  • TODAY & NETWORKDAYS
  • SUMIF

    Part 2 - Pivot Tables & Dashboards

  • Organize and summarize data
  • Format results
  • Insert Pivot Charts
  • Display averages & percentages
  • Group data into predefined ranges
  • Rank results
  • Insert calculated fields
  • How to create and update a basic Dashboard using Pivot Table data

    Part 3 - Excel(R) Features

  • Data Sorting
  • Formula Trace
  • Text-To-Columns
  • Conditional Formatting & Filtering

    Part 4 - Text Functions

  • LEN & TRIM
  • CONCATENATE & MID
  • PROPER, UPPER, & LOWER

    Part 5 - Logic Formulas

  • IF
  • Nested IF

    Part 6 - The VLOOKUP Formula

  • What the VLOOKUP formula does
  • The parts of a VLOOKUP formula
  • Detailed examples on how to use the VLOOKUP formula
  • Incorporating the IFERROR functionality into your VLOOKUP formula
  • How to apply the VLOOKUP formula across multiple tabs & workbooks
  • How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error
    • Citeste mai mult

    -10%

    PRP: 139.42 Lei

    !

    Acesta este Pretul Recomandat de Producator. Pretul de vanzare al produsului este afisat mai jos.

    125.48Lei

    125.48Lei

    139.42 Lei

    Primesti 125 puncte

    Important icon msg

    Primesti puncte de fidelitate dupa fiecare comanda! 100 puncte de fidelitate reprezinta 1 leu. Foloseste-le la viitoarele achizitii!

    Livrare in 2-4 saptamani

    Adauga in cos cart icon

    Descrierea produsului


    3 books in 1 a consolidation of three books in the Microsoft(R) Excel(R) Step-By-Step Training Guide Series

    This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate Microsoft(R) Excel(R) formulas & features, including Pivot Tables, & the VLOOKUP formula. The book bundle is organized into 6 step-by-step sections, allowing you to grow your knowledge of Microsoft(R) Excel(R) at your own pace.

    In addition to the following, this book bundle also includes sections on Excel(R) keyboard shortcuts and how to change the currency symbol, for example to the British Pound or Euro .

    Part 1 - Excel(R) Formula Fundamentals

  • SUM, SUBTRACTION, MULTIPLICATION, & DIVISION
  • AVERAGE
  • MIN & MAX
  • TODAY & NETWORKDAYS
  • SUMIF

    Part 2 - Pivot Tables & Dashboards

  • Organize and summarize data
  • Format results
  • Insert Pivot Charts
  • Display averages & percentages
  • Group data into predefined ranges
  • Rank results
  • Insert calculated fields
  • How to create and update a basic Dashboard using Pivot Table data

    Part 3 - Excel(R) Features

  • Data Sorting
  • Formula Trace
  • Text-To-Columns
  • Conditional Formatting & Filtering

    Part 4 - Text Functions

  • LEN & TRIM
  • CONCATENATE & MID
  • PROPER, UPPER, & LOWER

    Part 5 - Logic Formulas

  • IF
  • Nested IF

    Part 6 - The VLOOKUP Formula

  • What the VLOOKUP formula does
  • The parts of a VLOOKUP formula
  • Detailed examples on how to use the VLOOKUP formula
  • Incorporating the IFERROR functionality into your VLOOKUP formula
  • How to apply the VLOOKUP formula across multiple tabs & workbooks
  • How to troubleshoot and resolve common VLOOKUP errors, including reasons why you may be getting the #N/A or #REF error
    • Citeste mai mult

    Detaliile produsului

    De pe acelasi raft

    De acelasi autor

    Parerea ta e inspiratie pentru comunitatea Libris!

    Acum se comanda

    Noi suntem despre carti, si la fel este si

    Newsletter-ul nostru.

    Aboneaza-te la vestile literare si primesti un cupon de -10% pentru viitoarea ta comanda!

    *Reducerea aplicata prin cupon nu se cumuleaza, ci se aplica reducerea cea mai mare.

    Ma abonez image one
    Ma abonez image one