plan de estudios avanzado de excel
01
Microsoft Excel Fundamentals
-
Launching Excel
-
Microsoft Excel Start-up Screen
-
Introduction to the Excel Interface
-
Customizing the Excel Quick Access Toolbar
-
More on the Excel Interface
-
Understanding the Structure of an Excel Worksheet
-
Saving an Excel Document
-
Opening an Existing Excel Document
-
Common Excel Shortcut Keys
-
Font formats, Alignment, Borders, etc
-
Basic conditional formatting
02
Entering and Editing Text and Formulas
-
Entering Text to Create Spreadsheet Titles
-
Working with Numeric Data in Excel
-
Entering Date Values in Excel
-
Working with Cell References
-
Creating Basic Formulas in Excel
-
Relative Versus Absolute Cell References in Formulas
-
Understanding the Order of Operation
03
Working with Basic Excel Functions
-
The structure of an Excel Function
-
Working with the SUM() Function
-
Working with the MIN() and MAX() Functions
-
Working with the AVERAGE() Function
-
Working with the COUNT() Function
-
Adjacent Cells Error in Excel Calculations
-
Using the AutoSum Command
-
Excel's AutoSum Shortcut Key
-
Using the AutoFill Command to Copy Formulas
04
Modifying an Excel Worksheet
-
Moving and Copying Data in an Excel Worksheet
-
Inserting and Deleting Rows and Columns
-
Changing the Width and Height of Cells
-
Hiding and Unhiding Excel Rows and Columns
-
Renaming an Excel Worksheet
-
Deleting an Excel Worksheet
-
Moving and Copying an Excel Worksheet
05
Formatting Data in an Excel Worksheet
-
Working with Font Formatting Commands
-
Changing the Background Colour of a Cell
-
Adding Borders to Cells
-
Formatting Data as Currency Values
-
Formatting Percentages
-
Using Excel's Format Painter
-
Creating Styles to Format Data
-
Merging and Centring Cells
-
Using Conditional Formatting
06
Protecting Excel
-
File Level Protection
-
Workbook, Worksheet Protection
-
Add New Range fro protection
07
Text Functions
-
Upper, Lower, Proper
-
Left, Right, Mid
-
Trim, Len, Exact
-
Find, Search, Text, Number, Code, Substitute
-
Concatenate, Replace, REPT
08
Mathematical Functions
-
Sum, Sumif, Sumifs
-
Average, Averageif, Averageifs
-
Count, Countif, Countifs,
-
Average, Averageif, Averageifs
-
Max, Min
-
If, ifs
-
and, or, not and with if, or with if, not with if
09
Date & Time Functions
-
Today, Now
-
Day, Month, Year, YearFrac
-
Date, Date if
-
EOMonth, EDate, Weekday, WeekNUM, Workday
-
Hour, Minute, Second
9-A
Financial Functions in Excel
-
Future Value (FV)
-
FVSCHEDULE
-
Present Value (PV)
-
Net Present Value (NPV)
-
XNPV
-
PMT
-
PPMT
-
Internal Rate of Return (IRR)
-
Modified Internal Rate of Return (MIRR)
-
XIRR
-
NPER
-
RATE
-
EFFECT
-
NOMINAL
-
SLN
10
Advance Paste Special options
-
Paste Formulas, Paste Formats
-
Paste Validations
-
Transpose Table
-
Plan Paste
11
Slicer, Charts and Graphs
-
Working with Charts
-
Using SLICERS, Filter data with Slicers
12
Pivot Tables
-
Creating Simple Pivot Tables
-
Basic and Advanced Value Field Setting
-
Classic Pivot table
-
Choosing Field
-
Filtering PivotTables
-
Modifying PivotTable Data
-
Grouping based on numbers and Dates
-
Calculated Field & Calculated Items
13
Printing Worksheet
-
using of Page Break Preview
-
Setting of Margin, Orientation & Page Size
-
Print Area, Page Break and Print Titles
-
Scale to Fit, Gridlines , Heading
14
Data
-
Import & Export Data
-
Sorting and Filtering
-
Text to Column, FlashFill, Remove Duplicate
-
Data Validation
-
Consolidate the Data
-
What-if-Analysis
-
Scenario Manager
-
Goel Seek
-
Data Table
-
Forecast Sheet
-
Outline
-
Group
-
UnGroup
-
Sub Total
-
Solver Add-in
15
Lookup Functions
-
Vlookup / HLookup
-
Index and Match
-
Creating Smooth User Interface Using Lookup
-
Nested Vlookup
-
Reverse Lookup using Choose Function
-
Worksheet linking using Indirect
-
Vlookup with Helper Column
16
VBA Macro
-
What Is VBA?
-
What Can You Do with VBA?
-
Recording a Macro
-
Procedure and functions in VBA