Create an Interactive Crossword Puzzle with Microsoft Excel

  Рет қаралды 12,040

OfficeNewb.com

OfficeNewb.com

Күн бұрын

Пікірлер: 16
@mellaniemerritt4411
@mellaniemerritt4411 2 жыл бұрын
Very cool! Learning how to do this makes it easier to understand/use/apply the functions to other projects. Thank you :)
@PerezerepL
@PerezerepL Жыл бұрын
Nice! I was looking for something else and your video came up. I enjoyed it. Thanks so much.
@OfficeNewb
@OfficeNewb Жыл бұрын
Glad you enjoyed it!
@alexdeean
@alexdeean 3 ай бұрын
Thanks! You helped me with my student project :D
@anniest-pierre6328
@anniest-pierre6328 2 жыл бұрын
This is so awesome! thank you!
@GirishMalur
@GirishMalur Жыл бұрын
Wonderful, Thanks for the awesome exercise.
@OfficeNewb
@OfficeNewb Жыл бұрын
Glad you enjoyed it!
@tyronesingletary9195
@tyronesingletary9195 2 жыл бұрын
I will use it at work at our next party
@OfficeNewb
@OfficeNewb 2 жыл бұрын
You'll be the hit of the party. :)
@MathiKrishnan
@MathiKrishnan 2 жыл бұрын
Hello Kyle, Thanks for the interesting exercise. Need a help in my case, I am getting value error ( Excel 2016 ) while using the formula as you mentioned. But it works in the below method. =IF(CONCATENATE(puzzle!O6,puzzle!O7,puzzle!O8,puzzle!O9,puzzle!O10,puzzle!O11,puzzle!O12,puzzle!O13)=B1,1,0) Am I missing something? Thanks, Mathi Krishnan
@OfficeNewb
@OfficeNewb 2 жыл бұрын
Hello Mathi - What is the error you are getting? =IF(CONCATE(puzzle!O6:O13)=B1, 1, 0)
@abudhabi4401
@abudhabi4401 2 жыл бұрын
Excellent, BUT how do I have the crossword without the answers for others to use?
@hamidelbouabidi583
@hamidelbouabidi583 Жыл бұрын
please how can make the completed version looks like yours because in my case it still shows 2 worksheets
@OfficeNewb
@OfficeNewb Жыл бұрын
You can always click on the link in the description of this video and download the completed version so maybe see what you need to do.
@ctreeves08
@ctreeves08 2 жыл бұрын
@OfficeNewb.com, this is awesome, thank you! For anyone looking to advance their office skills, I highly recommend Kyle. I've taken all his courses and loved them.
@OfficeNewb
@OfficeNewb 2 жыл бұрын
Hello Cliff - Thank you for the shoutout. I'm happy to hear you are enjoying the courses.
What's new in Crossword Compiler 11.30
8:24
WordWeb Software
Рет қаралды 807
Make Running Digital Clock in Excel
6:27
Spreadsheet Power
Рет қаралды 4,5 М.
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 81 МЛН
How to make a crossword for the New York Times
9:45
xwnexus
Рет қаралды 62 М.
How to Create a Crossword Puzzle | WIRED
11:28
WIRED
Рет қаралды 1,8 МЛН
Microsoft Excel - 5 Most Common Excel Functions
18:10
OfficeNewb.com
Рет қаралды 7 М.
Mail Merge from Excel to Microsoft Word
15:03
Technology for Teachers and Students
Рет қаралды 2,8 МЛН
How to Create a Word Search Puzzle in Excel - Tutorial
6:12
Y. Acosta Excel Tutorials
Рет қаралды 79 М.
Create an Excel PivotTable Based on Multiple Worksheets
7:16
OfficeNewb.com
Рет қаралды 501 М.
Excel Word Search Generator Explained
12:29
Excel Macro Mania
Рет қаралды 7 М.
How to make a CROSSWORD in word | Simple word tutorial
14:18
Lisa Doe
Рет қаралды 26 М.
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН