[go: up one dir, main page]
Scribd
Upload
12 views2 pages

Basic Intermediate and Advanced Excel

This document describes the content of a diploma course in basic, intermediate, and advanced Excel. The basic Excel course covers concepts such as creating and saving files, cell formatting, creating tables and charts. The intermediate level includes topics such as filters, data merging, conditional formatting, and validation. The advanced level focuses on complex functions, series, custom lists, spreadsheet automation, and databases.

Uploaded by

ScribdTranslations
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views2 pages

Basic Intermediate and Advanced Excel

This document describes the content of a diploma course in basic, intermediate, and advanced Excel. The basic Excel course covers concepts such as creating and saving files, cell formatting, creating tables and charts. The intermediate level includes topics such as filters, data merging, conditional formatting, and validation. The advanced level focuses on complex functions, series, custom lists, spreadsheet automation, and databases.

Uploaded by

ScribdTranslations
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

DIPLOMA

BASIC, INTERMEDIATE AND ADVANCED EXCEL


DETAILED CONTENT

BASIC EXCEL oBordes


Fillings
Introduction The format of numerical values
Generalities of the Spreadsheet The topics
the initial screen Create Tables
Bars and buttons of Microsoft ExcelCreate a table
The title bar Table style
the ribbon Filter the content of the table
the formula bar Creation of formulas and use of functions
the label bar to perform calculations
The scroll bars to introduce functions
the status bar AutoSum and most common functions
Hello, help Insert function
Working with files: Create, Save and
Create Graphs and Sparklines
Open a file Create common charts
to create The Minigraphs
Save a workbook Open a workbook Page Design
existing work Page Design View
Manipulating cells Immobilize Panels
Cell Selection Configure page
Copy cells using the mouse Print.
Special Tp
Move cells using the Clipboard
Cell Format
Source
Alignment
INTERMEDIATE EXCEL or How to work with other programs
Microsoft Office? Combine
Workbook configuration Correspondence
Changes in the appearance of the document Add buttons to the toolbar
How to perform calculations to Add symbols
The use of filters to search for data To Get Formulas from Various Categories
specific (logical, mathematical, statistical,
Combination of data from various text, etc.
origins or Use mathematical operators and
Reorganization and summary of data comparison operators
or Add Format Relative and Absolute References
To Add Superscripts and Subscripts to insert name into cell
Creation and editing of graphics Conditional formatting
Sheet Format and Printing Cell validation
How to work with other programs or Insert comments
Microsoft Office? Combine The formula audit
Correspondence To mobilize and immobilize panels
to add buttons to the bar Hyperlinks
tools To protect cells, sheets, and documents.
to Add symbols
to Get Formulas from various categories ADVANCED EXCEL
(logical, mathematical, statistical,
text, etc) Complex functions
or use mathematical operators and To use nested functions
comparison operators Creation of series
Relative and Absolute References Creation of custom lists
or Insert name into cell The handling of txt files
Conditional formatting the use of the programmer's card to create
Cell validation controls
to insert comments Design of automated spreadsheets
The Audit of Formulas Advanced Excel Functions
to mobilize and immobilize panels Filters and Subtotals
Hyperlinks Scenario Management
To protect cells, sheets, and documents. The Handling of the Search Tool
or Combination of data from various objective
origins Database
Rearrangement and summary of data to insert and search for information with
or Add Format forms
To Add Superscripts and Subscripts Payment Function and Amortization Table
Creation and editing of graphics Dynamic Tables
Sheet Format and Printing Dynamic Graphics

You might also like