Advanced Excel (Various Levels) - The Principles of Data Analysis - Santiago de Cali

Translated by GoogleSee original

Advanced Excel (Various Levels) - The Principles of Data Analysis

From 11.46 £ /h

Excel has become a powerful application over time, a cornerstone for understanding data analysis objectives, the power of its functions, and data models based on features such as Power Pivot, Graph, and Query. This provides a starting point for potential uses in other applications such as Power BI and paradigms such as Big Data, Data Science, and Artificial Intelligence, among others.

This course is advanced, but that doesn't mean that those without experience can't take it; on the contrary, they'll see a facet of learning that I consider unique and flexible.

This course isn't as difficult as a programming course would be, and although this programming discipline makes things easier for mass learning, I'm sure you'll learn a lot in Excel.

Extra information

It is essential that you have a computer and internet connection at hand, I will provide you with textual materials such as manuals written by me.

The content consists of the following topics
Advanced Excel (for all levels) - Data tables and modeling
Learn with advanced pivot tables and charts for data presentation.
Data analysis and management (objectives, scenarios, tables)
Migration to Power BI and data analysis and management with Power Pivot, Power Graph, and Power Query in Excel.
. Data protection

Among other topics

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Santiago de Cali, Colombia

At teacher's location :

Carrera & Calle, El Jardin, Cali, Valle del Cauca, Colombia

Online from Colombia

About Me

Docente en Análisis y Diseño de Software; Desarrollo de soluciones Web; con capacidad de Analizar, controlar, planificar y crear soluciones a pequeñas, medianas y grandes empresas. Comprometido en la gestión de Administración, Soporte, operatividad y resolución de problemas mediante síntesis y deducción. Con capacidad de Liderazgo y trabajo en equipo, fácil manejo de expresión oral y excelentes relaciones interpersonales, creación, investigación y orientación.

Education

Tecnologo Sena en analisis y diseño de sistemas de informacion Cuento con una gran capacidad de aprendizaje, motivación y flexibilidad y actualmente estoy en busca de oportunidades laborales que me aporten a mi desarrollo profesional. Además, tengo disponibilidad inmediata y movilidad geográfica.

Experience / Qualifications

mas de 20 años en la enseñanza, ademas he participado en diseño de aplicaciones escritorio mobiles y web
Organizar y crear espíritu de investigación a partir de una excelente administración y planificación estratégica e impartir conocimientos que se ajusten a las tendencias actuales; aspectos que permiten crecer en planos profesionales personales y familiares.

Age

Children (7-12 years old)

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

60 minutes

90 minutes

120 minutes

The class is taught in

Spanish

English

Skills

Math

Computer science

Statistics

Availability of a typical week

(GMT -05:00)

New York

At teacher's location and via webcam

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Illustrator for illustrators of all levels

8.91 £ /h

Illustrator is a great application that meets today's advertising needs. The focus of this course is carefully crafted, moving away from traditional teaching approaches in this discipline. It is essential to establish a knowledge link between color modes, the products that can be created with this application, integration with other applications, and different formats, such as the use of Excel spreadsheets to create interactive, mass-produced brochures with detailed information connected with markers.

Regarding integration, we will use two sister applications of Illustrator: Photoshop and InDesign for the creation of magazines.

It will be a great experience, below is the thematic content

ILLUSTRATOR THEMATIC CONTENT
- Introduction

 Introduction to vector drawing.

 Differences between a vector image and a bitmap image.
 Concept of vector drawing with ILLUSTRATOR (Characteristics of a vector)
 ILLUSTRATOR Vs ADOBE PHOTOSHOP
 Professional-level tool utilities.
 New features compared to the previous version

 The work environment

 The document window and workspaces
 Tool palettes, panels, and control panels
 Configure the workspace
 Document configuration and adjustment.
 Document navigation.
 Rulers and grids.
 Using guides and smart guides
 Color modes (CMYK color management).
 Image formats.
 Working with PostScript.
 Keyboard customization

- Creating files, the layers panel, and setting up the workspace

 Configure the new file for different modes
 Data to take into account about pixels in the new document
 Pixel grid alignment
 Generate custom document template
 Prepare files for large outdoor advertising

 Design compositions using layers and sublayers

 Layer options.
 Hierarchical layer structure.
 Locking/unlocking elements.
 Selections with layers.
 Layer colors.
 Nested layers.
 Moving objects in layers

