Tip 40 from 101 Excel 2013 Tips. Tricks & Timesavers

===================================

 Tip 40 from 101 Excel 2013 Tips. Tricks & Timesavers

By John WalkenBach

====================================

How would you like it, to create a worksheet containing array formula's which create a dynamically changing Calendar, like the one depicted in the graphic above?

Call us now, to learn how to do this, or email us your requirement. Go to  Excel-VBA-AhmFCA and fill the contact form there to get more information on the same.

CA Vikram Shankar Mathur

vsmathurco@gmail.com / vikramsmathur@gmail.com / cavs.mathur@gmail.com

Windows 11: Not just a Pretty Face - by Cyn Mackley (WP)

Windows 11 might look sleek and modern, but it’s not just about eye candy. Hidden beneath that polished surface are some surprisingly powerful features—like the kind of stuff that makes you think, “Why didn’t anyone tell me this before?” Wheth… Read on blog or Reader Cyn Mackley Read on blog or Reader Windows 11: Not Just a Pretty Face By cynmackley on December 7, 2024 Windows 11 might look sleek and modern, but it’s not just about eye candy. Hidden beneath that polished surface are some surprisingly powerful features—like the kind of stuff that makes you think, “Why didn’t anyone tell me this before?” Whether you’re a Windows wiz or a proud novice, there are hidden gems in Windows 11 that can make you wonder how you ever lived without them. We’re talking about features that save time, make life easier, and even add a little extra pizzazz to your setup. In this series, we’re diving into eight of Windows 11's best-kept secrets, each with a detailed, easy-to-follow guide so you can get the most out of your computer. And don’t worry—we’ll keep things light and breezy. You’ll learn without needing a translator, and we’ll even throw in some laughs. Let’s uncover those hidden Windows 11 features together. By the end, you’ll look like a pro (or at least be able to pretend convincingly). Snap Layouts – The Ultimate Screen Organizer Ever wish you could organize your screen without spending precious minutes resizing every single window? With Windows 11, Snap Layouts makes it easy to arrange multiple windows side-by-side, stacked, or even in quadrants, so you can keep your workspace organized. It’s perfect for multitasking or simply keeping things neat. How to Use Snap Layouts: Hover Over the Maximize Button: Start by opening a few different windows. Hover over the maximize button on the top right corner of any open window (it’s the middle one between minimize and close). Windows 11 will display several layout options in a pop-up. Choose a Layout: Select the layout you like by clicking one of the divided sections. Options vary, but usually include two, three, or four-window setups. Each section shows you where other windows will snap around it. Fill in the Layout: Once you pick your layout, Windows will prompt you to select the other windows to fill the remaining slots. Simply click on the window you want, and it will snap into place. Customize Your Snap Groups: If you often work with the same group of windows, Snap remembers your layout as a "snap group" in the taskbar. Hover over the icon of any app in the group, and you’ll see the option to restore the entire layout in one click. Snap Layouts save time, make multitasking simpler, and keep your workspace streamlined. Perfect for those who want to look ultra-organized with minimal effort! The Virtual Desktops You Never Knew You Needed Feel like your computer is a mess of tabs, windows, and applications? Enter Virtual Desktops, a hidden Windows 11 gem that allows you to set up separate desktops for different activities—think of them as personal mini-computers all in one. How to Set Up and Use Virtual Desktops: Open Task View: Press Windows Key + Tab or click on the Task View icon on the taskbar. This opens an overview of your current desktop and all open apps. Add a New Desktop: Look for the “+ New Desktop” option at the top. Click it, and a fresh desktop will appear. Now, you can start filling it with apps and windows specific to whatever you’re working on. Customize Your Desktops: Right-click the new desktop in Task View, and you’ll see options to give it a custom name (like “Work,” “School,” or “Gaming”). You can even assign unique backgrounds to each desktop for a more personalized touch. Switch Between Desktops: Go back to Task View, or use Windows Key + Ctrl + Left/Right Arrow to toggle between desktops quickly. Close a Desktop: When you’re ready to clean up, go to Task View, hover over the desktop you want to close, and click the “X” in the corner. Virtual Desktops let you organize your digital life, helping you stay focused by separating work from play (or whatever else you need). Clipboard History – Stop Typing Things Twice Have you ever copied one thing only to realize you needed the previous thing you copied? Clipboard History has you covered! This feature lets you save multiple items to the clipboard, so you can retrieve any recently copied text, images, or files when needed. How to Use Clipboard History: Enable Clipboard History: Press Windows Key + V to open the Clipboard History pane. If this is your first time, you’ll be prompted to enable it. Click “Turn on” to activate the feature. Copy and Save Multiple Items: Start copying text, images, or files as usual (Ctrl + C or right-click + Copy). Clipboard History will automatically save each item, up to 25 items at once. If you exceed 25, older items are replaced. Access Saved Items: When you need something from Clipboard History, press Windows Key + V to open the pane. All your copied items appear here in a list. Paste from Clipboard History: Click any item to paste it instantly. The item will be inserted wherever your cursor is, just like a regular paste. Pin Important Items: If there’s something you paste regularly (like an email signature or address), click the three-dot menu beside it and select “Pin.” Pinned items won’t get replaced when the clipboard history fills up. Clipboard History saves time and lets you grab what you need without backtracking through your work. Focus Sessions – Because We All Need Less Distraction If distractions are your nemesis, Windows 11 has your back with Focus Sessions. This feature lives in the Clock app and combines a timer, task manager, and even Spotify integration to keep you on track. How to Set Up a Focus Session: Open the Clock App: Press the Windows Key and type “Clock.” Click on the app to open it. Set Up Your Focus Session: In the Clock app, click on Focus Sessions in the sidebar. You’ll see options to set your focus duration and even short breaks. Add Tasks (Optional): Sync with Microsoft To Do to add tasks you want to accomplish. This feature lets you check things off as you complete them. Customize Your Session: You can add music from Spotify to your session if background music helps you focus. Log into Spotify directly within the Clock app, choose a playlist, and set the volume. Start the Session: When you’re ready, click Start Focus Session. A timer begins counting down, and the app will notify you when it’s time for a break. Focus Sessions create structure, making it easier to concentrate on one task at a time. It’s like having a personal assistant keeping you on track. Article 5: The Secret Start Menu – A Shortcut Lover’s Dream Windows 11 hides a handy secret Start Menu, giving you quick access to essential tools. With a right-click on the Start button or pressing Windows Key + X, you open this menu, which is loaded with shortcuts. How to Use the Secret Start Menu: Open the Menu: Right-click the Start button or press Windows Key + X. You’ll see a list of shortcuts to key Windows tools like Task Manager, Settings, and File Explorer. Explore Your Options: Each option on the list is a gateway to deeper system management. Open Device Manager to check your hardware, Event Viewer for system logs, or Network Connections to manage your internet setup. Customize Your Settings: Some tools, like Settings and System, let you make changes to personalize your PC or manage apps and accounts. One-Click Access to Task Manager: This menu gives you direct access to Task Manager, so if something’s running too slow, it’s only a couple of clicks to fix the issue. This hidden menu is like a command center. It’s small but mighty, making it a real time-saver for accessing advanced settings in a flash. Windows Terminal – Not Your Average Command Prompt The old Command Prompt got a makeover in Windows Terminal. It offers multiple command-line environments in one spot, including PowerShell, Command Prompt, and WSL (Windows Subsystem for Linux). How to Use Windows Terminal: Open Windows Terminal: Right-click the Start button and select Windows Terminal. Alternatively, press Windows Key + R, type “wt,” and hit Enter. Try Out Multiple Tabs: Click the + icon to open a new tab. You can switch between Command Prompt, PowerShell, or any other shells you’ve installed, each in its own tab. Customize the Terminal: Go to Settings within Terminal to change font, color scheme, and even background transparency for a personal touch. Use Commands Across Tabs: You can copy and paste commands, run scripts, and do pretty much anything from one Terminal window. Windows Terminal is a dream for power users and those looking to learn more about the command line. It’s customizable and convenient. Storage Sense – Your PC’s Built-In Cleaning Service Storage Sense automatically cleans out temporary files and keeps your hard drive uncluttered, so you don’t have to think about it. How to Enable Storage Sense: Go to Settings: Press Windows Key + I to open Settings, then head to System > Storage. Enable Storage Sense: Toggle the switch to turn on Storage Sense. You can also click Configure Storage Sense or run it now to set it up. Customize Cleanup: Choose when Storage Sense runs (daily, weekly, monthly, or when space is low) and which files it should delete (like Recycle Bin or Downloads). Run a Cleanup Now: If you want instant results, hit “Clean Now” to see how much space Storage Sense can free up. Storage Sense helps your PC run smoothly and keeps you from doing all the deleting yourself. Shake to Minimize – For When You’re in a Hurry Windows 11’s “Shake to Minimize” feature is perfect for quickly minimizing all open windows except the one you’re working on. How to Use Shake to Minimize: Find Your Main Window: Pick the window you want to keep open and click on its title bar. Shake It!: Click and hold the title bar, then shake the window quickly back and forth. All other open windows will minimize instantly. Restore with Another Shake: Want everything back? Just repeat the shake, and all your minimized windows will return. This quirky feature is a handy little hack when you need to focus on one window in a hurry. Comment

