Saturday, July 29, 2023

IMPACT Initiatives: Senior Assessment Officer

   
IMPACT Initiatives is currently looking for a Senior Assessment Officer to join the Global Humanitarian Planning and Prioritization Unit in HQ.

Contract duration: Open-ended

Start date: September 2023

Under the supervision of the Global Humanitarian Planning and Prioritization unit (HPPU) manager, the SAO will lead and support on various initiatives within the Research & Development workstream of the HPPU related to inter-sectoral analysis as well as global and cross-crisis analysis using MSNA data collected at national level. The individual fulfilling this role will play a critical function in providing technical, programmatic, and strategic support to a high profile and impactful work stream on the global REACH team.

Read more and apply at: https://www.impact-initiatives.org/work-with-us/vacancies/senior-assessment-officer-global-humanitarian-planning-and-prioritization-unit/

IRC Supply Chain Coordinator

   
The Supply Chain Coordinator is responsible for the organization, valuation, procurement, and tracking of both purchased goods and in-kind donations, working closely with the Operations Supervisor and Inventory Specialist to ensure that supplies are delivered to clients and staff effectively at the Welcome Center. They are the primary point of contact for all procurement and purchasing areas. They are the primary supply chain point person for all financial system coordination, as well as for the inventory systems and data entry. The Supply Chain Coordinator will coordinate closely with internal stakeholders to streamline existing workflow systems, as well as help design, implement and upkeep new inventory/logistics protocols and systems.

Location: Phoenix, AZ USA

Compensation: USD 23.41 - 26.41 Hourly

Friday, July 28, 2023

List of Microsoft Excel shortcuts

   

Learning to use Microsoft Excel (or Google Sheets) is one of the best decisions you make in your career.

Excel is a paid Microsoft software while the equivalent which is available for free is Google Sheets.

Learn to use Excel or Sheets to organize data and create charts, tables, etc. for presentation or analyzing patterns and trends. This can help you, your organization or company see the big picture, make informed decisions, and solve problems efficiently.

In a world where job competition is high, mastering Microsoft Excel will excel your career and position you as a valuable employee. It doesn't matter if you are a student or what your careered is. You can even use it for your personal finance.

Memorizing and practicing these shortcuts will dramatically save you time and money, while increasing efficiency and productivity.

Numbers

CTRL + 1 Format Cells

CTRL + 2 Bold font

CTRL + 3 Italic font

CTRL + 4 Underline

CTRL + 5 Strikethrough

CTRL + 6 Show/Hide an Object

CTRL + 7 Show/Hide the Toolbar

CTRL + 8 Toggle Outline Symbols

CTRL + 9 Hide Rows

 CTRL + 0 Hide Columns

Letters

CTRL + A  Select All

CTRL + B  Toggle BOLD (font)

CTRL + C  Copy

CTRL + D  Fill Down

CTRL + E  Flash Fill

CTRL + F  Find

CTRL + G  Go To

CTRL + H  Find and Replace

CTRL + I  Toggle Italic (font)

CTRL + J  Input line break (in Find and Replace) 

CTRL + K  Insert Hyperlink

CTRL + L  Insert Excel Table 

CTRL + M  Not Assigned

CTRL + N  New Workbook

CTRL + O  Open

CTRL + P  Print

CTRL + Q  Quick Analysis 

CTRL + R  Fill Right

CTRL + S  Save

CTRL + T Insert Excel Table

CTRL + U Toggle underline (font) 

CTRL + V Paste (when something is cut/copied)

CTRL + W Close the current workbook

CTRL + X Cut

CTRL + Y Redo (Repeat last action)

CTRL + Z Undo

Keys

CTRL +’ Copy a Formula from the Cell Above

CTRL +” Copy a Value from the Cell Above

CTRL + < Copy a Formula from the Cell Above

CTRL + > Copy a Formula from Cell to Left

CTRL + Tab Next Workbook

CTRL + Backspace Jump  to the Active Cell

CTRL + Spacebar Select an Entire Column

CTRL + Insert Copy

CTRL + Home Go to Beginning of Worksheet

CTRL + Page Up Go to Previous Worksheet

CTRL + Page Down Go to Next Worksheet

CTRL + Delete  Delete

CTRL + End Go to the Intersection of the Last used Row and Column

Symbols

