Discounted courses from just $13.99 USD and save an extra 20% with code RELAMPAGO20SEP | Ends today at 11:59 PM!
LIGHTNING20SEP

Microsoft Excel basic to advanced and Power BI

Become an expert data analyst and unlock the full potential of your data. This master's degree will take you from the fundamentals of Excel to the latest developments in Power BI, allowing you to create high-quality interactive reports and dashboards.

By Miguel Angel Franco Garcia | Business Intelligence Analyst

👥 1.128
(10)
$12.99 USD $40.99 USD

15 day refund guarantee

This course includes:

▪️ 3h 52m duration on demand

▪️ 67 lessons

▪️ 82 downloadable resources

▪️ Available on mobile devices

▪️ Access forever

▪️ Language:

  • Spanish

▪️ Unlimited consultations

Supplementary materials

⚑ Certificate of completion

What you will learn

🟧 You will learn Excel from scratch, and end up becoming an expert data analyst.

🟧 You will learn tools such as conditional formatting in depth, and you will know how to use relative, absolute, and mixed references.

🟧 You will learn a lot of functions, all of them very important for everyday life.

🟧 You will see text functions, time functions, statistics, financial functions, lookup and reference functions, logical functions, and many more.

🟧 You will learn everything about pivot tables and target estimation functions.

🟧 You will learn about Power Query, Power Pivot, Power View, Power Map, and Power BI.

🟧 You will learn the 100 Excel productivity tricks.

🟧 You will create a professional dashboard from scratch, step by step.

🟧 You will apply new functions such as CONCAT, CLEAN, IFSET, SWITCH, CONCATENATE.

🟧 You will learn the new way of formulating with dynamic matrices, functions such as ORDERBY, SEQUENCE, FILTER.

🟧 You will learn with examples how to use functions in the normal way, and the same functions to generate dynamic matrices.

🟧 You will create dynamic graphs with spilled matrices.

🟧 You will learn how to create native Excel and custom charts and sparklines.

🟧 You will create your own calendars for your projects in Excel, or in a user form.

🟧 You will learn the latest in dynamic arrays, as well as array formulas and functions.

🟧 You will learn about the new LET, AND, LAMBDA functions.

Course content
U1: First contact with Excel
  • The top bar
  • The Ribbon
  • The spreadsheet
  • Leaf management
  • Save book
  • Save as / Save a copy
  • Autosave (Excel 365 only)
  • Save Options
U2: Data entry and editing
  • Data entry
  • Editing and deleting data
  • Data entry by reference
  • Undo and redo
U3: Handling Rows, Columns and Cells
  • Insert and delete rows and columns
  • Adjust row and column dimensions
  • Hide and show rows and columns
  • Line break in a cell
  • Naming ranges and cells
U4: Formats
  • Basic cell formats
  • Data alignment
  • Text format
  • Copy format
U5: Cell Fill and Paste Options
  • Cell Paste Options
  • Autofill cells
U6: Formulas and Functions
  • Region settings
  • Formula vs Function
  • Arithmetic operators
  • Comparison operators
  • Ampersand operator (&)
  • Reference operators
  • Order of priority
  • Relative, absolute and mixed references
  • Syntax of a function
  • Important note about functions
  • Automatic functions
  • Wizard and Function Library
  • Common mistakes
  • AVERAGE and AVERAGEA functions
  • COUNT and COUNTA functions
  • COUNTIF and COUNTIFS functions
  • SUM Function
  • SUMIF and SUMIF functions
  • RANDOM and RANDBETWEEN functions
  • ROUND function
  • IF function
  • Nested Sl function
  • IF Function
  • And and Or Functions
  • IFERROR Function
  • VLOOKUP function with arg. False
  • VLOOKUP function with arg. True
U7: Printing and other functionalities
  • Print preview
  • Print Settings
  • Repeat headers for each sheet
  • Header and footer
  • Document Printing 1
U8: Pivot tables
  • What is a pivot table?
  • How to structure information?
  • My first pivot table
  • Recommended pivot tables
  • The field list panel
  • Review of the data source table
  • Adding and removing fields
  • The area of ​​values
  • The areas of rows and columns
  • The filter area
  • Field hierarchy
  • Create field groupings
Course evaluation
  • This course contains a final exam
G-Tools: For Students
  • Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.
⚑ Certificate of completion
  • Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.
__
Downloadable resources:

📎 Downloadable Guide Set:

