How to create Slicers which are the New Visual way to Filter a Pivot Table

Microsoft Excel can be used to carry out a number of functions such as sorting, filtering, and subtotal to manage large lists of data. Yet, its MS Excel PivotTable is a very useful feature when it comes to analyzing all that data and doing it quickly. Its use is all the more pronounced when the user is required to quickly create a compact summary report (based on lots of data) without having to write complex formulas or rely on lengthy techniques.

Being very versatile, MS Excel PivotTable is often considered Excel’s best analytical tool because it complements speed with amazing flexibility and dynamism, by which the data interrelationships that are being viewed can be changed. It is so practical that its features can be put to practical use by actually getting down to work on it, even if a user doesn’t go through the instructions on the printed page, which is a visually-oriented feature based on displaying fields in different locations. With MS Excel PivotTable, it is possible to create a complete summary report with heaps of data in very little time without having to write complex formulas and rely on obscure techniques.

Thorough learning about all the features and aspects of PivotTable from the MS expert

A webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will offer complete learning on the numerous PivotTable capabilities and its many tools and features.

The speaker at this session is Dennis Taylor, an Excel expert who has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990’s and has taught hundreds of workshops and authored numerous works on this program. Please register for this webinar by visiting best ways to create PivotTables and gain complete insights into the ways by which to put the full range of functionalities of MS Excel PivotTable to use.

PivotTable simplified

Teaching participants the quickest and best ways to create PivotTables and Pivot Charts is the main objective of this webinar. These include the following capabilities:

o  How to compare two or more fields in a variety of layout styles

o  How to sort and filter results

o  How to perform ad-hoc grouping of information

o  How to use Slicers instead of filters to identify which field elements are displayed

o  How to drill down to see the details behind the summary

o  How to categorize date/time data in multiple levels

o  How to create a Pivot Chart that is in sync with a PivotTable

o  How to add calculated fields to perform additional analysis

o  How to hide/reveal detail/summary information with a simple click

o  How to deal with dynamic source data and the “refresh” concept

o  How to create a PivotTable based on data from multiple worksheets.

All these aspects will be covered in detail. Dennis will also cover the following areas at this session on MS Excel PivotTable:

o  Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables

o  Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option

o  Manipulating the appearance of a PivotTable via dragging and command techniques

o  Using Slicers to accentuate fields currently being shown (and which ones are not)

o  Using the new (in Excel 2013) Timeline feature

o  Creating ad hoc and date-based groupings within a PivotTable

o  Quickly create and manipulate a Pivot Chart to accompany a PivotTable

Apart from MS Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data; anyone needing to know how to create PivotTables from multiple sources and use Slicers, Timelines, Calculated Fields, and Conditional Formatting will also benefit from this course.

For Depth info

Advertisements

MS Excel can be a wonderful tool for carrying out umpteen functions

Mastering MS Excel formulas and functions can make a miracle out of this program. When used optimally, MS Excel can be a wonderful tool for carrying out umpteen functions and optimizing work related to a number of departments. For example, the Accounts Department can do a number of important functions such as loan repayment calculation, generating a profit and loss statement, solve complex mathematical and engineering problems, and carry out anything that involves addition, subtraction, multiplication and other functions with utmost ease.

functions-and-formulas-of-ms-excel-2-638

 

This is because MS Excel has a number of built-in tools. If a user knows how to use these; it could be a real blessing, because it carries out a number of complex tasks at the touch of a button. The user of MS Excel only needs to know how to use these functions. The features range from simple sum and average to the IF and VLOOKUP functions.

Goes beyond calculating and arriving at data

The major advantage of maximizing the use of MS Excel is that it saves lots and lots of time for the user. Be it a student or an accounts executive; MS Excel helps them to make the best use of time, as they will be required to spend a lot lesser time on functions since MS Excel does it for them.

Calculation of and arriving at data is not the only function MS Excel is capable of carrying out. Calculating someone’s exact age in days, combining text items from several cells into a single cell or converting a list of lower case text items to capital letters are just some of these. And what is MS Excel’s capability in relation to creating financial data and models? It is perfectly useful here, too.

functions-and-formulas-of-ms-excel-10-638