CTRL + ` Toggle Formula

CTRL + ~ General Format

CTRL + !  Number Format

CTRL + @ Time Format

CTRL + # Date Format

CTRL + $ Currency Format

CTRL + % Percent Format

CTRL + ^ Exponential Format

CTRL + & Outside Borders

CTRL + * Select Current Region

CTRL + ( Unhide Rows

CTRL + ) Unhide Columns

CTRL + - Delete

CTRL + _ Remove Border

CTRL + + Insert

CTRL + = Insert

CTRL +; Insert Current Date

CTRL +:  Insert Current Time

Functions

CTRL + F1 Collapse the Ribbon

CTRL + F2 Print Preview

CTRL + F3 Name Manager

CTRL + F4 Close

CTRL + F5 Restore Window Size

CTRL + F6 Next Workbook

CTRL + F7 Move Window

CTRL + F8 Resize Window

CTRL + F9 Minimize Workbook

CTRL + F10 Maximize Workbook

CTRL + F11 Insert a Macro Sheet

CTRL + F12 Open a File

Extras

CTRL + Tab = Next Workbook

CTRL + Shift + Tab = Previous Workbook

CTRL + Backspace = Jump Back to Active Cell

CTRL + Spacebar = Select Entire Column

CTRL + Shift + Spacebar = Select All

CTRL + Insert = Copy

CTRL + Home = Beginning of Worksheet

CTRL + Page Up = Previous Worksheet

CTRL + Page Down = Next Worksheet

CTRL + Delete = Delete

CTRL + End = Intersection of Last used Row and Column

CTRL + Shift + L = Toggle filters on/off.

CTRL + Shift + $ = Apply current formatting

CTRL+ Enter = Fill Selected Range with Current Entry

Alt + Enter: Start a new line within a cell.


Human Resources Generalist, Temporary ICAP at Columbia

   
Reporting to the ICAP Senior Human Resources (HR) Manager, the Human Resources Generalist is responsible for providing day-to-day guidance to ICAP New York on a range of HR-related activities including full cycle recruitment, on-boarding, promotions, staff retention and end of employment procedures. The incumbent will provide high level customer service to all colleagues and engage with Mailman School of Public Health (MSPH) Faculty Affairs and Human Resources and Columbia University Irving Medical Center (CUIMC) Human Resources to effectively and efficiently support ICAP’s HR needs.
  • Job Type: Officer of Administration
  • Regular/Temporary: Temporary
  • End Date if Temporary: 11/30/2023
  • Hours Per Week: 35
  • Salary Range: $70,000 - $80,000

Thursday, July 27, 2023

DSU scholarship

   
Students can apply for the scholarship provided by the Agenzia Regionale Diritto allo Studio Universitario – DSU is the agency for the University Study Right of the Tuscany Regional Council (Regione Toscana).

A DSU grant includes 
  • free accommodation
  • free meals at the University dining halls
  • contribution to cover extra expenses (sporting activities, books, etc.)
  • exemption from University tuition fees.
For a.y. 2023/2024 the deadline for the DSU Scholarship application is 6 September 2023.

The Gates Scholarship 2023 For International Students

   
Scholars will receive funding for the full cost of attendance* that is not already covered by other financial aid and the expected family contribution, as determined by the Free Application for Federal Student Aid (FAFSA), or the methodology used by a Scholar’s college or university.

*Cost of attendance includes tuition, fees, room, board, books, and transportation, and may include other personal costs.

More information at https://www.thegatesscholarship.org/scholarship

Medtronic recalls defibrillators - ICDs and CRT-Ds

 
Medtronic is recalling all ICDs and CRT-Ds, manufactured after 2017, with a glassed feedthrough, as they may deliver low or no energy output when high voltage therapy is needed due to inappropriate activation of the Short Circuit Protection (SCP) feature.

The products are the Cobalt XT, Cobalt, Crome ICDs, Claria MRI, Amplia MRI, Compia MRI, Viva and Brava CRT-Ds and the Visia AF, Visia AF MRI, Evera, Evera MRI, Primo MRI and Mirro MRI ICDs.
The recall involves about 348,616 defibrillators distributed in the United States from Oct. 13, 2017, to June 9, 2023.

A reduced-energy shock, or no shock at all, may fail to correct a life-threatening arrhythmia, which can lead to cardiac arrest, other serious injury, or death. There are additional risks of harm if a patient with one of these devices needs additional surgical procedures to remove and replace the device.

Medtronic reports 28 incidents, 22 injuries, and no deaths for this issue.

Who May be Affected?
  • People implanted with affected ICDs and CRT-Ds.
  • Health care providers who implant and manage patients with ICDs and CRT-Ds.