Cyn Mackley © 2024. Manage your email settings or unsubscribe. Get the Jetpack app Subscribe, bookmark, and get real‑time notifications - all from one app! Automattic, Inc. 60 29th St. #343, San Francisco, CA 94110

2024-12-08 - About our Shop

Our shop is now payment enabled. Irrespective of whether we are eCommerce enabled, or not, if any person who desires to part with their hard earned money to pay for what we would call our lifetimes hardwork in the form of the worksheets and workbooks we have been developing since 2012 onwards, with or without the vba coding behind it.

Have never been much of a marketing personality, so have never been expressive about the talent that lies below the surface. This does not mean that the talent is not there!!

It is for the discerning person to understand the genuineness or falsehood that confronts them. We tepresented the truth yesterday, do so today and will continue to do so, so help me God!!

Please visit this feed of our shop to learn more about this. .

07-Dec-2024 | 21:13 Hours IST

CA Vikram Shankar Mathur

Spreadsheet-Formatting- CAVSM

Spreadsheet-Formatting- CAVSM

[VsmCoin] [Cavsmathur].[ExceltrainerAhmedabad.]

OpenWB

DOCTYPE html>

Open Your Workbook

Click the button below to open the workbook.

VIKRAM SHANKAR MATHUR DISA FAFP

