Udemy - Microsoft Excel - Complete Course

Udemy - Microsoft Excel - Complete Course - AulaGEO

Language: English (US)

Learn Excel from basic to advanced macros

https://www.udemy.com/course/microsoft-excel-complete-course-aulageo/

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 1

In 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 2

We 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 3

With 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 Earth

Master 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