• Home
  • Business Solutions
    • Marketing Consulting
    • Web Design
    • Website Maintenance
    • WordPress Site Maintenance
    • Email Marketing
    • Social Media Support
    • Writing
    • Google Changes
    • Strategic Partners
  • Computer Skills
    • Friday Free-For-All
  • Portfolio
  • Blog
  • About Us
  • Contact Us
    • Book Us
    • Online Payments

Your Computer Lady

  • Email
  • Facebook
  • LinkedIn
  • Twitter
You are here: Home / Archives for Microsoft Office - Excel

July 24, 2017 By yclmanager5 Leave a Comment

Cursors in Excel

Have you ever wondered what all the different cursors do in Excel?  Here is a short video to show what they all do and where to place your cursor to achieve your desired task.

Share the post "Cursors in Excel"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel

May 1, 2017 By yclmanager5 Leave a Comment

Shortcut to Time/Date Stamp in Microsoft Excel

Here is a quick short cut you can use to add a time and or date stamp into a cell in Excel.  For a Date Stamp, first select your cell and then press CTRL+; (Control Key and the Semi Colon key).  For the Time Stamp, once again select your cell and then press CTRL+ SHIFT+: (Control Key, Shift Key, and the Colon Key).

Share the post "Shortcut to Time/Date Stamp in Microsoft Excel"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel

March 6, 2017 By yclmanager5 Leave a Comment

Move Between Different Open
Microsoft Office Files

When you have multiple spreadsheets open, it can take many clicks shifting between different files. In addition, you never want to end up entering information into the wrong file. Use Ctrl + Tab to shift between different files easily. The great part of this tip is that it also works in other programs as well like Firefox and Chrome while using Windows 7. You can easily shift between any open tabs!

Share the post "Move Between Different Open Microsoft Office Files"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel, Microsoft Office - Word, Organization & Productivity

January 9, 2017 By yclmanager5 Leave a Comment

Compare Documents in Microsoft Office

Tired of having to switch back and forth between documents when comparing data? There is tool you can use to have your documents side by side with a couple clicks.

  1. First click on the View tab
  2. Then click View Side by Side in the Window group
  3. You can also stay at the same point on each spreadsheet by clicking Synchronous Scrolling.

Simple as that!

Share the post "Compare Documents in Microsoft Office"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel, Microsoft Office - Word

December 26, 2016 By yclmanager5 Leave a Comment

Linking Excel Data into a Word Document

This is a great tip that you can use especially if you use the same data in multiple places.  Linking your information means, you only have to change it in one place.  This video will show you how it is done.

Share the post "Linking Excel Data into a Word Document"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel, Microsoft Office - Word

December 5, 2016 By yclmanager5 Leave a Comment

Loose the Ribbon

Have you ever needed to look at your document with the least amount of distractions on your screen?  By hiding the ribbon, you can see your document more clearly.

Press CTRL+F1 to hide the ribbon.  To see it again press the same keys again or double click on the tab heading that you would like to use and you will be able to see the full ribbon again.

Share the post "Loose the Ribbon"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel, Microsoft Office - PowerPoint, Microsoft Office - Word

November 28, 2016 By yclmanager5 Leave a Comment

Highlighting with Keyboard Commands in Excel

There are much easier ways to select a group of data than using your mouse and dragging the cursor. Especially if your mouse occasionally tries to run away.

Depending on what you would like to highlight there are several different keyboard command that use the Shift key.

  • Press CTRL+ SHIFT and then press one of your arrow keys and it will select all the data in that row or column in the direction of the arrow key you pressed.
  • Press SHIFT and your arrow keys and you will be able to go cell by cell and select a very specific set of data.
  • Press CTRL+SHIFT+END and you will select from your selection point to the lowest right hand cell.
  • Press CTRL+SHIFT+* and you will select all the data in your document no matter where your selection point is.

Share the post "Highlighting with Keyboard Commands in Excel"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel

October 17, 2016 By yclmanager5 Leave a Comment

Protect your Microsoft Excel Sheets

Do you have an Excel document that is shared between co-workers? But there is one sheet that you need to make sure isn’t edited.  You can easily protect it by right clicking on the sheet tab and clicking “protect sheet.”  In the new dialog box you can set a password and if you wish even specify further as to which cells can or cannot be edited.

Share the post "Protect your Microsoft Excel Sheets"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel

October 10, 2016 By yclmanager5 Leave a Comment