Discover the ways of optimizing the use of MS Excel

Want to understand how to make MS Excel work magically for you? Then, a webinar from Compliance4All, a leading provider of professional compliance for all areas of regulatory compliance, will show you how. The speaker at this extremely useful session is none other than Mike Thomas, a subject matter expert in a range of technologies including Microsoft Office and Apple Mac, who has worked in the IT training business since 1989.

From the time Mike founded theexceltrainer.co.uk; he has produced nearly 200 written and video-based Excel tutorials. To be able to make your MS Excel a much more efficient program and help it save you enormous time and resources; please get the most out of the learning from this webinar by enrolling for it at Creating complex functions the easy way

1ec5ef5b-96a1-4353-96c2-c9a26ad2adc5This session is ideally suited for any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions. Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. This program can be a good fit for anyone who is above the entry level.

Mike will cover the following areas at this webinar:

  • Creating formulas to perform mathematical calculations
  • Copying formulas and the difference between absolute and relative references
  • Assigning names to cells and using them in formulas
  • Using functions to combine text strings from multiple cells
  • Using functions to change text from lowercase to uppercase and vice versa
  • Using functions to perform calculations on dates and times
  • Using the IF function to automate data entry
  • The VLOOKUP function
  • Creating complex functions the easy way.

How to deal with dynamic source data and the “refresh” concept

Microsoft Excel comes with a myriad of tools such as sorting, filtering, and subtotal to manage large lists of data. Yet, when it comes to analyzing all that data and doing it quickly, the MS Excel PivotTable is a very useful feature. It is particularly important and useful when the user is required to quickly create a compact summary report (based on lots of data) without needing to write complex formulas or rely on lengthy techniques.

Excel

MS Excel PivotTable is very versatile. It is considered Excel’s best analytical tool because in addition to speed, it also comes with amazing flexibility and dynamism the data interrelationships that are being viewed can be changed. It is easier to put the PivotTable MS Excel features into practical use by actually getting down to work on it, rather than trying to pore through the instructions on the printed page, which is a visually-oriented feature based on displaying fields in different locations. It offers the ability to create a complete summary report with heaps of data in very little time without having to write complex formulas and rely on obscure techniques.

Learn about all the features and aspects of PivotTable from the MS expert

A complete learning on the numerous PivotTable capabilities and its many tools and features will be offered at a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance.

excel-pivot-table-tutorial

Dennis Taylor, an Excel expert who has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990’s and has taught hundreds of workshops and authored numerous works on this program; will be the speaker at this session. Just visit Excel PivotTables to register for this webinar and gain complete insights into the ways by which to put the full array of functionalities of MS Excel PivotTable.

Simplifying the use of PivotTable

The main objective that Dennis Taylor has for this webinar is to familiarize participants with the quickest and best ways to create PivotTables and Pivot Charts. These include the following capabilities:

  • How to compare two or more fields in a variety of layout styles
  • How to sort and filter results
  • How to perform ad-hoc grouping of information
  • How to use Slicers instead of filters to identify which field elements are displayed
  • How to drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a Pivot Chart that is in sync with a PivotTable
  • How to add calculated fields to perform additional analysis
  • How to hide/reveal detail/summary information with a simple click
  • How to create a PivotTable based on data from multiple worksheets.

He will cover these in detail. In addition, he will cover the following areas at this session on MS Excel PivotTable:

  • Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
  • Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Using Slicers to accentuate fields currently being shown (and which ones are not)
  • Using the new (in Excel 2013) Timeline feature
  • Creating ad hoc and date-based groupings within a PivotTable
  • Quickly create and manipulate a Pivot Chart to accompany a PivotTable

MS Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data are among the primary beneficiaries of this webinar, but anyone needing to know how to create PivotTables from multiple sources and use Slicers, Timelines, Calculated Fields, and Conditional Formatting will also benefit from this course.

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!

Mastering budget spreadsheets in MS Excel

Cash flow budgets, preserving key formulae and streamlining formula writing are just some of the varied functions of MS Excel. This wonder program helps the user to carry out a number of functions, all of which help in facilitating business decision-making. These apart; MS Excel offers users the opportunity to explore and carry out a vast range of activities, functions and calculations.

