15 advanced shortcuts in Excel for better productivity

rawpixel-645294-unsplash

EXCEL

Quick Sum of Data – Alt + =

Fill Selected Range (Current Cell Data) – Select Range + Ctrl + Enter

Paste Values – Alt + E + S + V + Enter

Paste Formatting – Alt + E + S + T + Enter

Transpose Paste Values – Alt + E + S + V + E + Enter

Group Rows/Columns – Alt + Shift + Right Arrow + R or C + Enter

Group Rows/Columns – Alt + Shift + Left Arrow + R or C + Enter

Collapse Group Rows/Columns – Alt + A + H

Expand Group Rows/Columns – Alt + A + J

Add Rows/Columns – Ctrl + (+) + R or C + Enter

Remove Rows/Columns – Ctrl + (-) + R or C + Enter

Select Current Data Range – Ctrl + *

Create Filter for Data Range – Highlight Cells + Ctrl + Shift + L

Remove Filter – Highlight Filtered Cells + Ctrl + Shift + L

Select Visible Values (Only) – Alt + ;

What kind of leader are you?

Leadership vs. Management

In the business world, there are task-based and relationship-based managers who accomplish organizational goals. Clearly, a task-based approach may be necessary when a business is disorganized to the point where operations are failing in some regards and cannot continue “As is”. For those operations where tasks are being completed in a timely manner, and a sense of urgency is not as strong, relationship-based management is commonly the better approach. Managers need to continue to think in a forward facing direction to where they would see their operations in the near future, and maintaining that mindset in troubling times can be critical for organization and operation of the workforce.

Regardless of management style used, leadership is a key component of running any team, especially in the case of natural and charismatic leaders who strongly influence organizations. While the management style used can make a difference in how quickly tasks are being approached and completed, leadership is key to ensuring the success of teamwork. Take any team with various leadership styles, each trying to influence the other, and the most innovative members will find how best they fit together. Playing to strengths and recognizing the qualities of all on the team, while also anticipating weaknesses, allows for a solid collaboration effort. While the natural leaders may inherently influence one another, it’s important for leadership to pass among members from time to time so that each can receive recognition as needed.

The best leaders are those who put aside their egos and personal goals when needed and listen down to the heartbeat and lifeblood of their organizations. Leaders listen from the ground up, meaning they understand the concerns of employees, meet and exceed expectations around those concerns. From the standpoint of corporate social responsibility, the ideas and capabilities of employees at all levels are no less important than those of the leaders of an organization. Your staff members live out in the communities surrounding your operations, and word of mouth carries concerning how they feel working under your leadership. What kind of image would you like portrayed among the communities who rely on your capabilities? The tyrannical overlord who always must have their own way regardless of input? Or the kind and understanding leader, who stands up for the ideas of their employees and shares in their commitment and loyalty to the organization’s vision and goals?

Self-reflection is necessary for any manager of a business, for in reflecting on how employees view you and what you are trying to accomplish you can find a superior truth to assist in managing them. The identity of a leader and manager must be one that reflects the best interests of an organization at all levels, not just at the top. Asking ourselves “What’s best for all stakeholders?” should be at least a weekly exercise for organizational leadership because it forces you to think outside of your own little bubble. Try and commit to having at least one small conversation per week with various employees at all levels of the organization to grow your awareness of employee perceptions. If you go out of your way for your staff, not all, but many of them will go out of their way for you.

Are you struggling with getting your leadership skills sharpened and organized? Need a weekly, bi-weekly, or hourly accountability coach to help you get organized? Contact us today to get a confidential consultation to form a leadership coaching relationship.

45 keyboard shortcuts that could save your life: Windows & Excel

Windows

Alt + Tab Switch between active program windows.
Ctrl + A Select all objects in a document or on a page.
Ctrl + P Access print menu. Hit “Enter” to execute printing command.
Ctrl + F Bring up a search tool in most programs.
Alt + F In most programs, brings up the “File” menu, then the additional corresponding
button for the action you want to perform on the toolbar can be pressed.
Ctrl + S Save the document you are working on.
Ctrl + C Copy selected item(s) to the clipboard.
Ctrl + X Cut selected item(s) to the clipboard.
Ctrl + V Paste items from the clipboard.
Print Scrn button Captures a screen shot of everything the width of your screen.
Ctrl + Alt + Print Scrn Captures a screen shot of the current screen in use when using dual monitors.
Ctrl + Z Undo the last action performed.
Ctrl + Y Redo the last action undone.
Esc Cancels editing as well as many other actions.
(Windows Key) + E Opens up “My Computer” in the browser window.
(Windows Key) + L Instantly locks the computer.
Ctrl + Home Navigates to the beginning of the document.
Ctrl + End Navigates to the end of the document.
F12 Save As
Ctrl + N Create a new file in the program you are using.
Ctrl + O Opens up the Open browser navigation window.
Ctrl + F4 Closes the current window inside the program. Program will continue running.
(Windows Key) + D Minimizes all open windows and shows desktop.

Excel

Alt + 7 Create a solid bullet point in excel and other programs.
Alt + 9 Create a hallow bullet point in excel and other programs.
Ctrl + 1 Quickly brings up the “Format Cells” window for a selected cell or range.
(Hold) Shift + Arrow Key Select multiple cells in a range.
F2 Edits or enters a cell in the active worksheet.
F10 Displays the keytips for the ribbon.
Ctrl + F9 Minimizes the workbook.
Ctrl + F10 Maximizes the workbook.
Ctrl + Arrow Keys In cell selection, jumps to the next cell containing data.
Ctrl + Page down/up Scroll between sheets in an active workbook.
Ctrl + [ Opens the source destination of a linked cell.
Ctrl + H Opens the find and replace tool in a workbook.
Alt + Shift + F1 Creates a new worksheet within the current workbook.
Ctrl + F3 Opens the Name Cell dialogue box
F3 Opens the Name Cell selection box to paste name into cell.
F4 Redo the last action performed.
F4 (Inside a formula) Gives the formula references of a cell absolute references. (Press multiple times
to scroll through choices.)
F5 Opens the Go To dialog box.
F11 Create new chart based on data selected.
Ctrl + ~ Toggle between Show/Hide Formulas.
Ctrl + B Formats the selected data to bold.
Ctrl + Shift + 4 Formats the selected data to give it a dollar value.