Excel basic - easy!
What you'll learn
- People interested in learning Excel from scratch
- People who learned excel in a practical way but want to learn fully
- DATA MANAGEMENT, MANAGEMENT OF IMAGES AND GRAPHICS
- PREPARATION OF PAGES FOR PRINTING AND PRESENTATION.
Requirements
- The course is from scratch
Description
Course Definition:
This is an introductory course in the Microsoft Office Excel program.
The functionality of electronic sheets is explained step by step.
#AulaGEO
What will the user learn?
Unit 1: BASIC CONCEPTS
Conceptualization of the basic terms to start the course.
Episode 2:
We started with the creation of a book, how to save and retrieve it, strengthening the knowledge of file management.
Chapter 3
We will describe the different tabs and what they consist of, as well as the handling and configuration of the ribbon.
PRACTICE 1
Unit 2: DATA MANAGEMENT
Start working with Excel by entering Information into the spreadsheet and describing each of the menu functions within the program tabs.
Chapter 4
Description of the file tab or menu.
Chapter 5: Tab or menu "start"
From this point on, we will describe the contents of the "start" tab and each of the groups of tools.
"Clipboard" tool group:
Chapter 6
Tool group "Source":
Chapter 7
Aligment tool group:
PRACTICE 2
Chapter 8
Explanation of how we can pre-configure cells to receive numerical information in pre-established formats according to user needs.
Chapter 8 part 1: “Number” tool group:
Chapter 8 part 2: “Number” tool group:
Chapter 9
Here we will see how to insert rows, columns and sheets as well as how to format each of these.
Cells tool group:
Chapter 10
In this chapter we will know the handling of functions such as sum, average, high value, low and how we can elaborate series of numbers of numerical or chronological type.
Chapter 10 part 1: “Editing” tool group
Chapter 10 part 2: “Editing” tool group
PRACTICE 3
Unit 3: MANAGEMENT OF IMAGES AND GRAPHICS
The commands of the “insert” tab and the commands of tool groups will be explained, likewise, an explanation of the handling of the different types of graphics that the program has, as well as how they can be customized according to the options provided by the software.
Chapter 11:
Chapter 11 Part 1: “Table” and “Illustrations” Toolkit
Chapter 11 Part 2: “Graphics” and “Mini Graphics” Toolkit
Unit 4: PREPARATION OF PAGES FOR PRINTING AND PRESENTATION.
Chapter 12
We will see in this chapter everything related to preparing the files for printing and personalizing the presentation of the spreadsheets in the "page layout" tab.
Chapter 12 part 1 “themes” and “configure page” toolkit
Chapter 12 part 2 “configure page” toolkit
PRACTICE 4
Chapter 13
In this chapter we will see the spelling check with the office applications and how to insert comments in the “Check” and “View” tool group:
FINAL PROJECT
Who this course is for:
- All public
Instructor
Welcome to our Academy platform, your ultimate destination for online courses covering a wide range of subjects, including GIS, CAD, BIM and Digital Twins applied to the land development environment. We are committed to providing comprehensive education and empowering individuals to excel in various domains related to infrastructures. Whether you are a student, a professional seeking to expand your knowledge, or an enthusiast passionate about these subjects, our platform offers a diverse selection of courses tailored to meet your specific needs.
At our Academy, we recognize the significance of these disciplines in the infrastructures life cycle, from initial design to project completion. To ensure the highest quality of education, we have collaborated with renowned industry expert Golgi Alvarez and assembled a team of AulaGEO Academy experts to create, adapt to English and/or Spanish languages and curate cutting-edge courses.
Architecture – Engineering – Construction – Operation (AECO) is a harmonious blend of creativity and technical expertise. Our AECO courses encompass a broad range of topics, from Civil design principles to sustainable construction practices. You will gain proficiency in conceptualizing and developing designs that fulfill aesthetic, functional, structural and regulatory requirements. Our instructors, including renowned expert Golgi Alvarez, will guide you through the design process, helping you refine your visualization and communication skills. Furthermore, you will acquire a solid foundation in structural analysis and design, ensuring the safety and stability of your land development creations.
Geographic Information Systems (GIS) have revolutionized the way we collect, analyze, and visualize spatial data. Our GIS courses explore the power of GIS technology for mapping, spatial analysis, and data management. Using software like ArcGIS Pro and QGIS you will gain insights into interpreting and manipulating geospatial data, designing interactive maps, conducting spatial queries, and leveraging GIS for various applications, including land management, environmental analysis, and urban planning. Our GIS courses provide a competitive advantage in fields that rely on spatial data analysis and informed decision-making.
Civil Engineering plays a pivotal role in the design and construction of infrastructure. Our engineering courses cover a broad spectrum of topics, including structural engineering, transportation systems, and urban design. Using software like AutoDesk Civil3D and Bentley OpenRoads you will learn the principles and techniques required to design, construct, and maintain buildings, bridges, roads, and more. Our experienced instructors bring their industry expertise to the virtual classroom, providing valuable insights
Computer-Aided Design (CAD) is the backbone of modern design processes, enabling precise and efficient creation of 2D and 3D models. Our CAD courses cover a wide array of software applications, including AutoCAD, Microstation, and CREO Parametric. From fundamental concepts to advanced techniques, you will acquire the skills necessary to create, modify, and analyze complex designs, ensuring accuracy and optimizing workflows. Our courses cater to beginners seeking a solid foundation as well as experienced professionals aiming to enhance their expertise.
Building Information Modeling (BIM) has transformed the architecture, engineering, and construction industries by facilitating collaborative and data-driven project management. Our BIM courses delve into the principles, workflows, and software tools utilized in BIM, such as Revit and SYNCHRO. You will learn to create intelligent 3D models that encompass architectural, structural, and MEP (mechanical, electrical, and plumbing) systems. Additionally, you will discover techniques for accurate quantity extraction, clash detection, and generating construction documents. Mastery of BIM equips you to contribute effectively to multidisciplinary project teams and streamline project delivery.
ARTS & DEVELOPMENT
Additionally, as part of our social responsibility, some of our courses have been made available to development projects in certain countries. This has allowed us to benefit communities and replicate our methodology, leading to the creation of new courses in response to demand in areas such as graphic design, art, and social disciplines.
Copyright:
For copyright management and DMCA purposes, all the content of AulaGEO Academy is managed by Golgi Alvarez.