У нас вы можете посмотреть бесплатно MS Excel Toronto Meetup - Excel Quick Tips – Not a formula in sight! - Lee Becker или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
The MS Excel Toronto Meetup group was founded in May 2019 and has had monthly sessions since then. Sessions are currently offered for free online, with a different topic presented by an Excel Expert each month. Members are from all over the world, totaling more than 4,000. ATTEND THE MS EXCEL TORONTO MEETUP GROUP SESSIONS LIVE 👇 Register for free as a member of the group: https://www.meetup.com/MSExcelToronto Thank you to Sheetcast for sponsoring the MS Excel Toronto. Sheetcast allows you to build web applications with Excel. Small teams can use it for FREE. https://sheetcast.com ACCESS THE EXERCISE FILES shared by the presenter available to the group members in the discussions area on Meetup. The MS Excel Toronto Meetup group sessions are organized and run by Celia Alves - / celiajordaoalves Gráinne Dugan - / grainneduggan1 Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscrib... Learn how to automate your Excel reports – FREE Masterclass here: https://snapreportschamp.com/course About this session: Session Title: Excel Quick Tips – Not a formula in sight! | Lee Becker Session recorded live on January 15, 2025 SESSION DETAILS There are multiple ways of improving your Excel productivity, even if you do not need to write or master Excel formulas. Lee Becker will share the Excel tips she has been collecting over the years and has personally found useful. She has chosen to leave out formulas in this session to make it accessible to the widest range of users. These tips are simple ways to increase productivity, even for people who have been using Excel for a long time. ABOUT THE SPEAKER Lee Becker loves working with data, using Excel and solving a puzzle. She hates waste and loves efficiency. A lot of what she has learned has stemmed from helping friends and colleagues with their Excel problems and coming up with practical, user-friendly solutions. Lee has a background in computer science and business administration and has worked in data analysis roles for over a decade. Find more about Lee's work and connect with her: LinkedIn: / lee-becker-lovedata Timestamps: 00:00:00 - Celia Alves MS Excel Toronto news and upcoming events 00:12:30 - Celia Introduces Lee Becker 00:13:45 - Lee Becker introduces herself and her presentation 00:15:05 - Importance of reducing waste and efficiency and increasing automation in Excel 00:16:10 - CONTROL button to select multiple numbers; copy SUM of selected values to the clipboard 00:18:20 – Reordering/moving columns using the SHIFT; freeze panes feature; fill a formula down shortcut, Use CONTROL + Arrow keys to move around the data 00:24:35 - Excel shortcuts, including copying values (CONTROL + D) and today's date (CONTROL + ; ); select from a list of previously entered data (ALT + Down arrow); Clipboard history (WIN + V) 00:28:55 - Emojis (WIN key + period or full stop key), using Emojis in formula and in tab names; Data validation; filter data; Conditional format to find duplicate values; filter by cell colour 00:34:00 - Transpose data, discussion about emojis in tab names and formulas 00:40:30 - Filter by partial text value; multiple value filters; Activate popup window to move around workbook 00:43:00 - Discussion and Questions 00:59:45 - Wrap up