![Alan Weaver](/img/default-banner.jpg)
- 352
- 2 409 323
Alan Weaver
Приєднався 18 січ 2008
Computer training in MS Office, Photoshop/Photoshop Elements, InDesign & more
PowerPoint 2016 placement of graphic
Demonstrates the following:
placement of graphic, resizing, position, artistic effect.
printed output (handouts, notes, slides)
themes
size of slide
placement of graphic, resizing, position, artistic effect.
printed output (handouts, notes, slides)
themes
size of slide
Переглядів: 163
Відео
Excel 2016 - basic functions - PMT, VLOOKUP, IF
Переглядів 8215 років тому
This video demonstrates PMT, VLOOKUP, IF statements. In addition, it includes naming a range and a discussion of absolute/relative references
Excel page 480 real estate sales report
Переглядів 6 тис.5 років тому
Excel page 480 real estate sales report
Excel countif and countifs
Переглядів 1795 років тому
Countif allows you to count either a text or numeric string to determine the number of occurrences. COUNTIFS allows youto count either text or numbers to determine the number of occurrences, allowing you to find numbers with a specific range, i.e. 100 - 200 in a data set range
Microsoft Word 365 references, footnotes, styles, table of contents, bibliography
Переглядів 20 тис.5 років тому
In this tutorial with Microsoft Word 365 learn how to do citations, footnotes, modify styles, add a table of contents, bibliography, and use the outline view
Create tables in Excel from existing data
Переглядів 31 тис.5 років тому
Excel tables are relatively simple to create yet can provide powerful methods of analyzing data. Filter data, get statistics, obtain totals, and format the table in minutes.
Updating a pivot table with named table range
Переглядів 6 тис.5 років тому
EXCEL - updating a pivot table when source data is in a named table range. A named range cannot be edited when it is used in a pivot table. The named range needs to be removed before doing an update.
add photos to Google photos including albums and basic edits
Переглядів 265 років тому
If you accept Google's standard resolution, it is free to upload unlimited photos. As many of us still use cameras for photography, this shows how to upload from your computer or memory card. A demo of basic edits and creating an album from your upload is included.
Elements 2018 create a poster
Переглядів 515 років тому
functions used: spot healing brush, copying/adding a photo from the internet (make sure you are not plagiarizing!), resizing a layer, moving moving, adding text, formatting font/color and adding drop shadows and other effects
Photoshop Elements - retouching a photo
Переглядів 1895 років тому
quick selection tool, floating new layers (and naming them), adjusting lighting/contrast, clone tool, healing brush tool
Elements 2018 intro to layers
Переглядів 385 років тому
Demonstration of layers in Photoshop Elements 2018. This uses the expert mode.
Photoshop adjust exposure using layers
Переглядів 8466 років тому
Done in Creative Cloud, the skills apply to newer versions of Elements. Using layers and the quick selection tool, a backlit photo's over and under exposure is fixed so it has a natural look.
Create a custom form in Access
Переглядів 2,8 тис.6 років тому
A customized data entry form not only encourages accuracy for data entry, but it looks better and can provide more functionality with push buttons to print a record, add a record, etc. A logo can be incorporated into the design. Many of the features are quickly done so the video doesn't run TOO long - it can be a bit tricky in the beginning as you have to observe the shape of the mouse when doi...
Excel - copy only filtered data and chart
Переглядів 1206 років тому
When filtering data and you want to only use the data shown, copy and paste will display all the hidden data. This method applies either to filtered data or using the subtotal function. You can use a Pivot Table/Chart to perform this, however this method is a bit simpler.
import slide from Word outline to powerpoint
Переглядів 3256 років тому
You can copy text from a Word file into PowerPoint - however by converting to an outline format, the text imports much quicker and easier into PowerPoint. Formatting may not be perfect - by using the outline view, a few shortcuts/tips to get fonts, colors to match are demonstrated.
Excel 2016 - create a forecast with goal seek
Переглядів 2,2 тис.6 років тому
Excel 2016 - create a forecast with goal seek
Obtain data for Excel from a Word file, the web, or a downloaded CSV file.
Переглядів 276 років тому
Obtain data for Excel from a Word file, the web, or a downloaded CSV file.
Paste link data/charts between Excel and PowerPoint
Переглядів 1846 років тому
Paste link data/charts between Excel and PowerPoint
Add photo/images to facebook business page
Переглядів 496 років тому
Add photo/images to facebook business page
Facebook business page - adding post, event, target audience
Переглядів 456 років тому
Facebook business page - adding post, event, target audience
Access - creating reports with formulas
Переглядів 2,5 тис.6 років тому
Access - creating reports with formulas
Using social media to enhance your online presence
Переглядів 176 років тому
Using social media to enhance your online presence
Thanks
I have a sheet like this but in my case: there are 3 Smiths (the name) category (i.e biology, math, and language). I would like to get the count each unique row (count the "x") for example smith language has three row of absence in this sheet (3 rows which has "x" to count). Please enlight me brother
Unbelievable, I have been struggling with this all day. Thank you Alan.
you save my life, thank youu
Best to clear your throat BEFORE you record a video, otherwise very irritating!
Perfect! Just what i needed
🙏🏻🙏🏻🙏🏻
0:35 Interesting to see the inside of the First Presbyterian Church. I have seen the outside many times from Bedford Street, I call it the fish church, but never went inside.
Amazing
Thank you so much!
how did you get the FUNCTION ARGUMENT window to show up?
Thanks so much ❤ it worked and in such less time😅 great vid🎉
How did you create Column A static column
Thank you Sir!
Hello! How do you make to show you the dates that they were absent, for example? I really need this formula and I don't know how to write it, thank you!
Hi, at 3:27 of the video, does the bracket need to be {"abs","late","ills"} or can the bracket be ("abs","late","ills")?
Hi, at 3:27 of the video, do we need to place sum() around countifs(B7:AD7,{"abs","late","ills"})? Can we just type countifs(B7:AD7,{"abs","late","ills"})?
Without the sum, you get an array formula, that will spill. Essentially, its counting each of the items in brackets separately, the sum, adds those together to get you the total count.
it helps, thank you :)
Thank you!!
Far too many Churches.
Just what I was looking for. Thanks Alan
What if the rows have a drop down list? How would the formula change? Thanks
that dude is simply the best, many thanks to the universe that you man exist 😎 🍻🥳
You are a legend, I subscribed
Useless, Thank you
useless
Thanks for the upload
This formula is woking in Excel, But not in Google sheets. How can I make it happen in google sheet ?
Good Upload 👌
Much love Buler. Or what ever your name is. Good info. thank you!
Its work sir
Useless, Thank you
useless
Hi I tried to use the countif function like you did in this video. Then I tried to define specific columns for the function but excel wouldn't let me select more than 3 ranges of columns. Is there a function that will allow me to get around this problem and be able to select and count words in multiple columns?
thanks alot i have in shifts shudle rota that has in row 6 the dates and my imployees works some times in weekends . how could i count by formula the days they work on weekends for trible fee. i wrote this formula but it dosent worked : my imployyes names start at A8 to A15 and the letter W is for work day ; and the dates from B6 to AF6: countifs( C7:AF7,"=W", B6:AF6,"weekday($B$6,1)>5") our weekend is friday and saturday. so what is wrong with my formula and how it should be ? thanks in advanced
ua-cam.com/video/811fooFk1MY/v-deo.html
Is it possible formula for count of RAM and HARI =sum(countifs(A1:A12,("RAM","HARI")))
It should have Curly Braces "{}" instead of small braces "()" before "Ram","Hari"
This is not Microsoft 365
Useless.
how do i type “5,5” without an error using IF formula?
Hi its amazing but what if i use two arrays for example =SUM(COUNTIFS(Y:Y,{"5,000 - 9,999","10,000 - 19,999"},Q:Q,{"Denmark","Finland","Iceland","Norway","Sweden"})) i am not getting exact result can you help ?
same bro, I don't know why when I use {"24-28"} it doesn't work, but when I try {"24", "25", "26", "27", "28"} it work
Thank you!!!
Thank you very much!
What makes the trains move. Ours doesn't. Santa spins n lights work but all levels of trains have stopped rotating
If row counting wrong by automatic how should correct
thank you so much
Do you think you could have went any faster with those pictures
How to include the blanks??
Do you know if for google sheets is different? It's not working for me
1:12 how ???? Mine didn't show up