Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    From $11.99/month after trial. Cancel anytime.

    Excel Techniques
    Excel Techniques
    Excel Techniques
    Ebook55 pages43 minutes

    Excel Techniques

    By Online Trainees

    2/5

    ()

    Read preview

    About this ebook

    Excel Techniques Manual

    Target audience:

    Students, business professionals, anybody that is looking to improve there excel knowledge and capabilities

    Time to master:

    A couple of hours to complete the explanations. The more time you spend practising the examples the more proficient you will become.

    LanguageEnglish
    PublisherOnline Trainees
    Release dateApr 17, 2012
    ISBN9781476235417
    Excel Techniques
    Author

    Online Trainees

    Online Trainees produce manuals and courses on various subjects.

    Read more from Online Trainees

    Related to Excel Techniques

    Related ebooks

    Training For You

    View More
    View More

    Related podcast episodes

    Related articles

    • UNLIMITED

      Excel and Calc

      Aug 12, 2019

      Excel and Calc
      5 min read

    • UNLIMITED

      Summary Sheet In Numbers

      Sep 24, 2019

      Summary Sheet In Numbers
      2 min read

    • UNLIMITED

      Make Office Better

      Sep 22, 2021

      Make Office Better
      2 min read

    • UNLIMITED

      Add Data Bars To Cells

      Jul 28, 2021

      Add Data Bars To Cells
      1 min read

    • UNLIMITED

      Harder or Smarter?

      Jun 16, 2022

      hate humanity, but I love humanity so much,” ‘Some Elon Musk, Tesla CEO and prospective Twitter buyer, tweeted on June 5. However, in their responses, his Twitter followers appeared to care less about his feelings toward humanity and more about his t

      4 min read

    • UNLIMITED

      Formulate Your Future With Numbers

      Mar 6, 2018

      Dig deeper into Apple’s spreadsheet app by going beyond its templates. Whether you need to track your budget, monitor investments, or plan a project, these quick tips will get you started. If you’re an ex Excel user and miss its AutoSum function, don

      3 min read

    • UNLIMITED

      Miscrosoft Excel

      Feb 8, 2021

      Miscrosoft Excel
      5 min read

    • UNLIMITED

      Visualise Complex Data In Style Using Timelion

      Oct 20, 2020

      Simon Quain is a site reliability engineer who likes discovering open datasets online to play around with in the Elastic Stack. You’ve probably heard of Elasticsearch – the search engine that enables you to index and then quickly search through your

      9 min read

    • UNLIMITED

      Data Analysis

      Mar 10, 2020

      Sometimes you receive raw data that needs to be processed before plotting. In Veusz, look under the Data > Operations menu and find lots of options for manipulating data sets. Joining, merging, finding the average, filtering and many more are availab

      1 min read

    • UNLIMITED

      Make Office Better

      Mar 10, 2021

      LIBREOFFICE CALC & MICROSOFT EXCEL Calc and Excel both let you generate random numbers. The RAND() formula returns a random number between 0 and 1, while RANDBETWEEN(x, y) lets you specify a range for the random numbers (replace the ‘x’ with the lowe

      2 min read

    • UNLIMITED

      Be A Numbers Whizz Kid

      Apr 2, 2019

      Be A Numbers Whizz Kid
      1 min read

    • UNLIMITED

      Copilot Pro For Excel

      Mar 7, 2024

      Unlike the other Copilot Pro tools, Copilot for Excel is labelled prominently as “beta”. But even in this qualified state, it has the promise of being a game-changer for anyone who needs to work with data but doesn’t want to become an expert in writi

      2 min read

    Related categories

    Reviews for Excel Techniques

    2/5

    1 rating0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      Excel Techniques - Online Trainees

      Excel Techniques

      By

      Online Trainees

      SMASHWORDS EDITION

      *******

      Published by

      Online Trainees at Smashwords

      Excel Techniques

      Copyright 2012 Online Trainees

      Smashwords Edition, License Notes

      This ebook is licensed for your personal enjoyment only. This ebook may not be re-sold or given away to other people. If you would like to share this book with another person, please purchase an additional copy for each recipient. If you’re reading this book and did not purchase it, or it was not purchased for your use only, then please return to Smashwords.com and purchase your own copy. Thank you for respecting the hard work of this author.

      Content

      INTRODUCTION

      Split windows and freeze panes

      Hide and Unhide command

      Moving around a spreadsheet with Ctrl, Shift, and Arrow keys

      Name cells/ranges

      Sort command

      Toggling among relational and absolute references

      Fill down and fill right commands

      IF function

      AND and OR functions

      SUM and SUMIF functions

      Subtotals and Totals

      SUMPRODUCT function

      NPV function

      COUNT functions

      ROUND, ROUNDUP and ROUNDDOWN functions

      VLOOKUP and HLOOKUP functions

      Insert Function command

      Paste Special command

      Auditing features

      Goal Seek add-in

      Solver add-in

      Data tables

      Scenarios add in

      Pivot Tables

      Protecting cells and worksheets

      Editing multiple

      Enjoying the preview?
      Page 1 of 1