Change the Defaults in Excel

If you use Excel often and are not a fan of the default settings it has set for the font and font size, you can change them and even change the default number of sheets it sets up in a new document!  Here is how:

  1. Click the File tab
  2. Then click Options
  3. Look in the pop up window under General
  4. You can make all the changes you want to these default settings here

There are many things that you can do to make Microsoft Excel easier to use and changing your default settings is simple way to do this.

Share the post "Change the Defaults in Excel"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel

October 3, 2016 By yclmanager5 Leave a Comment

Find Out If Using an Excel Template Could Help You

There are many different projects that I have done in Microsoft Word where I have used Templates to save myself some extra work.  But, did you know you can do the same thing in Excel? The next time you open up Excel click on the File tab and then New, and in the second half of your screen check out all the different templates you can use in Excel to help save you some time.  There are templates to help save you time on business projects and personal ones alike. Budgets, invoices, and amortization schedules are just a few of the templates Excel has available. Depending on the template, some even have formulas already inserted and are ready for data to calculate.

Share the post "Find Out If Using an Excel Template Could Help You"

  • Facebook
  • Twitter
  • Google+
  • Pinterest
  • E-mail

Filed Under: Microsoft Office, Microsoft Office - Excel

  • 1
  • 2
  • 3
  • …
  • 13
  • Next Page »

Sign up for YCL News

Sign Up Now
Constant Contact - For Email Marketing you can trust.

Testimonials

  • Testimonials

Blog Topics

  • Apps
  • Blogging
  • Comic Relief
  • Communication
  • Computer Maintenance
  • Computer Skills Training
  • Email Marketing
  • Internet
  • Marketing
  • Microsoft Office
  • Microsoft Office – Excel
  • Microsoft Office – Outlook
  • Microsoft Office – PowerPoint
  • Microsoft Office – Word
  • Microsoft Office- Publisher
  • Organization & Productivity
  • Portfolio
  • Portfolio – Computer Skills Training
  • Portfolio – Email Marketing
  • Portfolio – Marketing
  • Portfolio – Social Media
  • Portfolio – Web Sites
  • Portfolio – Writing
  • Search Engine Optimization
  • Social Media
  • Social Media – Facebook
  • Social Media – LinkedIn
  • Social Media – Pinterest
  • Social Media – Twitter
  • Social Media- Houzz
  • Social Media- Instagram
  • Something to Think About
  • Technology
  • Testimonials
  • Uncategorized
  • Videos
  • Websites
  • Windows
  • WordPress

News from our Blog

Social Media
Social Media Examiner asked their experts for the key trends to watch for and integrate into marketing plans for 2021. VERY interesting article with useable info!...
Monotonous Monday
Yes! Let\'s break the monotony! Your Computer Lady is available to help you organize, create and monetize your marketing so that neither you nor your prospects are bored! We create marketing solutions ...
6 Small Business Lessons to Take Into 2021
This is a well thought out article about preparing for 2021.\r\n...
700 Power Words
\r\nI frequently talk with you about having a list of your Keywords at your fingertips while you are writing blog posts, social media posts, web page content. This helps ensure that you use the best wor...
Pixel Tracking
Yesterday I went to a website to see what they offered in home meal deliveries.  I didn’t set up an account. I didn’t request a quote.  Just looked around the site.\r\n15 minutes later there was a...
New Guidelines for Online Marketing
This is a GREAT article about our new world and how we can and should market our businesses. Practical suggestions and tips. Using reality to put our best foot forward.  Please read this!\r\n ...
Birds and Marketing?
Why is filling the bird feeder like marketing your business? Inquiring minds want to know! Read on, my friends!...
Request for Reviews
Testimonials have always been an important part of marketing. Today, in our digital world, online reviews are critical. Many prospects check for reviews on Google or Facebook before they even visit a ...
Plant Your Friggin\' Tree!
I love this discussion with Pat Lencioni and team about the NEED to make decisions now and move in the right direction. I agree with him. We can\'t wait for \"normal\" to return. It\'s not coming back.  ...
PayPal
PayPal has a new \"Smart\" button to use on your website. It offers PayPal, Venmo, major credit cards in one easy click. Much easier for your clients! There are other options you should check out too.\r\n...
  • Email
  • Facebook
  • LinkedIn
  • Twitter

Copyright 2010-2020 · Your Computer Lady Inc. All rights reserved.   Privacy Statement.   Website Disclaimer.