![Kelly McField Brown](/img/default-banner.jpg)
- 59
- 315 668
Kelly McField Brown
เข้าร่วมเมื่อ 27 มิ.ย. 2012
Color Code Outlook Calendar using Conditional Formatting
Set colors to appear on designated appointments in your Outlook Calendar. This will work as soon as you create the appointment with no extra steps necessary.
มุมมอง: 13 293
วีดีโอ
Sort CustomList
มุมมอง 1067 ปีที่แล้ว
Video Demonstration of how to sort data in Excel in a customized order.
Keyboard Shortcuts
มุมมอง 748 ปีที่แล้ว
A few various Keyboard Shortcuts for Microsoft Word including the selection of Data.
Excel Survey
มุมมอง 3118 ปีที่แล้ว
Excel Survey is a tool available through Office 365 that allows for online data collection. An online survey or form is created, share with a designated audience the completes the survey, and that the data collected automatically populates an Online Excel worksheet.
Snipping tool
มุมมอง 418 ปีที่แล้ว
This video demonstrates how to use the Snipping Tool to capture screenshots from the computer screen. It also shows the features of the Snipping Tool like sending the screenshot via email, copying and pasting the screenshot, and drawing on the screenshot.
Shape Gradients
มุมมอง 648 ปีที่แล้ว
This video demonstrates how to format a shape in Microsoft with a gradient fill. Gradient fill use colors that go from a darker shade to a lighter shade to give a more three-dimensional effect.
Graphics in Table
มุมมอง 338 ปีที่แล้ว
This video demonstrates how to place graphics in a Word table in order to keep the graphics in a set location on the page with specific alignment and order.
Basic Date Formula
มุมมอง 878 ปีที่แล้ว
This video demonstrates how to do calculates for dates, such as how many days or weeks are between two different dates. The new Excel 2013 DAYS function is also introduced.
Date Functions
มุมมอง 748 ปีที่แล้ว
This video demonstrates how to extract the month, day and year from a date. For example, if the date is 1/23/2015, only the day would be extracted and have just 23 appear in a cell, or have just 1 appear in a cell for the month, etc. The video also demonstrates the CONCATENATE function to which will put two or more text strings together in a cell.
VLOOKUP - Closest Match
มุมมอง 7K8 ปีที่แล้ว
This video demonstrates the use of Excel's VLOOKUp function to use a range of data to display in a worksheet based on a designated table of data. The example displayed in the video assigned letter grades to student test scores based on the numerical value of grades.
VLOOKUP- Exact Match
มุมมอง 3668 ปีที่แล้ว
This video demonstrates how to use the VLOOKUP Excel function to retrieve data from the same worksheet, a different worksheet or a different workbook and place it in a new worksheet. The example here is retrieving student reading scores from one table of data and placing the matching student reading score in another table of data.
Insert Hyperlinks in Word Documents
มุมมอง 758 ปีที่แล้ว
This video demonstrates how to insert a hyperlink to a web page or email message in Microsoft Word 2013.
Save, Share and Send Word Documents
มุมมอง 708 ปีที่แล้ว
Share Word Documents (Recorded with screencast-o-matic.com)
Fill PowerPoint Slide with Graphic Image
มุมมอง 688 ปีที่แล้ว
Fill PowerPoint Slide with Graphic Image
Find High Quality Graphic Files using Google
มุมมอง 558 ปีที่แล้ว
Find High Quality Graphic Files using Google
Hello could you make a video for Microsoft Outlook Calendar- to create appointments? Thank you
How do I get a ribbon and the features on it? I do not have that on my MS Outlook or Calendar features in the web portal. I have looked for days for these view features to set up colors. Thank you.
Perfect!
No running in circles, just straight to the point.Thanks
is this possible? row A has the quantity example (30) row B has numbers separated by commas, example (2.500,3.500,2.450,5.235) Row C has numbers separated by commas, example (2.500,3.500,2.450,3.650) this is the formula that I have that gives me the totals for both rows in row D. =SUM(VALUE(CELLSPLIT(B2,",")))+SUM(VALUE(CELLSPLIT(C2,","))). I would like to that the total in row D and multiply that by the quanitity of row A. I cant find a fix for this other than putting a formula in row E, example (=d2*a2). is there a way to add that multiplication formula to the formula that already exists in row D? if you can shed some light I would be appreciative. Michael
this tutorial sucks. it is not direct to the point. wtf
Crap. This doesn't work in Excel 2000.
Here, let me save you 2 minutes and 15 seconds: on the cell with the formula hover over the bottom right corner to show the cursor + and double click the left mouse button.
Thank you for this tutorial. Great help!
Thank YOU!
Helpful. Thank you!
Great information well presented.
Thank You very much for this video, it helped me to do over 130 cells. I was about to do the equation for every single cell until this video, very helpful . . .
This was helpful. Thanks
I want a rule to format the following words Rule 1 on [ABC] and Rule 2 [ABC] Project. It's possible to configure?
Thank you for simplifying this, I had watched a few videos and still didn’t get it until I watch you clear and concise video explaining how to. Thanks so much for sharing.
Thank you so very much. I used to do these adjustments one-by-one. Your video saved me so much time.
conditional formatting based on subject is simple, but I'm having issue when trying to set conditional formatting for meetings which has my email/name in the required field rather than in optional field.
Has salvado mi vida🎉😅 gracias 👍
thanks a lot maam
Wow, thank you
Hi Kelly, Do you have one formula that I can use to apply for one column(comment) to another column under the same worksheet
When we close and open the file that format is not being saved
great video
great video good job
Since moving to Office 2021 (from 2007) I have search and searched for how to color code my appointments. For WEEKS! Thank goodness I finally found how I can do it, but what a PITA compared to earlier versions. Why in the world MS removed the ability to simply assign a color directly in the appointment... or even have an option for categories is beyond me. I set up categories and found how to have it show up on my ribbon, but it's greyed out. I've used MS Office for decades, but I'm seriously looking into other options. If 2007 was still supported (and therefore secure), I'd reinstall it in a heart beat. It did everything I need for my one man office... and much simpler.
Thank you!
Short and clear, thank you.
can't be that easy, it just cant. LOL!
Absolutely beautifully explained. Excel can be intimidating especially since I have not used it since college many years ago. I needed the information that you just showed in this video to do my job today. Thank you.
i like this thank you
Thank you!
THANK U
Wow this saved me hours of work. Thank you so much hopes all is well 😁🙏
Any help with getting others in the shared calendar the same categories that I see as the admin when they add appointments?
luv u kelly thanxx apreciated
How can I share my calendar with my conditionsl formatting an colors? My team can see my calendar but cannot see the colors...its gray for them. I have share it many times. The only time they can open it is when i email the calendar
I have same question.
same too
Outdated. Not there in the newest version.
thanks \
Nice explanation. Do more tutorials!
thank you.very helpful
Hi, thanks for video. Any idea if you view calendar appointments by category, much like you would toggle on/off specific calendars? I would like to be able to view calendar based on each of several categories I have implemented, but cant seem to find how? Thanks in advance if you know.
Hey, did you manage to figure out how to do it? Coz I’m searching for the same too
Great video. Will this work in Outlook Web App (OWA) as well?
Oh my god, you are life-saving ! Thank you for this useful video
TALK less thank you
VERY INFORMATIVE
this bitch takes forever to explain something that takes 10 seconds to explain
It's very easiest & simpl way to auto fit in Excel thank u mam
thaaaaaaaaaaaaaaaanx
Thank you, easy to understand and follow.