Kelly McField Brown
Kelly McField Brown
  • 59
  • 315 668
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.
Straight Line in Word
มุมมอง 12K8 ปีที่แล้ว
Straight Line in Word
Conditional Formatting with Formulas
มุมมอง 5658 ปีที่แล้ว
Conditional Formatting with Formulas
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)
Quick Parts
มุมมอง 428 ปีที่แล้ว
Quick Parts
Quick Access Toolbar
มุมมอง 588 ปีที่แล้ว
Quick Access Toolbar
Format Painter in PowerPoint
มุมมอง 7648 ปีที่แล้ว
Format Painter in PowerPoint
Change Case Button in Word
มุมมอง 4.9K8 ปีที่แล้ว
Change Case Button in Word
Intro to Functions
มุมมอง 418 ปีที่แล้ว
Intro to Functions
COUNTA Function
มุมมอง 198 ปีที่แล้ว
COUNTA Function
COUNTIF Function
มุมมอง 148 ปีที่แล้ว
COUNTIF Function
IF Function
มุมมอง 188 ปีที่แล้ว
IF Function
SUMIF Function
มุมมอง 268 ปีที่แล้ว
SUMIF Function
Presenter View
มุมมอง 518 ปีที่แล้ว
Presenter View
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
PowerPoint PresenterView
มุมมอง 68 ปีที่แล้ว
PowerPoint PresenterView
Print PowerPoint Notes
มุมมอง 1.4K8 ปีที่แล้ว
Print PowerPoint Notes
PowerPoint Slide Master
มุมมอง 258 ปีที่แล้ว
PowerPoint Slide Master