VIKRAM SHANKAR MATHUR DISA FAFP

We are privileged to announce that our business, VIKRAM SHANKAR MATHUR DISA FAFP, also a registered Google Business profile available on Google Maps, is now authorized to receive payments on our personal mobile 9998090111 towards any entity bearing the same name, I.e. at least 5 of our Faebook Pages, the individual bearing that name, I.e. myself, or our Digital Showroom, available at https://www.vikramshankarmathur.link!!

vsmathurcoin.com

www.vsmathurcoin.com

The website/blog of CA Vikram Shankar Mathur,  it serves as a multi-purpose website, which is the web blog and the official Google Domain of the Developer account of vsmathur.co.in - Cheers!!

CA VIKRAM SHANKAR MATHUR

EmbeddedPostAWPDevFB

---

AHMEDABAD WORDPRESS DEVELOPERS - EMBEDDED POST

---

Did you know that when you create a #WordPress account at https://www.wordpress.com, you #Automatically create a...
Posted by Ahmedabadfca Wordpress Developers on Friday, 22 November 2019

---

Well, I have been managing in the past a lot many WordPress sites than was allowed, both by the Admin Teams of Facebook and Wordpress, little realising that it was against the COmmunity Standards of BOTH!! But having learn a valuable lesson, I am now going to make it a rule to obey all the rules of the game, if I ever want to succeed at MARKETING my amateurish (so far, as on November 23rd, 2019, at least!!) skills which as yet are newly learnt, but at the same time, I want to thank the Facebook Team and the WordPress Team for their excellent cooperation in allowing me to remain on both platforms, so that I could learn from my own mistakes and do things the right way around. Well, at any rate, please give your valuable comments on my efforts, so far below, thanks in advance!!