▸ More than 120 sets of materials for practice

Description

✔️ This course will start with the basic module, where we will learn the basic concepts, such as what a row, a column, a cell and a range are. We will create a linked image from a data model.

We will learn the main and perhaps the most useful keyboard shortcuts, such as CTRL and =, which is the auto-sum shortcut.

We will use the format copyer tool on the home tab, both to copy to adjacent cells, as well as cells that are not contiguous.

We will see how to view, for example, two Excel sheets on the same screen through the view tab.

We will freeze panels. We will also learn how to use relative, absolute and mixed references perfectly with practical examples.

We will see how to use the autosum command, custom formatting, flash fill, and everything about conditional formatting, and conditional formatting with formulas, for example, to tell us what the largest amount is within a data model.

We will learn how to make our first graphs, and what their parts are, such as the use of the secondary axis.

We will also set up a sheet to be printed, for example, making the title print on all sheets, how to put a header and a footer and adjust the sheet, we will also see the page breaks.

Of course, we will see what a table is, and what difference it has with respect to a range. We will sort by more than one criterion, we will see the search and replace command.

We will see in this basic module what the weighted average is, and how it is calculated manually with the SUMPRODUCT function.

Companies from all industries invest in the development of their teams with this course from G-Talent and Miguel Angel Franco Garcia

Customer Reviews

Based on 10 reviews
40%
(4)
60%
(6)
0%
(0)
0%
(0)
0%
(0)
S
Sofía García
Muy Buen curso

Muy bien estructurado y excelente explicación.Me gustó el curso

D
David Hernández
Fue un curso para mucho crecimiento personal

Como principiante, me sentía un poco abrumado por Excel, pero gracias a la metodología clara y los ejemplos prácticos del profesor, logré dominar las funciones básicas y crear mis primeras hojas de cálculo.

L
Lucas de la Cruz
Lo mejor son los Ejercicios

La metodología del curso es muy práctica y enfocada en resultados.

Ver más reseñas

Miguel Angel Franco Garcia

Business Intelligence Analyst

About Miguel Angel Franco Garcia

Business Intelligence Analyst

Jairo Vera
Certified by Microsoft as a Microsoft Excel Expert, specialist in data analysis and visualization.

He is a professional with a solid background in business administration and a postgraduate degree in business intelligence. Currently, Jairo works as a business intelligence analyst and has more than 7 years of experience in collaboration with multinational companies such as Nestlé, JTI and Abbott.

Jairo has developed an outstanding career, earning a certification as a Microsoft Excel Expert, which has allowed him to hone his skills in the advanced use of data analysis tools. His experience includes creating efficient solutions, avoiding unnecessary processes, and optimizing the workflow to facilitate the understanding and application of data by end users.

In addition to his expertise in business intelligence, Jairo is passionate about creating efficient and simple solutions, allowing him to offer a unique perspective in data analysis and visualization.

What makes Jairo different?

▪️ Microsoft Excel Expert Certification: Jairo's Microsoft Excel certification accredits him as an expert in the advanced use of this tool for data analysis.

▪️ Experience in collaboration with multinationals: His experience working with large companies has allowed him to understand corporate needs and apply practical and effective solutions.

▪️ Focus on simplicity and efficiency: Jairo specializes in developing solutions that eliminate tedious processes, making data analytics more accessible to end users.

If you are looking to learn how to manage data efficiently and create impressive visualizations, Jairo Vera's courses are the ideal choice.

Discover the added value: G-Tools and much more

In addition to high-quality content, this course gives you access to G-Tools, a suite of tools and resources designed to enhance your learning and your career.

Employability support resources, live events and take advantage of Aixa.IA's artificial intelligence to resolve your questions at any time.

View all

Explore other courses from Miguel Angel Franco Garcia

Discover other courses and learn something new today. Learn from the best!

Best Selling Courses in Personal Development

What to expect from G-Talent courses?

  • Study at your own pace

    Get video courses, taught by top instructors, to study at your own pace

  • Learn from the best

    Provides high quality courses developed by carefully selected experts

  • Quality guaranteed

    Not sure? All our courses offer a 15-day success guarantee

  • Permanent accompaniment

    Learn at your own pace, with lifelong updates, access and support.

  • Personalized certificate

    Get a world-class certificate, with international validity and a unique encrypted QR code

  • G-Tools: For Students

    Find all the tools you need for your employability in one place.