ความคิดเห็น

  • @jayanthan9488
    @jayanthan9488 20 วันที่ผ่านมา

    Hello could you make a video for Microsoft Outlook Calendar- to create appointments? Thank you

  • @terrimalek
    @terrimalek 2 หลายเดือนก่อน

    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.

  • @bluesapphire7548
    @bluesapphire7548 3 หลายเดือนก่อน

    Perfect!

  • @yaweli2968
    @yaweli2968 3 หลายเดือนก่อน

    No running in circles, just straight to the point.Thanks

  • @michaeldennis3028
    @michaeldennis3028 3 หลายเดือนก่อน

    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

  • @rambarriers4502
    @rambarriers4502 3 หลายเดือนก่อน

    this tutorial sucks. it is not direct to the point. wtf

  • @billkeithchannel
    @billkeithchannel 4 หลายเดือนก่อน

    Crap. This doesn't work in Excel 2000.

  • @billkeithchannel
    @billkeithchannel 4 หลายเดือนก่อน

    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.

  • @paulwheeler3199
    @paulwheeler3199 4 หลายเดือนก่อน

    Thank you for this tutorial. Great help!

  • @user-zq8lw4zr2r
    @user-zq8lw4zr2r 5 หลายเดือนก่อน

    Thank YOU!

  • @Tubefish07
    @Tubefish07 6 หลายเดือนก่อน

    Helpful. Thank you!

  • @michaeleisenbise4278
    @michaeleisenbise4278 6 หลายเดือนก่อน

    Great information well presented.

  • @GXOR_LA
    @GXOR_LA 6 หลายเดือนก่อน

    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 . . .

  • @florenceonano3785
    @florenceonano3785 7 หลายเดือนก่อน

    This was helpful. Thanks

  • @ilidiofaria
    @ilidiofaria ปีที่แล้ว

    I want a rule to format the following words Rule 1 on [ABC] and Rule 2 [ABC] Project. It's possible to configure?

  • @solzmama679
    @solzmama679 ปีที่แล้ว

    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.

  • @user-tc4to9ru3n
    @user-tc4to9ru3n ปีที่แล้ว

    Thank you so very much. I used to do these adjustments one-by-one. Your video saved me so much time.

  • @richardsembilan9261
    @richardsembilan9261 ปีที่แล้ว

    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.

  • @missvillanueva6328
    @missvillanueva6328 ปีที่แล้ว

    Has salvado mi vida🎉😅 gracias 👍

  • @tanmaysawant3342
    @tanmaysawant3342 ปีที่แล้ว

    thanks a lot maam

  • @discutible
    @discutible ปีที่แล้ว

    Wow, thank you

  • @kelvinkhoo98
    @kelvinkhoo98 ปีที่แล้ว

    Hi Kelly, Do you have one formula that I can use to apply for one column(comment) to another column under the same worksheet

  • @sumanthvakacharla1915
    @sumanthvakacharla1915 ปีที่แล้ว

    When we close and open the file that format is not being saved

  • @marioh.4361
    @marioh.4361 ปีที่แล้ว

    great video

  • @TheBlessingReport
    @TheBlessingReport ปีที่แล้ว

    great video good job

  • @leocatz
    @leocatz ปีที่แล้ว

    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.

  • @user-vb8nd8bw3i
    @user-vb8nd8bw3i ปีที่แล้ว

    Thank you!

  • @vincentakanda7330
    @vincentakanda7330 ปีที่แล้ว

    Short and clear, thank you.

  • @ritaward6004
    @ritaward6004 ปีที่แล้ว

    can't be that easy, it just cant. LOL!

  • @Tubigirl
    @Tubigirl ปีที่แล้ว

    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.

  • @orwahassan821
    @orwahassan821 ปีที่แล้ว

    i like this thank you

  • @MrPink-hm3lm
    @MrPink-hm3lm ปีที่แล้ว

    Thank you!

  • @juliebabes9667
    @juliebabes9667 ปีที่แล้ว

    THANK U

  • @odanyboy84
    @odanyboy84 ปีที่แล้ว

    Wow this saved me hours of work. Thank you so much hopes all is well 😁🙏

  • @donovang6911
    @donovang6911 ปีที่แล้ว

    Any help with getting others in the shared calendar the same categories that I see as the admin when they add appointments?

  • @demonicgaming4342
    @demonicgaming4342 ปีที่แล้ว

    luv u kelly thanxx apreciated

  • @lindat8750
    @lindat8750 2 ปีที่แล้ว

    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

  • @deepspace8
    @deepspace8 2 ปีที่แล้ว

    Outdated. Not there in the newest version.

  • @janaesaffold2531
    @janaesaffold2531 2 ปีที่แล้ว

    thanks \

  • @letsgosurfingdude
    @letsgosurfingdude 2 ปีที่แล้ว

    Nice explanation. Do more tutorials!

  • @wycliffmachipisa3656
    @wycliffmachipisa3656 2 ปีที่แล้ว

    thank you.very helpful

  • @Bella-hz7nt
    @Bella-hz7nt 2 ปีที่แล้ว

    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.

    • @prasannarahini8488
      @prasannarahini8488 ปีที่แล้ว

      Hey, did you manage to figure out how to do it? Coz I’m searching for the same too

  • @vinhvo-ma921
    @vinhvo-ma921 2 ปีที่แล้ว

    Great video. Will this work in Outlook Web App (OWA) as well?

  • @chhunyi6040
    @chhunyi6040 2 ปีที่แล้ว

    Oh my god, you are life-saving ! Thank you for this useful video

  • @dariencannon4430
    @dariencannon4430 2 ปีที่แล้ว

    TALK less thank you

  • @ravindrapaturkar6147
    @ravindrapaturkar6147 2 ปีที่แล้ว

    VERY INFORMATIVE

  • @michaelpickett6856
    @michaelpickett6856 2 ปีที่แล้ว

    this bitch takes forever to explain something that takes 10 seconds to explain

  • @pradeepkumar-yx5uk
    @pradeepkumar-yx5uk 2 ปีที่แล้ว

    It's very easiest & simpl way to auto fit in Excel thank u mam

  • @lady5445
    @lady5445 2 ปีที่แล้ว

    thaaaaaaaaaaaaaaaanx

  • @kevinforde2490
    @kevinforde2490 2 ปีที่แล้ว

    Thank you, easy to understand and follow.