Lecture

Excel Upgrade: Advanced Functions and Data Analysis

Description

This lecture covers advanced Excel functions and data analysis techniques, including automatic recording, inserting functions, formatting cells, using formulas, creating custom formats, managing names, protecting data, and using Solver for data analysis. The lecture also includes practical exercises on creating pivot tables, applying conditional formatting, and using Power Query to obtain and manipulate data.

Official source

https://mediaspace.epfl.ch/media/0_p52hqlzx

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Ontological neighbourhood

Computer engineering

Software development: Human–computer interaction, Entities in software development

Mathematics

Discrete mathematics: Graph theory

Economics

Microeconomics: Economic systems

Related lectures (217)

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.