rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: Mastering Excel through projects
    sub title: a learn-by-doing approach from payroll to crypto to data analysis
  name:
    name part: Zhou, Hong
    role:
      role term: creator
    role:
      role term: author.
  type of resource: text
  genre: elektronické knihy
  genre: electronic books
  origin info:
    place:
      place term: nyu
    date issued: 2022
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource : illustrations
  abstract: Master Excel in less than two weeks with this unique project-based book! Lets face it, we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and get up to speed quickly. Whether you are just getting started with Excel or are an experienced user, this book will elevate your knowledge and skills. For a beginner, the micro examples in each chapter will warm you up before you dive into the projects. For experienced users, the projects, especially those with table setup considerations, will help you become more creative in your interactions with Excel. Readers will benefit from building eight unique projects, each covering a different topic, including a word game, a food nutrition ranking, a payroll (tax withholding) calculation, an encryption, a two-way table, a Kaplan-Meier analysis, a data analysis via a pivot table and the K-means Clustering data mining method. Through these projects, you will experience firsthand how Excel skills are organized together to accomplish tasks that sound complex and daunting when first described. Get started with a word game which asks users to find English words that amount to exactly 100 points, with each letter of the alphabet assigned a point 1, 2, 3, 26, respectively. You will disassemble a word into letters and then sum up their points, and then take it one step further, contemplating how to make the completed Excel worksheet more user friendly and completely automated. Increasingly challenging tasks like this example build on what you have learned and increase your confidence along the way, ensuring your mastery of Excel. What You Will Learn Gain confidence to tackle a challenging Excel-related mission, even those that seem impossible Become skilled in the creative uses of Excel formulas and functions and other built-in features Appreciate the art of refining worksheets to maximize automation Understand the value of treating each worksheet as a unique product This b…
  table of contents: Chapter 1: Master Excel through Projects -- Chapter 2: Food Nutrition Ranking -- Chapter 3: Payroll Calculation -- Chapter 4: Public and Private Key Cryptography -- Chapter 5: Two-Way Table and Chi-Square Test -- Chapter 6: Kaplan-Meier Analysis -- Chapter 7: PivotTable Data Analysis -- Chapter 8: K-means Clustering and Iterative Calculation.
  note: Hong Zhou.
  note: Includes index.
  note: Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty
  subject:
    title info:
      title: Microsoft Excel (Computer file)
  subject:
    title info:
      title: Microsoft Excel (Computer file)
  related item:
    identifier: (OCoLC)1273075627
  identifier: 9781484278420
  identifier: 1484278429
  identifier: 1484278410
  identifier: 9781484278413
  identifier: https://proxy.k.utb.cz/login
  access condition: Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty
  record info:
    record content source: YDX
    record creation date: 211202
    record change date: 20240717213016.0
    record identifier: kn-on1286955017
    language of cataloging:
      language term: eng