excel-ninja-course

An expert with a quarter of a century of working in the world of Microsoft products will be explaining these and related functions of MS Excel in a clear and easy to understand manner. Why not join David Ringstrom, author and nationally recognized instructor who teaches Microsoft-related topics at scores of webinars each year, for an enlightening webinar session on the multiple uses of MS Excel?

This webinar is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance. All that is needed to register for this highly educative and entertaining session is to visit http://www.compliance4all.com/control/w_product/~product_id=501299LIVE?Wordpress-SEO

Speaker’s rich experience at play

The major advantage that participants to this session will have is that they will learn from the honcho of Microsoft programs. David’s Excel courses are based on over 25 years of consulting and teaching experience. He believes in the mantra, “Either you work Excel, or it works you”. With this thinking in mind, he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower them to use Excel more effectively.

It is this outlook that will be of immense use to professionals such as Accountants, CPA’s, CFO’s, Controllers, Excel users, Income Tax Preparers, Enrolled Agents, Financial Consultants, IT Professionals, Auditors, Human Resource Personnel, Bookkeepers, Marketers and Government Personnel, professionals whom this webinar seeks to benefit.

331zya9

Ways of creating resilient and practical budget spreadsheets

The core of the learning of this webinar is how to create resilient and practical budget spreadsheets. David will familiarize participants with a wide range of helpful techniques, which include ways of separating inputs from calculations, streamlining formula writing, preserving key formulas, and creating both operating and cash flow budgets. An additional benefit is the explanation he will offer of the uses and benefits of a variety of Excel functions, including CHOOSE IFNA, IFERROR, and ISERROR ROUNDUP and ROUNDDOWN VLOOKUP and SUM and SUMIF.

This session is useful in more ways than one. David will demonstrate every technique at least twice first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. Both during the presentation and in his detailed handouts; David will draw participants’ attention to the many differences in Excel 2013, 2010, and 2007. David will also offer an Excel workbook that includes most of the examples he uses during the webcast.

The core of this learning session is to impart the following learning objectives:

  • Learn to create both operating and cash flow budgets
  • Learn how to streamline formula writing
  • Transform filtering tasks using the Table feature
  • Understand the benefits associated with a variety of Excel functions
  • Apply and isolate all user entries to an inputs worksheet
  • Protect all calculations and budget schedules on worksheets
  • Use range names and the Table feature to create resilient and easy-to-maintain spreadsheets
  • Calculate borrowings from, and repayments toward, a working capital line of credit

David will cover the following areas at this webinar:

  • Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
  • Streamlining formula writing by using the Use in Formula command
  • Improving the integrity of spreadsheets with Excel’s VLOOKUP function
  • Comparing IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions
  • Going beyond simple rounding with the ROUNDUP and ROUNDDOWN worksheet functions
  • Learning a simple design technique that greatly improves the integrity of Excel’s SUM function
  • Using the SUMIF function to summarize data based on a single criterion
  • Learning how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations
  • Learning how the Table feature allows you to transform filtering tasks
  • Preserving key formulas using Excel’s hide and protect features.

Putting the MS Excel VBA to optimal use

Visual BASIC for Applications (VBA) is the programming language built into MS Excel and other MS programs. It is a macro, which, as we know, is a recording of a series of tasks. At a simple level, it can be thought of as a smaller version of programing in that once certain tasks are assigned to it, it carries them out.

feature_excel_vba

The main function of a macro is to work within a program such as MS Excel and automate tasks that need to be performed over and over many times. Because of this function, MS Excel carries out many tasks that would otherwise have to be done manually. Obviously, this is a great time saver, because the time that needed to be spent on manually carrying out a host of repetitive tasks can now be put on something constructive.

 

Overcoming the limitations

MS Excel has a macro recorder, but it has its limitations. So, VBA takes over where the macro recorder’s functionality ends. At a more advanced level, VBA enables the user to carry out many functions, such as:

  • Building your own worksheet functions
  • Creating automated workflows
  • Controlling and interacting with other applications, plus much more.

excel_macro

Get to understand how to use VBA better

