Vertex42
Vertex42
  • Видео 62
  • Просмотров 10 700 647
Designing Playing Cards in Excel
Hey spreadsheet fans! If you like card games, watch as I design a set of playing cards with Excel. If you would like a set of these cards, follow my Kickstarter project here: www.kickstarter.com/projects/vertex42/spreadsheet-playing-cards?ref=bvif3x
For more details, see the blog post on Vertex42:
www.vertex42.com/blog/news/excel-feature-suggestions.html
Video by Vertex42.com
Cards Produced by BoardGaming.com
Note: Artwork of final physical cards subject to change
Просмотров: 1 652

Видео

How to Create a Gantt Chart in Google Sheets
Просмотров 895 тыс.4 года назад
Learn how to create a Gantt Chart in Google Sheets to use as a simple and powerful project management tool. This video is a useful Google Sheets tutorial for project managers. You can follow it step-by-step, or you can get the free template from the link below: www.vertex42.com/ExcelTemplates/simple-gantt-chart.html CONTENTS 0:17 Add Tasks and Dates 0:52 Create Task Dependencies Using Formulas ...
How to Customize A Calendar Template in Excel
Просмотров 94 тыс.4 года назад
Learn how to create a calendar in Excel by customizing a calendar template from Vertex42.com. Watch how to merge and unmerge cells, change the overall theme (fonts and colors), make a checklist, insert an image, and do some basic formatting. Download the calendar template from here: www.vertex42.com/calendars/2021.html Excel Basics: Editing this calendar template requires only basic Excel skill...
How to Convert Excel to PDF
Просмотров 462 тыс.4 года назад
Learn how to convert Excel to PDF using 3 different methods: Print to PDF in Windows 10, Save as PDF, and Export to PDF. 0:13 How to Print to PDF using Windows 10 (Microsoft Print to PDF) 0:51 How to Save As PDF (for new and older versions of Windows) 1:17 How to Export to PDF 2:11 Top 3 Reasons to Convert Excel to PDF TEMPLATES Used In This Video: Invoice Template: www.vertex42.com/ExcelTempla...
How to Make a Gantt Chart in Excel
Просмотров 3,7 млн4 года назад
Learn how to Make a Gantt Chart in Excel, including features like a scrolling timeline and the ability to show the progress of each task. Watch as I create the Simple Gantt Chart template from scratch, or download the template: www.vertex42.com/ExcelTemplates/simple-gantt-chart.html 👍 Remember to Subscribe and Turn on Notifications (click on the bell) THIS VIDEO: 0:20 Step 1 - Start with a List...
Google Sheets Tutorial for Beginners
Просмотров 105 тыс.4 года назад
Learn how to use Google Sheets with this basic tutorial, starting with how to use Google Drive, how to get a template, spreadsheet basics, entering data, creating basic formulas, and other need-to-know basic spreadsheet skills. Tip: Change your view settings to HD if the video appears blurry. 0:10 How to Use Google Drive 1:01 How to Get a Template 2:33 Sharing and Security on Google Drive 3:29 ...
How to Use Flash Fill in Excel
Просмотров 23 тыс.4 года назад
Learn how to use Flash Fill in Excel to quickly reformat data without formulas. Examples include separating last names and first names, fixing capitalization, combining data from multiple columns, removing extra spaces, and separating parts of addresses. Reminder: The Flash Fill keyboard shortcut is CTRL E 0:00 Getting last names and first names from a list 1:24 Reformatting in one step (and 1:...
Ghost in My Spreadsheet
Просмотров 6 тыс.4 года назад
Want to have a little office fun on Halloween? Play a trick by adding a ghost in your shared spreadsheet that appears randomly. If you aren't going to use the trick, share this video with your friends and coworkers. 👻 Like it? Remember to subscribe! FOLLOW VERTEX42 HERE: Instagram: vertex42 Facebook: vertex42/ Pinterest: www.pinterest.com/vertex42/ Twitter: twitter.c...
How to use Shrink to Fit in Excel
Просмотров 25 тыс.4 года назад
Learn how to use the "Shrink to Fit" feature in Excel. Dates and numbers that don't fit in a cell are displayed as . Using Shrink to Fit, Excel will reduce the font size automatically to fit within the cell. 0:03 The problem in Excel 0:13 Applying Shrink to Fit to fix the problem 0:40 When to use Shrink to Fit (4 reasons) 👍Remember to Subscribe! FOLLOW VERTEX42 HERE: Instagram: ve...
✔ How to Insert a Check Mark (Tick Symbol) in Excel
Просмотров 42 тыс.4 года назад
Learn how to insert a check mark (tick symbol) in Excel using 5 different methods. See below to jump to specific points in the video. CHECK MARK AND OTHER SYMBOLS TO COPY AND PASTE: ✔ ❌ 👍 ❤ ◀ ▶ ⭐ ⬜ ⚪ ± × ÷ ° ℉ ℃ ∅ 0:07 Method 1: Use the Windows 10 Emoji Panel Keyboard Shortcut 0:42 Make it a green tick symbol by changing the font color 0:54 Method 2: Use the Insert ▷ Symbol tool 1:30 Method 3: ...
How to Use AutoFill in Excel
Просмотров 88 тыс.4 года назад
Learn how to use AutoFill in Excel to create a list of numbers, dates, month names, or weekday names when you drag the fill handle. Also learn how to create a custom list. 0:03 Drag the Fill Handle to create a numbered list 0:20 Use the CTRL Drag shortcut 0:27 Fill a numeric pattern (10, 20, ...) 0:33 Fill in Month Names (Jan, Feb, ...) 0:40 Fill in Days of the Week (Mon, Tue, ...) 0:55 Fill Da...
How to Freeze Panes in Excel
Просмотров 25 тыс.4 года назад
Learn how to use the Freeze Panes feature in Excel to lock cells from scrolling. See below to jump to specific clips. 0:01 How to Freeze Rows in Excel 0:31 How to Freeze the Left Column(s) in Excel 0:54 How to freeze BOTH Rows and Columns 👍Remember to Subscribe! TEMPLATE USED IN THIS VIDEO: Personal Budget Spreadsheet: www.vertex42.com/ExcelTemplates/personal-budget-spreadsheet.html FOLLOW VERT...
Calculating Dates using Gantt Chart Template Pro 4.0
Просмотров 25 тыс.5 лет назад
This video shows how to define tasks in Gantt Chart Template Pro, version 4.0, using different sets of inputs to define the start and end dates, durations, predecessors, etc. For more information, visit the following page on Vertex42.com: www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html FOLLOW VERTEX42 HERE: Website: www.vertex42.com Instagram: vertex42 Facebook: fac...
How to Create Custom Number Formats in Excel
Просмотров 46 тыс.5 лет назад
This video provides a brief overview of how to create a custom number format in Excel to display dates in different ways, display special characters (like arrows) and change the color to red for negative numbers. To learn more and see more examples, read the full blog post on Vertex42.com at www.vertex42.com/blog/excel-tips/custom-number-formats-in-excel.html 👍 Remember to Subscribe! FOLLOW VER...
Introduction to Pivot Tables in Excel
Просмотров 21 тыс.5 лет назад
Learn how to use Pivot Tables in Excel to easily summarize data. The example uses income and expense data and shows how to summarize by account, category and date. See the corresponding blog article: www.vertex42.com/blog/excel-tips/using-pivot-tables-to-analyze-income-and-expenses.html 0:14 How to Insert a Pivot Table 1:06 Using the field list pane to construct the Pivot Table 1:54 Add a Calcu...
Adding Columns to the Gantt Chart
Просмотров 34 тыс.5 лет назад
Adding Columns to the Gantt Chart
Money Management Spreadsheet Demo
Просмотров 80 тыс.5 лет назад
Money Management Spreadsheet Demo
How to Use the Family Budget Planner Spreadsheet
Просмотров 82 тыс.5 лет назад
How to Use the Family Budget Planner Spreadsheet
Home Mortgage Calculator Demo
Просмотров 16 тыс.6 лет назад
Home Mortgage Calculator Demo
Monte Carlo Simulation in Excel - Breakeven Analysis Example
Просмотров 32 тыс.6 лет назад
Monte Carlo Simulation in Excel - Breakeven Analysis Example
Handling Project Schedule Uncertainty with a Monte Carlo Simulation
Просмотров 35 тыс.6 лет назад
Handling Project Schedule Uncertainty with a Monte Carlo Simulation
How to Use the Vacation Tracking Spreadsheet
Просмотров 25 тыс.6 лет назад
How to Use the Vacation Tracking Spreadsheet
How to Use the Savings Snowball Calculator
Просмотров 15 тыс.6 лет назад
How to Use the Savings Snowball Calculator
How to Create a Vertical Timeline in Excel
Просмотров 72 тыс.6 лет назад
How to Create a Vertical Timeline in Excel
How to Create Array Formulas in Excel
Просмотров 110 тыс.6 лет назад
How to Create Array Formulas in Excel
Create a Weekly Budget
Просмотров 48 тыс.6 лет назад
Create a Weekly Budget
Debt Reduction Calculator Tutorial - Use a Debt Snowball to Pay Off Debt
Просмотров 183 тыс.6 лет назад
Debt Reduction Calculator Tutorial - Use a Debt Snowball to Pay Off Debt
How to Use VLOOKUP and INDEX MATCH in Excel
Просмотров 87 тыс.6 лет назад
How to Use VLOOKUP and INDEX MATCH in Excel
Dynamic Named Ranges in Excel
Просмотров 26 тыс.6 лет назад
Dynamic Named Ranges in Excel
Create a Drop Down List in Excel
Просмотров 43 тыс.6 лет назад
Create a Drop Down List in Excel

Комментарии

  • @kyse2
    @kyse2 Час назад

    we need an updated video on this because my excel does not look like this 6 year old one and makes it really hard for me to follow it

  • @akaz50
    @akaz50 4 дня назад

    waw

  • @samuelbenson2381
    @samuelbenson2381 4 дня назад

    Wow

  • @katarinakrysmuller
    @katarinakrysmuller 9 дней назад

    great video! I have one question, how would you configure the start/end dates to skip weekends & holidays?

  • @user-yr3hx8ft3o
    @user-yr3hx8ft3o 10 дней назад

    this is great, How do i exclude weekends ?

  • @JustinFranzUy
    @JustinFranzUy 11 дней назад

    Can I just say this is probably one of the best tutorial videos I've ever seen on youtube. Simple, easy to understand, straightforward, good video quality, not too long. It goes over each procedure in a way that is easy to understand and doesn't over explain. Learned so much from this one video. Thank you, I hope you make more videos in the future.

  • @brendanprice2780
    @brendanprice2780 12 дней назад

    You have got to be kidding me with this video. Are you sure you don't want to go over the origin of the pie?

  • @pradeepnair2119
    @pradeepnair2119 12 дней назад

    Very useFull❤❤❤❤

  • @najumshakeel225
    @najumshakeel225 13 дней назад

    Fantastic tutorial I use it as reference

  • @rachelnewby6940
    @rachelnewby6940 14 дней назад

    This is brilliant, but I must have missed something as the scroll function is only scrolling the first column and the rest are static.... argh!

  • @karlthefirst8690
    @karlthefirst8690 18 дней назад

    This video is incredible, THANK YOU. One question if anyone is still reading this thread: how can I add a 3rd and 4th phase or additional tasks within a phase without screwing up the formulas and formatting? Assuming there’s a way but I’m a total newbie to Sheets and can’t figure it out. Any help hugely appreciated, thank you!

  • @mysisthinksieathair4996
    @mysisthinksieathair4996 22 дня назад

    Is there a way to know where the position should be

  • @TheTeguhdinatazt
    @TheTeguhdinatazt 22 дня назад

    very thankss to your channel and knowledge

  • @sana.maq1
    @sana.maq1 23 дня назад

    It is not picking my end date and the bar is extending to the end of the calendar. How to fix it.

  • @fienbon
    @fienbon 25 дней назад

    Can you also represent a date in the GANTT if it is only one day?

  • @ManaChunsuttiwat
    @ManaChunsuttiwat 25 дней назад

    You're amazing. This is the most helpful tutorial I've ever watched in my entire life. So effective and entertaining too. Thank you so much!!!

  • @andrewbrown1687
    @andrewbrown1687 25 дней назад

    This was incredibly helpful! Thank you so much!

  • @chicken29843
    @chicken29843 28 дней назад

    Audio is too fucking quiet you stupid fucking bitch

  • @MariaFernandaCelyMoreno
    @MariaFernandaCelyMoreno Месяц назад

    Hi guys, I applied the formula to make the timeline dynamic, however it doesn´t work well, when I change the display week only change the row with dates but not the complete data . Do you know what´s going on?

  • @rickglorie
    @rickglorie Месяц назад

    Fuuuuu. For non-english users; watch out with , used here, use ; instead.

  • @tootscarlson
    @tootscarlson Месяц назад

    The volume on this is so low - I noticed the same on other videos from this same source.

  • @adarshmehta5184
    @adarshmehta5184 Месяц назад

    Need part 2

  • @munamacoffee
    @munamacoffee Месяц назад

    I need a help for my formula, I want color my column using conditional formating but exclude sunday and national holidays without reducing the number of working days, can you give me the right formula, please?

  • @aftabalam-qc7jh
    @aftabalam-qc7jh Месяц назад

    Very much useful videos

  • @sureshsati7701
    @sureshsati7701 Месяц назад

    Is * correct in the formula? If not correct, what is the correct one?

  • @bluefocused8036
    @bluefocused8036 Месяц назад

    A guru, you are!

  • @user-ck6eo3mw4n
    @user-ck6eo3mw4n Месяц назад

    How do you exclude Saturday and Sunday, or any other day?

  • @TheEdca2000
    @TheEdca2000 Месяц назад

    Hello vertex, thanks for a very unique video and it help us alot. I have just one question about the progress bar about the =1°AND a can't type 1° can you advise it for me how do we it done? Thanks

  • @arashamirshahr
    @arashamirshahr Месяц назад

    how add new Custom Formats ? Not Edit

  • @Amila-ym7ny
    @Amila-ym7ny Месяц назад

    heaven sent video

  • @MakakunaruLoco
    @MakakunaruLoco Месяц назад

    Thanks

  • @pete7019
    @pete7019 Месяц назад

    Great video! Just finished building it!

  • @monugana
    @monugana Месяц назад

    conditional formatting not working for me. what did I do wrong ?

  • @carlosacosta-hh2iv
    @carlosacosta-hh2iv Месяц назад

    My friend this is incredible. I really am impressed/ Great value to all. Please continue. Thank you

  • @spaced2263
    @spaced2263 Месяц назад

    How do I change start date from '=Today ()'

  • @lyrisize
    @lyrisize Месяц назад

    This might be the greatest video ever created

  • @colinjia1357
    @colinjia1357 Месяц назад

    Great video, learned a lot. Thanks so much!

  • @classiccharm15
    @classiccharm15 Месяц назад

    Thank you

  • @classiccharm15
    @classiccharm15 Месяц назад

    Thank you so much for the many forms.

  • @jenskautler
    @jenskautler Месяц назад

    Thanks for the great video. I do have one questions: I would like to add a planned date and a real achieved date and show this in the chart to give full transparence of a project. How would I do this?

  • @davewelch2740
    @davewelch2740 Месяц назад

    At 1:50 you select a group of 7 rows and copy to the right. When I try this it tells me all merged cells need to be the same size.

  • @mrtalentfrei4862
    @mrtalentfrei4862 Месяц назад

    ist es möglich bei einem größerem Projekt die Aufgabennamen auch neben oder in die Balken zu schreiben?

  • @jonathanobrien8691
    @jonathanobrien8691 2 месяца назад

    How would we extend the table so we can fit all of our creditors if we have more then 10

    • @setapartforpurpose24
      @setapartforpurpose24 Месяц назад

      you will need to buy the one that can fit 20 or 40 creditors. It's only this one that can fit 10 creditors that is free.