MYCPE ONE

Excel Accountant Member Exclusive: Custom Views

0

Interested

People have shown interest recently

Conference Overview

Step by step, Excel expert David Ringstrom, CPA, shows you many ways of automating your work via Custom Views—an often-overlooked feature in Excel. David demonstrates how to hide and unhide multiple worksheets at once, freeze or unfreeze worksheet panes on-demand, store multiple print ranges/settings for a given worksheet, gain control over long lists of data by filtering instead of sorting, and more. After this course, you’ll be empowered to use Excel far more effectively. 


David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.


Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.


Completed

Continuing Education Credits

The sessions of the conference qualifies for

Qualification Credits Subject Area
CPA (US) 1 Computer Software and Applications
Accountant/Bookkeeper/Tax Professionals 1 All
CPA in Canada 1 Computer Software and Applications
CMA 1 Computer Software and Applications
CWS 1 All
CFIRS 1 All

Sessions

Feb 17th, 2022

Speakers:
Speaker Name
David Ringstrom

President
EXCEL Accountant

  • 4.6
  • rating
  • rating
  • rating
  • rating
  • rating

In this CPE session, you'll learn how to hide and unhide multiple worksheets at once, freeze or unfreeze worksheet panes on-demand, store multiple print ranges/settings for a given worksheet, gain control over long lists of data by filtering instead of sorting, and more. This Excel CPE session will cover the following major topics:

  • Applying different filter settings with just a couple of mouse clicks using the Custom Views feature.
  • Creating custom views that will enable you to display all worksheets in a workbook at once as well as hide/display selected worksheets.
  • Gaining control of long lists of data by filtering instead of sorting.
  • Learning how to replace an existing custom view with new settings.
  • Learning how to use a single line of programming code to unhide all worksheets within a workbook.
  • Protecting hidden sheets from within a workbook.
  • Streamlining Custom Views by adding a drop-down list to Excel's Quick Access Toolbar.
  • Understanding the limitations and frustrations of manually hiding and unhiding worksheets within a workbook.
  • Using the Custom Views feature to remember frequently selected cell ranges or cursor positions.

Learning Objectives

  • Apply the Custom Views feature to make a single set of data serve multiple purposes.
  • Recall how to make the same edits on multiple worksheets at once.
  • Identify how to use Custom Views to manage the hidden/visible status of columns, rows, worksheets, print settings, and more.

Other Details

Subject Area

-

Course Level

Basic

Instuctional Method

Group Internet Based

Pre-requisites

None

Advance Preparation

None

Session Speakers

David Ringstrom -CE/CPE Courses for Accountant, CPAs & more
David Ringstrom

President
EXCEL Accountant

Feb 17th, 2022

View More

Frequently Asked Questions

Virtual conference with MYCPE ONE is enveloped around a theme or subject or driven towards a particular audience, and is designed to be more collaborative; with a tremendously interactive agenda, panel discussions, and gives an option to all participants being able to turn their web cameras on and participate more actively. Virtual conference offers multiple sessions over a longer time frame of more than 8 hours. Virtual conferences help build a community or initiate networking opportunities.

MYCPE ONE is seamlessly integrated with ZOOM for conducting continuing education events. Please ensure that you check the system requirements before the event starts. The system requirements are :

  • An internet connection – broadband wired or wireless (3G or 4G/LTE)
  • Speakers and a microphone (required in case of interactive sessions) – Built-in, USB plug-in, or wireless Bluetooth
  • A webcam or HD webcam - built-in, USB plug-in (required in case of interactive sessions)
  • CLICK HERE to view the System Requirements for Zoom.

There is an official break scheduled for this workshop/events. Other than the scheduled break, the in-session breaks shall be available at discretion of the speaker.

The MYCPE ONE virtual events are designed to impart education around a specific theme or subject from a basic to an advanced level, which is why we do not recommend you to leave the event in between. However, if you had to leave the event because of some unforeseen circumstances, you would be granted the credits for the sessions that you attended completely and wherein you answered all the polling questions.

The recording of the event can be made available to you, on request. You can reach out to us at support@my-cpe.com or can also let us know through live chat support if you need a recording for this event. However, the recording shall not be available for Continuing Education Credits.


During every conference the chat panel shall always be open. You can mention the issue faced by you in the chat panel and our moderator will take it up for resolution shortly. You can also reach out to our support team in the live chat support or at support@my-cpe.com