https://www.youtube.com/watch?v=yEu8XB4_Olc
http://Excel.TV'Friend of the Show" Szilvia Juhasz is developing an Excel Cocktail book in conjunction with the release of Mr Excel's Top 40 Excel Tips. Did

https://excel.tv/29-excel-inspired-cocktail-book-w-xszil/
Blog. /. Excel TV Episodes & Interviews. /. 29: Excel Inspired Cocktail Book w/ Xszil. Fan favorite Szilvia Juhasz joins us to discuss her book that will be released as a subset of Bill Jelen's (aka Mr Excel) much anticipated XL: 40 Greatest Excel Tips of All-Time. The release is aimed for September 2015.

https://www.tealhq.com/interview-questions/excel-expert
Communicate Your Thought Process: Be ready to explain your reasoning and approach to solving Excel-related tasks. This demonstrates your analytical thinking and attention to detail. Ask Insightful Questions: Prepare questions that show your interest in how the company uses Excel and data analysis in their operations.

https://www.geeksforgeeks.org/excel-interview-questions-and-answers/
1. What is Excel used for? Excel is a spreadsheet program used for data organization, analysis, and visualization. It provides many features such as: Performing Complex Calculations with the help of buil-in functions such as COUNTIF, SUM etc. Creating charts. Creating Graphs for Data Visualisation and more. 2.

https://excel.tv/24-excel-mvp-and-author-kevin-jones/
Mr Kevin Jones, Data Automation Guru. OK. Kevin's a bit more modest than I am. Term like guru and "Hey Kevin, tell them about your book…. The best Excel Book ever written", is met with laughter from Kevin. Kevin is an Excel MVP, and the author of two Excel books. Most recently the Excel Tables book that he co-wrote with Zack Barresse.

https://www.excelcampus.com/tips/mr-excel-book-40-greatest-tips-review/
Part 3 of the book includes Szilvia's new book called, The Excel Lover's Guide to Cocktails. This is an Excel inspired cocktail recipe book. You will learn how to make some great drinks like the Power Pivotini (think Martini), Stacked Column Shot, Ctrl+B (think Bloody Mary), Broken Link (think Old Fashion), and many more. The cocktail book is

https://excel.tv/szilvia-juhasz-excel-expert-interviews/
Free 24 Excel Tips Guide. Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'. A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!

https://www.mrexcel.com/products/mrexcel-xl/
PDF ISBN: 978-1-61547-227-7. For my 40th book, I wanted a simple title of MrExcel 40. But, in the tradition of those great movies of my youth, I converted 40 using =ROMAN (40) to XL. It was probably somewhere around Book #33 that I realized that I would eventually get to book #40 where the Roman Numeral would be XL. And its a book about Excel.

https://excel.tv/michael-alexander-bacon-bits-blog-excel-expert-interviews/
Free 24 Excel Tips Guide. Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'. A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!

https://excel.tv/excel-book-author-oz-du-soleil-excel-expert-interviews/
Yes, our very own Oz du Soleil. He discusses the progress on a book he's writing on Excel and his upcoming online show on Excel. So, let's get to it! 1 - Full Contact Data Management. You guessed it right! His new book is named "Full Contact Data Management: Excel Methods for Exposing, Handling and Preventing Bad Data".

https://introtallent.com/excel-interview-questions-for-analytics-and-mis/
Go to the "Data" menu. Click on "Data Validation.". In the "Data Validation" dialog box, select the "Settings" tab. In the "Allow" dropdown, choose "List.". In the "Source" field, either type in the list items separated by commas or select a range of cells that contains the list items.

https://www.theknowledgeacademy.com/blog/excel-interview-questions/
This question will assist the interviewer in knowing whether you can format data in Excel. You can use this as your sample answer: " If I want to format data, I will click on the cells and then click on the 'Home' tab. There are options to change the font, number format, cell colour, borders, and alignment."

https://www.reddit.com/r/cocktails/comments/y443yq/i_made_a_cocktail_robot_in_excel/
its a tiki thing. you soak a cuton in something flammable (lemon juice, overproof rum, etc.)--> put it in a lime husk and float it on top of the drink--> light it on fire--> dust Cinnamon on top of. the Cinnamon will light on fire and be very pretty (thus why its a garnish) and add a tiny bit of flavor to the drink. 3.

