Blog

Insert raw/column in Excel

16 October 2018 | 

Select raw   Shift + Spacebar / Select column   Ctrl + Spacebar

Insert new raw/column above the selected raw   Ctrl + Shift + +

Categories: Blog, Clients, Employees, Facebook
Tags: ,

Non-breaking space in Powerpoint

2 October 2018 | 

This one is for perfectionists. Unfortunately, Power Point does not support Ctrl + Shift + Space for non-breaking space.

  1. Hold right Alt;
  2. Dial “0160” on the numeric keypad;
  3. Release right Alt.

Voilà!

Categories: Clients, Employees, Facebook
Tags: ,

A2B Pull Learning Concept

21 September 2018 | 

One of the concepts that we are going to base our upcoming basic accounting training course upon is what we call “The Pull Learning Concept”.

Our traditional education is based on what I call “Push learning” model, i.e., knowledge is purshed into the students. Students come to a school, college or university and study what they are offered to learn.”

In the last few years, another learning model that I call “Pull learning” has started to evolve. In this model students have a strong desire to learn and take responsibility for getting the knowledge. For example, there are may internet resources where one can learn programming and other skills. My mom learns new recepies watching you tube videos. (Actually, she cooks so well that she should be making such videos herself.)

The main idea of A2B approach to learning is to shift accent from teacher giving knowledge to student getting (pulling) the knowledge.

Responsibility for the result is shifted from teacher to student – the student has 100% responsibility for the result.

A2B Role is to:

  • Propose the student curriculum and learning goals;
  • Give tools to evaluate success;
  • Give access to teachers (people who posess and share the knowledge) – this is not critical as people can learn elsewhere;
  • Help the student to evaluate results (check that I understand right or “correct me if I am wrong”).

So, A2B Task is to:

  • Prepare self training plan;
  • Prepare learning goals – for each session;
  • Prepare self-evaluation questions;
  • Deliver knowledge (in passive (Pull) mode);
  • Help to evaluate results (in Pull mode).

The student is in the centre here – A2B is assisting and responding – student is asking and requesting.

“We give you the roadmap and guidance – you do the walking”.

Categories: Blog, Employees, Facebook
Tags: ,

Keyboard shortcuts to work with tables faster in Excel

14 September 2018 | 

Ctrl + A – selects the entire contiguous range;

Ctrl + A Twice – selects the entire sheet;

Ctrl + Spacebar – selects the entire column;

Shift + Left/Right Arrow – selects multiple columns;

Shift + Spacebar – selects the entire row

Shift + Up/Down Arrow – selects multiple rows;

Shift + Backspace – deselect raw/column/table.

Categories: Blog, Clients, Employees, Insights
Tags: ,

Keyboard shortcut: Windows logo key + E

23 August 2018 | 

Windows logo key + E – Opens Windows Explorer window.

Categories: Blog, Clients, Employees, Insights
Tags: ,