Monday, October 28, 2019

Productivity with spreadsheets, a beginner's quick tip pointers

Using Spreadsheets Applications Productively. ...

The below pointers are only meant to stimulate thought and eventual activities that would kickstart or steer users in the right direction. This is continuation of the "excel" series

In our existence most things have a creator, a purpose and a method; so are these productivity tools as well. An open and inquiring mind can lead us to discovering the mostly intuitive set of tools at our disposal

Understand the basic terminologies and structures

  • Structure of spreadsheet
  • Rows columns cell
  • menus
  • References absolute relative
  • ranges, named ranges
  • Formula bar= function structure, arguments, criteria ,nesting, conditions, operators (&)


Example functions
(Sum, count, left, uppercase, network days, eomonth, mid, if, or , and , not, date, time, indirect, concatenate)

Necessary "must knows"


  • Paste special
  • Text auto formatting characteristics ' 
  • Cell Formatting
  • Page layout, formatting grid lines
  • Data Validation
  • Protect cells, sheets
  • Drop down list
  • Autofill
  • Shortcuts
  • Conditional formatting
  • Data Sorting - basic advanced
  • Data Filter - value, colour
  • Autocorrect

Good to know


  • Display formulas
  • Data Lookup
  • Charting
  • Data Tables
  • Pivot Table
  • Record and modify a simple macro.
  • Import Data
This just represents a sample of ideas and knowledge to have for effectiveness and should stimulate further studies.

Friday, January 18, 2019

Generic USB Ethernet Adaptor for Mac OS

i have the JP-1081B

From Recovery Mode
run the below in terminal
csrutil disable

reboot

download driver from

http://mylabsk.blogspot.com/2012/02/generic-usb-20-10100m-ethernet-adaptor.html


install and reboot

run the below in terminal

sudo kextload /System/Library/Extensions/USBCDCEthernet.kext

reboot


source

https://inkandfeet.com/how-to-use-a-generic-usb-20-10100m-ethernet-adaptor-rd9700-on-mac-os-1011-el-capitan

Productivity with spreadsheets, a beginner's quick tip pointers

Using Spreadsheets Applications Productively. ... The below pointers are only meant to stimulate thought and eventual activities that wou...