Advance Excel

Course Modules

Below is the provided course content rewritten clearly without changing the original content. Module headings are kept and topics are listed as concise bullet points for easy pasting into your website.

Module 1 — WORKING WITH LISTS

• Sorting Records in a List
• Using AutoFilter in a List

Module 2 — WORKING WITH CHARTS

• Creating a Chart with the 2D or 3D
• Create Column Chart
• Create Pie Chart
• Create Line Chart
• Create Cylinder Chart
• Create Cone Chart
• Create Bar Chart
• Moving a Chart
• Resizing a Chart
• Changing a Chart Type
• Editing Chart Text
• Modifying Chart Options
• Formatting Category & Value Axis Data
• Formatting a Data Series
• Changing a Chart’s Source Data

Module 3 — WORKING WITH GRAPHICS

• Using the Drawing Toolbar
• Formatting Objects
• Inserting WordArt
• Inserting a SmartArt
• Modifying a SmartArt

Module 4 — WORKGROUP COLLABORATION

• Web Page Preview
• Converting Worksheets into Web Pages
• Inserting Hyperlinks
• Viewing & Editing Comments

Module 5 — IMPORTING & EXPORTING DATA

• Importing External Data into Excel
• Importing Text Data into Excel
• Importing Data from a Database
• Exporting Data from Excel
• Publishing Worksheets & Workbooks to the Web

Module 6 — FORMATTING NUMBERS

• Using Conditional Formatting
• Removing Conditional Formatting
• Format as Table
• Create Our Styles

Module 7 — WORKING WITH RANGES

• Using the HLOOKUP Function
• Using the VLOOKUP Function

Module 8 — CUSTOMIZING EXCEL

• Creating a Macro
• Running a Macro
• Editing a Macro
• Adding a Menu to the Menu Bar
• Adding Commands to a Menu
• Adding Buttons to a Toolbar

Module 9 — DATA ANALYSIS TOOLS

• Tracing Formula Precedents
• Tracing Cell Dependents
• Error Checking
• Creating a Pivot Table
• Rearranging a Pivot Table
• Filtering Pivot Table Data
• Creating a Pivot Chart

Module 10 — SUMMARIZING DATA

• Adding Subtotals to a List
• Nesting Subtotals
• Applying Advanced Filters
• Adding Group & Outline Criteria to Ranges
• Using Data Validation
• Text to Columns

Module 11 — WHAT?IF DATA ANALYSIS

• Using Goal Seek
• Using Data Table
• Creating & Displaying Scenarios

Module 12 — WORKGROUP COLLABORATIONS

• Locking/Unlocking Cells in a Worksheet
• Protecting a Worksheet
• Protecting a Workbook
• Creating a Shared Workbook
• Tracking Changes to a Workbook
• Accepting & Rejecting Changes to a Workbook
• Password Protecting a Workbook
• Merging Workbooks

Module 13 — FORMAT OF CELLS

• Number
• Alignment
• Border
• Fills
• Cell Size
• Visibility
• Organize Sheets
• Protection

Module 14 — FORMULAS

• Sum
• Product
• Average
• IF
• DAYS360
• Date
• CEILING
• FLOOR
• ROUND
• ROUNDUP
• ROUNDDOWN
• POWER
• COUNT
• COUNTA
• COUNTIF
• SUMIF
• MAXIMUM
• MINIMUM
• HLOOKUP for single worksheet
• VLOOKUP for single worksheet
• HLOOKUP & VLOOKUP for multiple sheets
• INDEX
• Show Formula
• DMIN
• DMAX
• DCOUNT
• DSUM
• DGET
• NOW
• TODAY
• WEEKDAY
• SQRT
• MOD
• UPPER
• LOWER
• LEFT
• RIGHT
• EXACT
• LEN
• MATCH
• ROMAN
• PROPER
• PMT
• CONCATENATE
• IF Function & Nested IF Statements
• AND & OR Functions
• DISC
• LOG
• AVERAGEA
• DOLLAR
• MAXA
• MINA
• COUNTBLANK
• LARGE
• IFERROR
• AND
• COUPDAYS
• NOT
• MODE.SNGL
• MEDIAN
• FV
• PV
• IPMT
• SUMIFS
• MODE
• DATEDIF
• COUNTIFS
• RECEIVE
• PPMT
• RATE
• NETWORKDAYS
• COUPNUM

Module 15 — CUSTOM VIEWS

• Add, Delete, Show

Module 16 — PRINT SETTINGS

• Page Break
• Print Area
• Print Titles
• Background