CA VIKRAM SHANKAR MATHUR
Nov-23-2019 | 13:55 Hours IST

Abusive-my-foot

Do you find my blog abusive?

I should really think not, because I have taken the UTMOST care to see that no "abusive" content is ever posted here, because I am the only contributor (okay, I am using many aliases, but that is because I am at heart a dedicated developer!!).

I think I know what precisely the reason could be why the Facebook Team has banned both my blog, as well as my personal website as "abusive". The remark that the above graphic (saved just seconds before I made this post) seems to suggest that it is either one single person, or a group of individuals, who must have "reported" these websites as abusive, either deliberately (which I highly doubt) or by accident (which seems more likely the case, because people often click the wrong button while removing posts from a Facebook Group / Page).

Well, to tell you very frankly, I have given up on this so called "fight with the faceless giant", because who am I really? Just another nameless soul alive on this planet, dutifully going about the place doing stuff that normal people (like you, my dear reader) do!! So I am now never, ever going to ask them to review their decision, because it has violated their Community Standards.

Community Standards are created to be honoured by the public at large, which again, consists of people like you and me. How many of us seriously study these standards is a million dollar question. However, everytime you sign into a social website, you are forced to agree to their terms and conditions, whether you read them or not, and I believe that more than 50% of the people who sign into these websites, do not. However, this is my personal opinion and observation, so I admit I could be wrong, but that is not the point that I am trying to make here.

I used to use this blog and my personal website to make posts, so that I could just link them into my Timeline or a Facebook Page. Which, obviously, I have been unable to do, since the last one year or more, simply because I get greeted pleasantly by the above type of a dialog box each and every time.

CAN YOU UNDERSTAND THE FRUSTRATION THAT I FEEL? 

Okay, let me tell you that around a year back, my website - which happens to be a Wordpress website, was infected with some malaware, which I managed to remove with the help of my ex-client and dear friend, who overlooked the fact that this happened because of my carelessness in not taking care of backups on a regular basis. So, this COULD have initiated the "abusive" part, because when you tried to go to my website, the malaware was redirecting it to God only knows which weird website(s), some may even have been porn sites.

On 18th September, 2019, I had the entire website taken down and recreated it from scratch. So now, there is no problem at all. This post is just to inform you, me dear beloved reader, of the facts as they stand from my end. What action that it is that you can take to help me, is in your hands entirely. My suggestion, of course, would be that you ought to report to Facebook that this needs to be reviewed seriously, and that too soon, but I leave that decision to you.

CA Vikram Shankar Mathur

04-Oct-2019 | 17:10 Hours IST
PS: View my profile on LinkedIn here.

--------------------------------------------------------------------------------------------------------------------------

How to contact the author?

VIKRAM S. MATHUR 

FCA, DISA (ICAI), FAFP (ICAI) 

Partner 

KARTIK T. VAYEDA & CO. 

Chartered Accountants 

B-404, Shashwat Apartments, 

Atithi Dining Hall Lane, 

Behind GNFC InfoTower, 

Bodakdev, AHMEDABAD-380054. 

CONTACT DETAILS
Telephone	:	+91-79-26841062
Mobile	:	+91-9998090111 / +91-8460890111
Email	:	vsmathurco@gmail.com
Website	:	http://www.vsmathur.co.in
Facebook	:	http://www.facebook.com/vsmathurco
Twitter	:	http://www.twitter.com/vsmathurco
LinkedIn	:	http://www.linkedin.com/in/vsmathurco
Instagram	:	http://www.instagram.com/vsmathurco
Pinterest	:	http://www.pinterest.com/vsmathurco
About.Me	:	http://about.me/vsmathurco
Blogspot	:	http://www.vsmathurcoin.com/p/about.html
Sharepoint	:	https://vsmathur.sharepoint.com

-----------------------------------------------------------------------------------------------------------------------------------
Hyperlinks Updated to open in new window! @ahmedabadfca (ahmedabadfca@gmail.com)

Enjoy !! CA Vikram Shankar Mathur

Date Modified: 16-Sep-2019 | 01:55 Hours IST

-------------------------------------------------------------------------------------------------------------------------------------