- Storage formats, PDF files, export formats
- Operations on Images

 Rasterization concept and rasterization effects settings
 Coupling transparencies
 Selecting unaligned objects in ILLUSTRATOR
 Graphic styles applied to vectors
 Bitmap-based opacity masks
 Pixelated effects on vectors
 Place vs. Open photos (Linked vs. Embedded objects)
 Preview pixels and contour
 Preview of color separations and transparencies coupling

 Quality output for bitmap elements

 Printing bitmap documents
 Print Presets
 Segmentation of large documents
 Boundary marks crop marks
 Overprinting strokes and fills

- Work tools

 Navigation tools

 Hand
 Impression segmentation
 Zoom

 Copy and paste options; duplicating objects

 Selection tools.

 Configure selection and keyboard preferences
 Normal, direct selection and group selection
 Selection of objects in front, middle and back

 Typical selection tools

 Magic wand
 Lasso selection

 Selection by attributes
 Group and ungroup
 Isolation modes
 Resize images and angles
 Transformation Tools / Repeat Transformations
 Reflection and distortion
 Alignment and distribution of objects
 Editing paths and Bézier curves.

 Pen
 Add anchor point
 Delete anchor point
 Anchor point
 Curvature

 Editing and modifying paths

 Join and average paths
 Simplify
 Attributes of a stroke
 Rows and columns
 Compound paths
 Clipping mask
 Outline and move paths
 Draft
 Scissors
 Blade

 The brush and pencil tools, shaper, and adjustments

 Shaper
 Pencil
 Soften
 Stroke eraser

 Brushes and Creation

 Shading effects
 Pattern brush
 Ink strokes
 Special brushes
 Shading pen

 Working with symbols

 Symbol sprinkler
 Move symbol
 Gather and separate symbol
 Change symbol size
 Rotate symbol
 Stain symbol
 Translucent symbols
 Apply styles to symbols

 Color tools

 Fill and stroke.
 The color palette.
 The samples palette.
 Custom color libraries.
 Paint bucket and eyedropper tool.
 Color modification filters.
 Reasons.
 Degraded
 Interactive paint can
 Interactive painting selection

 Drawing geometric figures

 Drawing vector objects and properties

 Main geometric objects in ILLUSTRATOR

 Rectangle
 Ellipse
 Polygon
 Star
 Flash
 Arch
 Spiral
 Rectangular grid
 Polar grid
 Interactive vertices
 Shape Builder Tool

 Sector and perspective tools

 Sector
 Select sector
 Perspective grid
 Perspective selection

 Working with text

 Draw text with color and outline; font style
 Creating text boxes.
 Create text outline
 Custom text paths.
 The text editor.
 Flow text.
 Mask text.
 Use of text and brushes.
 Flattened text.
 Text
 Area text
 Text in path
 Vertical text
 Vertical area text
 Vertical text on path
 Retouch text

 Modification Tools.

 Rotate
 Reflect
 Climb
 Distort
 Reform
 Width
 Deform
 Windlass
 Pucker
 Gain weight
 Scallop
 Crystallize
 Wrinkle
 Free transformation
 Merger

- Effects and Expand

 Expand and Expand Appearance

 From ILLUSTRATOR

 3d
 Path effects (Pathfinder)
 Form conversion
 Stylization
 Applying filters
 Clipping mask

 From Photoshop

- Mesh management, merges and gradients

 Handling rounded meshes.
 Advanced mesh management.
 Mergers.
 Working with mergers: expand, invert, and drop.
 Gradients and gradient meshes.
 Merger examiner.
 Shadows of mergers.
 Unified gradients.

- Transparency and Appearance

 Handling transparencies.
 Opacity masks and coverage controls.
 The Appearance palette.
 Transparent colors.
 Basic flashes.
 Opacity masks.

- Review of pre-print features

 What should be done to design very large advertising works?
 Prepare folder for sending to the contracted printer
 Export as PDF.

Database modeling and analysis with Power BI

14.1 £ /h

The Power BI course begins with a study of data modeling, using Access as a basic reference. Once this is understood, we'll work in Excel to import data sources, generate tables, and develop properties using essential Power Query. We'll also cover the use of Power Pivot. This will help you migrate to Power BI and explain the importance of data modeling to achieve professional-level results.

Once the migration is complete, it is easier to create reports using visualizations (Dash Board) and fundamentally the use of DAX and the R language.

Michael

Are you passionate about understanding how the world works? This course is designed for elementary and college students who want to learn science in a fun and practical way. We'll explore topics of interest based on the student's needs. In addition, we provide reinforcements for exams, quizzes, midterms, and more.

Also, support is given in work, projects and tasks.

Michael

Good-fit Instructor Guarantee

Contact Julian