CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE FREE BASIC EXCEL MINI COURSE: https://excelparaestagio.klickpages.c... BASIC EXCEL HANDBOOK [FREE DOWNLOAD]: https://www.hashtagtreinamentos.com/h... ----------------------------------------------------------------------- ► To Download the File Used in the Class, Access: https://pages.hashtagtreinamentos.com... ► To watch the 2nd class: • Excel 2023 Course - Class 2 [Format... ► Click to access the Support Class for Class 1 (Nested IF Function): • Excel Course - Support Class for Class... ----------------------------------------------------------------------- Recommended Videos: ► The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • The 5 BASIC Excel FORMULAS that you MUST LEARN b... ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without c... ► Pivot Table - How to make an Excel Pivot Table in 5 steps! • Pivot Table - How to make an Excel Pivot Table... ► EXCEL SPREADSHEET to IMPRESS ANYONE • EXCEL SPREADSHEET to IMPRESS ANYONE... ► Learn EVERYTHING about how to create GRAPHICS in EXCEL • Learn EVERYTHING about how to create GRAPHICS... ----------------------------------------------------------------------- Hey Impressives! Today we are going to start an Excel 2023 Course for you to start the year impressing in Excel. There will be 4 classes where we will teach you a lot of things, including how to create a dashboard from scratch so that you can present your results professionally! In this first class, I will talk about the VLOOKUP function (Excel VLOOKUP formula), the IF function, some Excel tools, and Excel shortcuts to help you become more productive. This is a very important class, as we will cover topics that are widely used in Excel, which some intermediate and advanced level users may not master. So, it is important that you master these resources, as they are widely used in the job market. So, are we going to start 2023 impressing with Excel and winning lots of compliments? ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► Blog: https://bit.ly/2MRUZs0 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ► Tik Tok: https://bit.ly/3dUpwkW To receive daily Microsoft Excel, VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos we teach several Excel tips and Excel tricks so that you can develop in this tool! ----------------------------------------------------------------------- Class Content 00:00:00 Start of Class in Excel (Lesson 1 File) 00:02:45 Text to Columns Tool (to adjust the CSV) 00:08:02 Adjusting the column width 00:11:50 Currency Format in Excel 00:25:31 Record Formatting (Custom Formatting for CPF, CNPJ, Telephone, Zip Code...) 00:32:37 Flash Fill in Excel (Very important tool) 00:56:52 Geography Tool in Excel - Data Types (Office 365) 01:01:27 Analysis 1 - COUNTIFS Function 01:23:08 Data Validation 01:24:12 Analysis 2 - VLOOKUP (Example 1) 01:53:05 Analysis 3 - VLOOKUP (Example 2) 01:55:15 Analysis 4 - IF Function 02:04:48 Analysis 5 - Nested IF Function (Compound IF Function) #excel #hashtagtrainings