Online Safety Community

Tips on how to save time on MS Excel

Microsoft Excel is a program that has a very high number of features. These features make this program very capable and versatile, since it is suited for a number of usages. If this is good news, the better news is that these features come with simple shortcuts and methods. These need to be explored, since they are not always visible to the casual user. If a user masters the use of these shortcuts, it will be of immense use, because it helps to save precious time, which can be put to more productive uses. There is no doubt that employees who know how to exploit the secrets of MS Excel are likely to be more productive.

Advance_Excel

 

Want to join the gang of people who are proficient in their use of MS Excel through the innumerable shortcuts that come with the program? Then, enroll for a webinar that is being organized by Compliance4All, a leading provider of professional trainings for the areas of regulatory compliance.

The speaker at this webinar, Dennis Taylor, an Excel expert who has worked extensively with Microsoft products, especially spreadsheet programs, for over two decades, will explain the ways by which to optimize the use of MS Excel. All that you need to do to benefit from this expert on how to use shortcuts for MS excel is to enroll for this webinar by visiting Tricks and 100 Shortcuts

A huge number of shortcuts and tips

The purpose of this webinar is to help participants significantly enhance their productivity at work by using shortcuts. Dennis will be offering valuable tips on how to make the best use of Microsoft Excel on the use of the right shortcuts, whether it is a keystroke shortcut or a hidden command sequence.

The speaker will present an unbelievable 100+ Excel shortcuts. Many of these are keystroke shortcuts and many of them concern dragging techniques not involving command sequences. Another important learning he will offer is on how to differentiate between shortcuts when appropriate, depending on the use. These will be explained separately for Excel versions 2016, Excel 2013, and Excel 2010.

excel-shortcuts-1-638

To make the learning of shortcuts more practical and real; Dennis will offer these productivity tips, shortcuts, and accelerator tools throughout the session using Excel worksheets and workbooks that are based on real-life data. These will later be made available to all attendees.

 

Dennis will cover the following areas at this session:

  • Navigate seamlessly through workbooks and worksheets with keystroke and mouse shortcuts
  • Copy or move data with simple dragging instead of multi-step command sequences
  • Display/hide all worksheet formulas instantly; select all formula cells with two mouse clicks
  • Use keystroke shortcuts for a various number formats
  • Build lists of dates, times or values without using time-consuming commands
  • Create charts instantly and learn manipulation tips
  • Create formulas faster with entire column references
  • Master over 100 tips to make you a Power User!

Views: 12

Comment

You need to be a member of Online Safety Community to add comments!

Join Online Safety Community

Take our poll!

Take our poll!

Latest Activity

kate smith posted blog posts
3 hours ago
Adam Fleaming posted blog posts
5 hours ago
John Robinson posted a blog post

Training and Development is a highly developed and evolved, broad body of knowledge. Many employees place themselves at a disadvantage vis-à-vis their colleagues in the absence of the right professio…

Training and Development is a highly developed and evolved, broad body of knowledge. Many employees place themselves at a disadvantage vis-à-vis their colleagues in the absence of the right professional training and development. If employees have to consistently close gaps in their learning, they need to keep upgrading their knowledge and skills. They should also use training…See More
yesterday
Roger Steven posted a blog post

Ensuring compensation-focused compliance with Stark Law considerations

Stark Law compliance is now more than just a compliance issue. It has grown to become an Enterprise Risk Management matter, if the substantial awards and settlements in recent enforcement actions are anything to go by. For healthcare organizations that develop and implement provider contracts; managing their compliance and…See More
Tuesday

Forum

What is Class Structure in Pega?

Class contains the rule by way of which objects behave. outline rules such as houses, sports, flows, html paperwork, etc. to be had to different subordinate classes. lessons are organized into a…Continue

Started by Soujanya Naganuri on Monday.

How to Concatenate Two Tables in QlikView

Table combining and concatenationConcatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows of…Continue

Tags: datafields, developers, qlikview

Started by Soujanya Naganuri Jun 30.

SQL Server Windows Management Instrumentation Tasks

Hello,SSIS includes two special tasks that enable you to query system information and monitor system events: the WMI Data Reader Task and the WMI Event Watcher Task. These tasks are especially useful…Continue

Tags: Task, WMI, Server, SQL

Started by Madison Quinn Jun 20.

difference between NEBOSH and IOSH

NEBOSH “National Examination Board in Occupational Health and Safety”IOSH “Institution…Continue

Tags: kerala, IGC, NEBOSH

Started by mani May 31.

What's your favorite motivational/safety quote? 98 Replies

Favorite Motivational Quote: If you want something, you'll find a way - If not, you'll find an excuse.Favorite Safety Quote: Don't learn safety by accident!Continue

Started by Michelle Sears. Last reply by David R Snell Apr 26.

Badge

Loading…

© 2017   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service