Advanced Excel Weekday Course - Fastrack

The Advanced Excel course is conducted by a very experienced Corporate trainer and covers all the topics required to work successfully in this domain -

The course will cover the following -

1. Working with Data: Conditional Formatting, Sort & Filter
2. Formulas – Writing & Fixing Errors
3. Working with Data
4. Data Presentation using Charts
5. Data Analysis & Pivot Tables

Working with Data

• Conditional Formatting
• Fill feature
• Sorting-number. alphabets, color, date, custom
• Filter
• Text to column: Importing .txt files / CSV into excel
• Data Validation (List, Error Message)

Data Presentation using Charts

• Charts (Bar, Column, Line, Pie, Area, 3d
• Multi-dimension Axis
• Moving & Copying Charts

Miscellaneous

• Freeze panes
• Auto Sum on the Task-bar
• Usage of Top Ribbon Menu
• Printing Multiple Sheets

Formula Writing & Fixing Errors

• Look up: Vlookup, Hlookup
• Math: Sum, Sumproduct, Absolute, Integer, Round, Average, Count, Minimum, Maximum
• Logical: IF, nested if, sumif, Count, CountIf, CountBlank, iferror and, or,
• Text: Case, Position, Search, Trim, Right, Left, Concatenate
• Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day

• Others: Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Power Precedents, Dependents

Data Summarization

• Pivot Table
• Pivot Chart

Formatting

• Formatting & Layout
• Putting Headers and Footers, logos on Excel
• Print Layout

Who are we?

Palium is a training organization conducting trainings on Functional, Soft-Skills, IT and Project Management areas. We have conducted trainings for leading corporates like ITC, CESC, JUSCO, CMS and many others.

We also conduct trainings on Primavera P6, MS Project and other Project Management related topics.