avaxgfx Posted April 3 Report Share Posted April 3 [img]/storage-10/0424/HGxyzLtxl8xoFp4OC9A4eiAwhQewU8mT.jpg[/img] Published 4/2024 MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz Language: English | Size: 7.28 GB | Duration: 9h 46m Learn Excel from basic to advanced macros [b]What you'll learn[/b] Learn Excel from scratch Learn Excel practically and completely Learn Excel tips Practice everything learned in Excel [b]Requirements[/b] The course is from scratch [b]Description[/b] The world is changing, and so is the workplace. To stay current, we must constantly learn and progress. With Excel, you can track your projects, manage your budget, calculate how much money you need to retire comfortably, and even find out how much coffee is left in your office coffee machine.Excel is a powerful tool for companies, individuals, and professionals. But there are so many hidden tricks that most don't know about. Don't be left behind in the digital age!SECTION 1In this section you will learn to:· Basic terms· Create, Save, and Recover files· Menus, Tabs, and Ribbon· Information entry and data format· Alignment and adjustment of content in cells· Preconfiguration of cells and formats· Tools: alignment, numbers, cells, editing, tables, illustrations, graphs, mini charts, themes, set up pages, review, view, data management.· Practices.SECTION 2We continue with the intermediate level of the Excel course, in which you will learn:Explanation of concepts: Sheet, book, and cell, customizing ribbon, definition and how to name range, left, right, or opposite click handling, dialog box management, pointer options, definition of formulas and functions.Data Management and Analysis: forms, preconfigured and custom cell styles, custom cell formatting, data tools, data validation, drop-down lists, date, time, custom error message, text in columns, links, sheets, workbooks, hyperlinks.Table management: This chapter explains the creation, management, and configuration of tables, knowing the tools available and the options they offer for data analysis. Table tools, table style options, subtotals, and slicers.You will also learn: insert pivot tables, visualization forms, update pivot tables, data analysis, timeline.Managing graphics: in this chapter we will learn how to create, modify, design, and structure graphics in Excel, knowing the types it offers and the ways to customize it depending on the analysis required of the information in the workbook or spreadsheet. Chart creation, chart types, chart customization.Image management: here we will explain the creation, modification, and manipulation of images in Excel. Types of images, inserting images, modifying images, formats and styles, shapes, SmartArt.SECTION 3With the help of our #exceltips you can convert information and get your job done faster and easier. Excel is more than a tool for crunching numbers. It's a powerful engine for creating and managing data, and with the right tricks, you can make it work for you!In this section you will learn how to get more out of Excel, apply to tricks with AutoCAD, Google Earth, and Microstation, whether you are an experienced professional or a beginner, you will love these tips and tricks that have been compiled especially for you.Includes: Conversion of coordinates from geographic to projected in UTM, decimals to degrees, minutes, and seconds, and plane coordinates to headings and distances. Also send Excel data to Google Earth, AutoCAD, and Microstation, all using Excel formulas.Additionally, learn how to work with advanced Excel functions using:· Macros, Record Macros· Timeline Filters and Data Slicer· Create form· Forms from Visual Basic· Create lists using ComboBox· Decisions using IF Function, Else using CheckBox· Print form· Access credentials to enter your Excel sheet· UTM coordinates· Geographical coordinates· Google EarthMaster the potential of Excel with these easy-to-understand tutorials. From workbooks to macros and automation, you'll see how it's possible to do more with less effort. In addition, you will never have to worry again, since you will have all the downloadable templates and resources at your disposal to be used in your daily life. #AulaGEO [b]Overview[/b] Section 1: LEVEL I - EXCEL BASIC Lecture 1 Introduction Section 2: LEVEL I - BASIC CONCEPTS Lecture 2 Basic terms Lecture 3 Create, Save, and Recover files Lecture 4 Menus, Tabs, and Ribbon Section 3: LEVEL I - DATA MANAGEMENT Lecture 5 Information entry and data format Lecture 6 Alignment and adjustment of content in cells Lecture 7 Presetting of cells and formats Lecture 8 Alignment tool group Lecture 9 Practice 2 Lecture 10 "Number" tool group Lecture 11 "Number" tool group Lecture 12 Cells tool group Lecture 13 Toolkit "Editing" Lecture 14 Toolkit "Editing" Lecture 15 Practice 3 Section 4: LEVEL I - MANEJO DE IMAGENES Y GRAFICOS Lecture 16 "Table" and "Illustrations" tool group Lecture 17 "Graphics" and "Sparklines" tool group Section 5: LEVEL I - PAGE PREPARE FOR PRINTING Lecture 18 Toolbox "Themes" and "Configure page" Lecture 19 "Configure Page" Tool Group Lecture 20 Practice 4 Lecture 21 Tools "Review" ans "View" Lecture 22 Final practice Section 6: LEVEL I - EXTRA LESSON - FILTERS Lecture 23 Filter Management Section 7: LEVEL II - MICROSOFT EXCEL - INTERMEDIATE LEVEL Lecture 24 Introduction Lecture 25 Basic Concepts Lecture 26 Save As, Share, Protect Lecture 27 Practice 1 Section 8: LEVEL II - DATA MANAGEMENT AND ANALYSIS Lecture 28 Data Management, Cell Format, Search Data Lecture 29 Data Validation Lecture 30 Searches, Columns, Links, Hyperlinks Lecture 31 Sorting and Filters Lecture 32 Format Command Lecture 33 Scheme: Group, Ungroup and Subtotals Lecture 34 Practice 2 Section 9: LEVEL II - TABLE MANAGEMENT Lecture 35 Tables Lecture 36 Dynamic Tables Lecture 37 Practice 3 Section 10: LEVEL II - GRAPHICS MANAGEMENT Lecture 38 Create, Modify and Manage Graphics Section 11: LEVEL II - IMAGE AND FUNCTION MANAGEMENT Lecture 39 Tool: Images Lecture 40 Practice 4 Lecture 41 Management of Formulas and Functions Lecture 42 Practice 5 Section 12: LEVEL III - EXCEL MACROS Lecture 43 Tempo Scale Filters and Data Slicer Lecture 44 Macros Lecture 45 Form Command Lecture 46 Forms from Visual Basic Lecture 47 Create lists using ComboBox Lecture 48 Print Form Lecture 49 Access credentials to enter your excel sheet All public Screenshots https://fikper.com/CYsaN1HT6r/Microsoft_Excel_Complete_Course_AulaGEO.part1.rar.html https://fikper.com/dX2SrP72oR/Microsoft_Excel_Complete_Course_AulaGEO.part2.rar.html https://fikper.com/ZzKhStKXHc/Microsoft_Excel_Complete_Course_AulaGEO.part3.rar.html https://fikper.com/VTNSINUSG8/Microsoft_Excel_Complete_Course_AulaGEO.part4.rar.html https://fikper.com/Vj29NnkPnx/Microsoft_Excel_Complete_Course_AulaGEO.part5.rar.html https://fikper.com/89MUdCYghX/Microsoft_Excel_Complete_Course_AulaGEO.part6.rar.html https://fikper.com/K9KQvShXGT/Microsoft_Excel_Complete_Course_AulaGEO.part7.rar.html https://fikper.com/OObx9PQX6V/Microsoft_Excel_Complete_Course_AulaGEO.part8.rar.html [code] https://rapidgator.net/file/0b026cd9610096686fee00fb6ec27674/Microsoft_Excel_Complete_Course_AulaGEO.part1.rar.html https://rapidgator.net/file/83178a9d106156c7dbedf52d07839740/Microsoft_Excel_Complete_Course_AulaGEO.part2.rar.html https://rapidgator.net/file/1da78d588f45bb0c8f9b510947328a31/Microsoft_Excel_Complete_Course_AulaGEO.part3.rar.html https://rapidgator.net/file/98ba097f1bb1a28d1cfa47585b4798e2/Microsoft_Excel_Complete_Course_AulaGEO.part4.rar.html https://rapidgator.net/file/3583aec3bb3ac7561cb8d5773d589b87/Microsoft_Excel_Complete_Course_AulaGEO.part5.rar.html https://rapidgator.net/file/0a8e89347143d5774f75f0ed5e19f935/Microsoft_Excel_Complete_Course_AulaGEO.part6.rar.html https://rapidgator.net/file/456fe7f1f1b3b860e4e43f7628b211e9/Microsoft_Excel_Complete_Course_AulaGEO.part7.rar.html https://rapidgator.net/file/6e993fcd7811e7e5a27eb01eb0ed8b74/Microsoft_Excel_Complete_Course_AulaGEO.part8.rar.html[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now