M.U.P.P.I.X. purveyors of fine Data Analysis Tools
  • Home
    • Applications
    • Blog
    • About
    • Clients
    • Company
    • Other Links
  • Training
  • Get Started
    • Muppix Keywords
    • Glossary find Keywords
    • Templates >
      • Capture
      • Explore
      • Clean-up
    • Approach to BigData
  • Linux Cheatsheet
    • Linux Cheatsheet 2
    • Essential Terminal Commands
    • Basic Linux Commands
  • SQL & Excel Commands
    • SQL Cookbook
    • SQL Cookbook 2
    • SQL search entire DataBase
    • SQL Import Table Tool
    • Excel OneLiners
  • Download

Muppix commands now also in Excel 

Open the Reference Card spreadsheet

​Search commands in the [Find Basic Commands] tab

showing Muppix commands and if there is an equivalent Excel Command

   All yellow cells are input cells
      All orange cells show the results
      sometimes the results also need a calc cell

For some commands you need to tab to the right and then tab  up to the 1st row
These commands are more suited for calculations that involve columns
ie  sort  columns

All the commands are interactive - change the yellow cells and the results will change
you should be able to copy the whole command into your sheet. Don’t forget to also copy any yellow cell & calc cell at the same time.


Search for Muppix commands In tab [Find Basic Commands] - Basic commands only 
 
Go directly to the Reference Card spreadsheet here:
drive.google.com/open?id=1TCJhVkAN910o78ATumtEjlgI_ZPkeAbzTU1gAybZ9C8

A Comprehensive way to learn advanced Excel.

Picture

 

Muppix provides innovative solutions and Training to make sense of large scale data.
Backed by years of industry experience, the Muppix Team have developed a Free Data Science Toolkit to extract and analyse multi-structured information from diverse data sources


Company

Blog

Training

Professional Services

Get Started