https://www.testgorilla.com/blog/advanced-excel-interview-questions/
5 critical general advanced Excel interview questions and some potential answers. When you are interviewing candidates for your vacancy, look for these answers in response to 5 of the most important general advanced Excel interview questions. 1. Describe how you would protect workbooks, sheets, and cells in Excel.

https://www.reddit.com/r/bartenders/comments/17zf6cs/heres_a_spreadsheet_for_managing_costs_and/
Every month I duplicate the spreadsheet and keep that current month with only active cocktails, so it keeps it from getting cluttered. I use the old months as a reference if need be. For pricing on classics I found a hack with our POS, Toast, so that we can build cocktails by ingredient and get correct costs. That's a whole other thing though

https://www.reddit.com/r/cocktails/comments/xyjou/wanted_to_share_my_cocktail_spreadsheet_based/
For the Margarita I enjoy a 3:2:1 tequila, cointreau and lime juice ratio with no added sweetener. It a pretty darn strong cocktail which might not suit everyone, but it does allows you to serve it frozen-style to anyone who requests it without alteration. For the Manhattan, have you tried the Carpano Antica Formula vermouth? It gets a lot of

https://www.reddit.com/r/excel/comments/ydsyff/excel_questions_for_an_interviewee/
20+ years excel user. Every excel user considers themselves really good, I think I am, but I have never used powerquery. Don't ask more than one question about a function, ask them how to solve a problem. It's not a quiz, it's to find out how they use excel to solve problems in a useful manner. 6.

https://interviewprep.org/microsoft-excel-interview-questions/
3. Power Query: It's a powerful tool for data consolidation. You load all your files into Power Query Editor, append them together, perform necessary transformations and load back to Excel. 4. VBA Macros: If the task is repetitive, writing a VBA script could be beneficial.

https://www.cocktailgroove.com/books/a-home-bartenders-guide-to-delicious-mixed-drinks/spreadsheet
Download the spreadsheet. Get your copy of the accompanying spreadsheet for the book Cocktail Groove: A Home Bartender's Guide to Delicious Mixed Drinks and easily filter through the recipes based on your selected ingredients! Microsoft Excel required. Hit the 'Get Copy' button. Enter the passcode that you can find at the end of the book.

https://www.analyticsvidhya.com/blog/2024/01/comprehensive-guide-to-excel-interview-questions/
This article aims to provide a comprehensive guide to Excel interview questions, covering basic, average, and advanced levels. Whether you're a beginner or an expert, this guide will help you prepare for your next interview. Also Read: A Comprehensive Guide on Microsoft Excel for Data Analysis. Excel Interview Questions - Beginner's Level Q1.

https://www.reddit.com/r/excel/comments/11mbfat/using_excel_to_analyze_recipes_to_find_the_most/
Hi folks. I'm wanting to use Excel to analyze a list of cocktail recipes in order to build a list of ingredients.The idea is to find which combination of a number of spirits - say 25% of all unique spirits listed - will yield the most complete recipes.. I don't want to find the most often used ingredients because many recipes have an ounce or two of more random spirits and liqueurs (therefore

https://interviewideal.com/40-must-know-excel-interview-questions-and-answers-for-success/
9. Describe the process of creating and using pivot tables in Excel. Pivot tables summarize and analyze data. To create one, select data, go to 'Insert,' and choose 'PivotTable.'. Use the PivotTable Field List to arrange data. 10. Explain the concept of data validation and how it is implemented in Excel.

https://www.reddit.com/r/excel/comments/fo8fzt/drop_down_list_for_different_cocktails_recipes/
Anyway, here's the thing. I'm working on a cocktail cost calculator spreadsheet: https://prnt.sc/rm0kh3. Every spirit, garnish etc already has a drop down list from a "beverage price list" worksheet. I'd love to make a drop down list where "name of the cocktail" is as well, to calculate the drink cost for different cocktails.