Everand Logo

Welcome to Everand!

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

    Only $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

    • Article

      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

    • Article

      Excel and Calc

      Aug 12, 2019

      Excel and Calc
      5 min read

    • Article

      Miscrosoft Excel

      Feb 8, 2021

      Miscrosoft Excel
      5 min read

    • Article

      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

    • Article

      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

    • Article

      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

    • Article

      Be A Numbers Whizz Kid

      Apr 2, 2019

      Be A Numbers Whizz Kid
      1 min read

    • Article

      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

    • Article

      Clever CAD Coding For Clients And Cigars

      Apr 2, 2024

      Credit: http://openscad.org Tam Hanna’s minimal creative capability makes him ideally suited to teaching all kinds of workarounds for problems that require the use of creativity. Catch up by ordering back issues on page 58! The experiments performed

      7 min read

    • Article

      Visualising Experimental Results

      Mar 10, 2020

      All the examples in the main part of this tutorial generated results purely within LibreOffice Calc, using the laws of maths. However, it is also useful for creating graphs of experimental results, perhaps combined with equivalent results from simula

      1 min read

    • Article

      MICROSOFT EXCEL & LIBREOFFICE CALC

      Jun 2, 2021

      Both Excel and Calc let you temporarily hide specific rows simply by selecting the relevant rows, right-clicking that selection within the rows column, then clicking Hide (Excel) or Hide Rows (Calc). However, if you want to calculate the sum of only

      1 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