Use OneNote to manage your meetings

Microsoft OneNote is a program that works as a digital notebook. It saves users the trouble of having to scramble for a piece of paper whenever they feel like scribbling some information or idea down. Moreover, it saves the user the trouble of having to preserve a piece of paper on which the info is jotted down.

Microsoft OneNote helps users to type, write or draw on the digital notebook while continuing to have the same feel as a regular paper and pen. It is designed to help people have access to note down ideas or important information with the ease of a notebook. Users can also search the web and clip pictures to the text to enhance the effect. Several other features are available to add effect to the text.

Another feature of the Microsoft OneNote program is that the documents can be shared across the www. It helps to communicate ideas, thoughts and occasions across devices. It is available for a number of devices ranging from Apple to Windows and Android and the web.

Explore the ins and outs of Microsoft OneNote

There is a lot to explore in this program. This is what a learning session from Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will be offering at a webinar. The speaker at this webinar, Mike Thomas, has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. He has produced nearly 200 written and video-based Excel tutorials. It is this rich experience that will be in full display at this webinar.

To learn the nitty-gritty of all the functions that you can get Microsoft OneNote to perform for your benefit, just enroll for this webinar by visiting Best practice for creating a Notebook

Business Professionals, Business Owners, Researchers, Administration Support Staff, Educators, for that matter anyone who wants to learn how to get the best from OneNote to manage projects and their life, will gain from this session.

Putting the program to maximum use

Mike will explain how to use OneNote notes thoroughly for storing text, images, videos, embedded files and drawings and sketches. He will show how to optimize OneNote notebooks for sharing with colleagues and customers and using it for thorough collaboration at work. The ways by which OneNote can be used to manage projects, meetings, and life itself will be taught at this session.

Mike will cover the following areas at this webinar:

o  Best practice for creating a Notebook

o  Restructuring and rearranging a Notebook

o  Protecting your information

o  Using OneNote for Internet research

o  Collaborating with others / Sharing a Notebook

o  Drawing, sketching and hand-writing notes

o  Searching OneNote

o  Integrating OneNote with Outlook

o  Go Mobile: How to use OneNote on an iPad.

Advertisements

Learn how to future-proof VLOOKUP by using Excel’s Table feature versus referencing static ranges

Professionals in a wide number of industries and businesses find the VLOOKUP function in Excel very useful. Why this is so is that it helps in locating an exact value. Using VLOOKUP, an MS Excel user can find a specific piece of information in the spreadsheet. This is very useful when there are very many values in a grid. In other words, the VLOOKUP function is ideal for locating an exact one from among a number of values. Using VLOOKUP, users can return data from other locations in a worksheet.

An indication of the functions that VLOOKUP performs can be had from its expansion, which is Vertical Lookup. It works by searching for the specific item in a vertical manner. As opposed to normal values that can be performed manually; VLOOKUP function helps users to go further by enabling them to perform more complex tasks such as unit sales for a period of time at a certain price or its variables.

If the user wants to calculate the unit sales of say, a clothing material from one date to another at a certain price; VLOOKUP is extremely handy. This can be expanded to any number of brands sold by the business for any date or unit price, which is why this function is considered very useful.

We can understand the VLOOKUP function in MS Excel by drawing a parallel with “Control F”, or the “find” function in MS Word. In MS Word, it is possible to use this function to go to the exact word, whereas using VLOOKUP; the user can get down to much more, like the entire object’s associated values.

Get professional help to understand VLOOKUP better

An exploration of this function is best made with expert help. At a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance; Excel expert David Ringstrom, CPA, will explain the way in which this program can be tweaked. David Ringstrom is a nationally recognized instructor who designs and teaches Excel courses that are based on over 25 years of consulting and teaching experience. To gain the benefit of experience that David brings into MS Excel, please register for this webinar by logging on to http://www.compliance4all.com/control/w_product/~product_id=501297LIVE?Wordpress-SEO

What makes this presentation different is that the presenter will demonstrate every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He will explain the differences in Excel 2013, 2010, or 2007 both during the presentation as well as in his detailed handouts. David will also give participants an Excel workbook that will include nearly all the examples he will be using during the webinar.

Alternatives to VLOOKUP do exist

However, using VLOOKUP isn’t always the most efficient approach. Hence, David will explain alternatives such as the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions. He will explain the limitations of VLOOKUP. In addition, he will also help participants understand the ways of future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges.

One of the major gains of this learning session is that the participants will be able to improve the integrity of their spreadsheets with Excel’s VLOOKUP function. In addition to helping participants learn the ways of performing dual look-ups; the speaker will also help them get clarity on the user actions that can trigger #REF! errors. Participants will be able to use the IFERROR function to display something other than an #N/A error value when VLOOKUP can’t find a match.

He will cover the following areas at this webinar:

o  Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges

o  Using the SUMIF function to summarize data based on a single criterion

o  Learning why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP

o  Using the MATCH function to find the position of an item on a list

o  Using the IFERROR function to display something other than an #N/A error value when VLOOKUP can’t find a match

o  Improving the integrity of spreadsheets with Excel’s VLOOKUP function

o  Learning about the IFNA function available in Excel 2013 and later

o  Using the SUMIFS function to sum values based on multiple criteria

o  Using VLOOKUP to perform approximate matches

o  Seeing what types of user actions can trigger #REF errors

o  Performing dual lookups, which allow you to look across columns and down rows to cross-reference the data you need.

Optimizing the use of Microsoft Outlook

From the time of its introduction by Microsoft in the late 1990’s, Microsoft Outlook has been a standard package for innumerable organizations around the world. Part of the world famous Microsoft Office system, Microsoft Outlook is a very popular personal information manager.

In the two decades of its launch, Microsoft Outlook has undergone various improvements. The additions that are made to it are aimed at improving user experience and adding features that go on to make it more useful for users.

Needs to be put to full use

Despite its being in the market for such a long time, many users do not know the full extent to which Microsoft Outlook can be put. When explored fully, Microsoft Outlook offers a bouquet of features that go beyond just sending and receiving mails and making appointments on the calendar.

The ways of optimizing Microsoft Outlook for office use and making it a more useful personal information manager will be the content of a webinar that is being organized by Compliance4All, a leading provider of very cost-effective professional trainings in all the areas of regulatory compliance.

Understand the ways of optimizing the use of Microsoft Outlook

At this webinar, Mike Thomas, a subject matter expert in a range of technologies including Microsoft Office and Apple Mac, who is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors, will be the speaker.

To get a better understanding of how to put your Microsoft Outlook package to much better use, please register for this webinar by logging on to

http://www.compliance4all.com/control/w_product/~product_id=501148LIVE?Wordpress-SEO

Control Microsoft Outlook; don’t let it control you

Mike will offer simple and easy guidance on how to put Microsoft Outlook to far greater use than people are normally used to. Microsoft Outlook. The point about Microsoft Outlook is that if it is put to the right use, it facilitates a number of functions that the user will find thorough useful and beneficial.

If it is not, Microsoft Outlook has the potential to throw the user’s work schedule into disorder, as many of its functions can confuse the user who does not know how to use it to the maximum.

Mike will show participants of this webinar the simple way of controlling Microsoft Outlook, rather than letting Microsoft Outlook control the user. He will cover the following areas at this session:

o  The 4D’s of email management

o  Configure Outlook for distraction free productivity

o  How to use Rules to automate email processing

o  How to use Quick Steps to automate a series of actions

o  The benefits of Tables

o  Creating data visualizations using Shapes and SmartArt

o  Converting emails into Tasks

o  Using Categories to tag emails, calendar items and Tasks

o  Using Views to display information in a way that suits you.