Fabrizio Pironti

Fabrizio

Verified teacher, moderated by the Classgap team
Italy

0 lessons

Computer Programming, Computer Software

+ 10 years of exp. teaching online classes

About me Availability More info

About me

Introduction: Welcome to our Excel Course! This training program is designed to guide you step by step through the world of data analysis using the powerful spreadsheet tool Microsoft Excel. Whether you are an absolute beginner or already have some basic skills, this course will provide you with the knowledge and skills to become proficient in using Excel to analyze and manage data effectively. Chapter 1: Introduction to Excel and Basic Features We will start with the fundamentals, learning how to navigate Excel's interface and create worksheets. We will explore how to enter data, format cells, and use formulas to perform simple calculations. We will delve into the features of tables and charts to visualize data clearly and comprehensively. Chapter 2: Advanced Data Analysis with Functions and Tools In the second chapter, we will focus on advanced Excel functions. You will learn how to use lookup and reference functions, logical functions, and complex mathematical functions. We will also explore filtering and sorting options to analyze large datasets efficiently. Chapter 3: Scenario Analysis and Forecasting Tools Moving on to scenario analysis and Excel's forecasting functions, we will create data tables and use the "Scenarios" function to examine different possible outcomes based on key variables. We will also explore the "Goal Seek" and "Solver" analysis tools to achieve specific objectives. Chapter 4: Database Functions and Pivot Tables In the fourth chapter, we will discover Excel's database functions and how to use pivot tables to analyze and summarize extensive datasets. You will learn to create dynamic reports and pivot charts, allowing us to gain deep insights into the information within our datasets. Chapter 5: Automation with Macros and Visual Basic for Applications (VBA) We will conclude our course by exploring automation through macros and VBA. You will learn how to record, modify, and use macros to automate repetitive tasks. Additionally, we will introduce the fundamental concepts of VBA, Excel's programming language, to create customized and advanced functionalities. Conclusion: Upon completing this course, you will have gained the skills to become a true Excel expert and a professional data analyst. You will be able to use Excel to analyze data, create reports, and make informed data-driven decisions with confidence and precision. Our team of experienced trainers will always be available to provide support and assistance throughout your learning journey. We are confident that this course will open up new career opportunities for you and help you stand out in the world of data analysis. Don't wait any longer! Enroll in our Excel Course and get ready to transform your career by acquiring essential and highly sought-after skills in various industries. We are excited to accompany you on this journey to Excel in data analysis!

Availability

Choose a date and time to start booking your class.
Times are displayed in your local time zone.








Can't find the availability that suits your needs?

I teach

  • Computer Programming
    • SQL
    • VBA
    • Visual Basic
  • Computer Software
    • Excel

Languages I speak

ItalianNative
EnglishFull proficiency

Education

Matematica Applicata

Degree

Frequently Asked Questions

Other recommended online Computer Programming teachers:

5,0

(6)

$10 /lesson

Free trial available

Jose
https://dbwf8q1mv0cee.cloudfront.net/chi/api/user/dtp/ylfeo72s20j2vi5rux-bspi_qthczmfe0.jpg/124x124cut/?v=1

Jose
Verified teacher, moderated by the Classgap team
Spain

105 lessons

Computer Programming
C# Unity

¡Buenas! Soy Jose Lirón, licenciado en Traducción e Interpretación, con dos años de Estudios Hispánicos y un Técnico Superior en Animación, 3D y Entornos Interactivos. En los últimos años he adquirido bastantes conocimientos en el área de la programación de videojuegos, así que he pensado: ¿por qué no compartirlos? Y por eso estoy aquí. =) Te puedo enseñar desde los aspectos más básicos, como las variables, los bucles o los primeros pasos dentro de Unity, hasta temas más avanzados, como arquitectura de software, cuestiones de optimización y rendimiento o creación de herramientas personalizadas para el Editor, todo adaptado a tus intereses y tus objetivos. Por otro lado, mi enfoque a la hora de enseñar es fundamentalmente práctico, así que desde el primer momento vamos a hacer juegos. Si no has tocado nunca un lenguaje de programación o un motor gráfico, empezaremos con pequeños microjuegos que tengan una única mecánica simple, con el fin de que te vayas familiarizando. Y, si ya tienes algo más de experiencia, nos pondremos con cosas un poco más complejas, como puzles o plataformas 2D, aunque no haremos juegos enteros, sino fases sueltas para ir aprendiendo todo el tema del movimiento, las animaciones, las físicas, las colisiones u otras cuestiones más avanzadas (una vez subas de nivel). Y eso sería todo por mi parte. Si te interesa, no dudes en reservar o pedir una prueba gratuita. ¡Estaré encantado de atenderte! =)

5,0

(30)

$15 /lesson

Free trial available

Daniel A.
https://dbwf8q1mv0cee.cloudfront.net/chi/api/user/dtp/orri5jqh20gtbetfajtorjr5cijtglfz0.jpg/124x124cut/?v=1

Daniel A.
Verified teacher, moderated by the Classgap team
Colombia

492 lessons

Computer Programming
Javascript NodeJS Python Java TypeScript React

Learn programming from zero to expert. Book your free interview now! ⏤ Welcome to a transformative journey in software development, guided by a mentor whose enthusiasm for science and technology is complemented by solid p...

5,0

(5)

$21 /lesson

Free trial available

Guglielmo
https://dbwf8q1mv0cee.cloudfront.net/chi/api/user/dtp/_uji7xal3egpoojfu2s0tipfl3f9mher0.jpg/124x124cut/?v=4

Guglielmo
Verified teacher, moderated by the Classgap team
Italy

317 lessons

Computer Programming
SQL Python Java TypeScript Rust Go

Computer teacher working in the field since 2010 ⏤ Hello everyone! My name is Guglielmo, and I'm thrilled to have the opportunity to be your computer science teacher. I graduated in 2014 with a Bachelo...

5,0

(2)

$19 /lesson

Free trial available

Harut
https://dbwf8q1mv0cee.cloudfront.net/chi/api/user/dtp/yi9_a3mn3egdpt8qbytttlq9wu3bpuki0.jpg/124x124cut/?v=1

Harut
Verified teacher, moderated by the Classgap team
Armenia

36 lessons

Computer Programming
SQL Javascript NodeJS Python Web Development Java

I am a software engineer graduated from Polytechnic University of Valencia with 7 years of professional experience in web and mobile application devel...