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

Wednesday, October 31, 2018

Windows NT delete user completely

https://windowsreport.com/fix-signed-in-temporary-profile-windows-10/

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

Wednesday, September 5, 2018

Sticking to what you know is right and believe in

This is hard for me but I know how it is to fulfill a vow and look Back with delight.

And as much as I can be I support in observing one I would. It could entail what I do and what I don't do.

I like, love very much. It is in the infancy but I have to hold back.

Wednesday, June 27, 2018

Grace over caution

I want to thank God for keeping me and pillion safe , my front wheel nut totally off, front brake cable tore and front sprocket locker broke while at moderate speed. I'm grateful the front wheel didn't come off despite the shaking and the sprocket not coming off with the chain. Thank you God. Take away is to regularly check our bikes and give thanks.

Saturday, March 10, 2018

Friendship, Love, Intimacy, Forever

I have recently had a glimpse at these, and I realize it is wonderful.

I really cherish the order of the "title", I believe it shouldn't be reversed. They are essential components to life.

They are enveloped within good communication skills among both parties.

Willingness to learn and adapt, knowing; when to hold back, how to complain, understand each other, stick to agreements, keeping one's word.

I love you.

Sometimes we inquire into life. At times we find what we're looking for, others none.

Thanks W.

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...