Want to know how to make the fullest use of the VBA function in MS Excel? Then, you need to attend a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance.

At this webinar, Mike Thomas, founder of theexceltrainer.co.uk will be the speaker. Mike 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.

To gain complete knowledge of how to make use of the VBA feature; please register for this webinar by visiting http://www.compliance4all.com/control/w_product/~product_id=501317LIVE?Wordpress-SEO

unnamed

Mike will get participants started with the VBA. Both advanced and small users of Excel, with little or no programming experience, will be able to take their level of automation knowledge beyond the macro recorder. Even those who have never used VBA before and want to learn about the basics of VBA and automation will find this webinar useful.

People who use MS Excel in their daily work, such as business professionals, business owners, researchers, administration support staff, educators, or for that matter anyone who wants to learn how to get the best from MS Excel to manage projects and their life, will derive benefits from this webinar.

Mike will cover the following areas at this webinar:

  • Getting familiar with the VBA Editor
  • Understanding VBA jargon such as procedures, modules, methods and properties
  • How to edit an existing macro
  • How to write a simple macro from scratch using VBA
  • Creating inline documentation
  • Using VBA to control what happens a file is opened or closed
  • Using VBA to repeat a series of actions (simple loops)
  • Writing simple conditional statements (IF).

Learn how to build professional, eye-catching form-driven applications and spreadsheets

MS Excel, a wonder program, has umpteen uses for a number of professionals, students, and a host of other users. We have known for long that it can be used to carry out a number of functions that are varied and interesting. However, adding design elements to MS Excel goes a long way in enhancing its aesthetic appeal, as also the effectiveness.

Booking forms, sales order forms, invoices, loan agreement forms and surveys are just some of the endless kinds of forms that can be created using Excel. These can be made a lot more attractive and likeable by just adding a touch of features such as color, cell protection and some drop-down lists and simple validation.

A few simple steps at design

Just a few splashes here and there into these forms, and you will be amazed at the extent to which these bland forms can transform themselves into user-friendly ones that will make data entry simple and error free for everyone concerned, be it the user, her colleagues, or her clients. Small techniques such as this will eliminate the hassle of having to go through the long-winded, repetitive and frustrating experience of entering and editing data into a table in Excel.

This is just one of the many tricks that will be taught at a webinar on adding design elements into MS Excel to make it more illustrative, attractive and useful. At this webinar, the Expert, Mike Thomas, the globally acclaimed guru of MS Office, who has spent over a quarter of a century as a subject matter expert in a swathe of subjects relating to MS Office and Mac, will be the speaker.

Loads of experience

The experience and wisdom that Mike has gained over these years, during which he has been 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 in full flow at this highly interactive webinar session. Want to know how to optimize the use of design elements into MS Excel to make it more palatable and likeable? Just log on to http://www.compliance4all.com/control/w_product/~product_id=501316LIVE?Wordpress-SEO to enroll and relive the fun of learning about MS Excel.

Adding design elements into MS Excel to save costs and time

The main benefit that people across a spectrum of professions and activities, such as Business Professionals, Business Owners, Researchers, Administration Support Staff Educators, or for that matter anyone who wants to learn how to get the best from MS Excel to manage projects and their life, will gain from this webinar is that they can save the invaluable resources of time and money by learning to enhance the use of forms in MS Excel.

This session is highly useful to smaller organizations that are constrained with limited budgets and will think twice when needed to buy expensive dedicated software to manage the inputting and storage of information. This of course, does not preclude bigger companies from this learning.

Using other MS Excel features to create forms

The speaker will enable participants to follow real-world examples to learn how to build professional, eye-catching form-driven applications and spreadsheets. Since there is no option for creating a form; Mike Thomas will teach participants how to use a number of other built-in MS Excel features to create forms and then subsequently make them attractive with its design.

Mike will cover the following areas at this webinar:

o  Naming cells-to make formulas easier to understand

o  Drop-down menus and checkboxes-to make data entry easy

o  Data validation and protection-to reduce the risk of data-entry errors

o  Formatting-to make your forms inviting to use

o  Formulas and functions as VLOOKUP

o  Simple automation.