Live Virtual Training (Most Popular!) > Microsoft Excel 2019 Intermediate
REQUIRED PREREQUISITES:
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.
Module 1: Referencing Calculations
Topic A: Formula Reference
• Relative References
• Absolute References
• Mixed References
Topic B: Apply Range Names
• Range Names
• Adding Range Names Using the Name Box
• Adding a Range Names Using Define Name
• Adding multiple names using Create from Selection
• Editing and Deleting Range Name Using Name Manager
• Using Range Names in Formulas
Module 2: Working with Functions
Topic A: Data Summary with Function
• COUNTA
• AVERAGEA
Topic B: Conditional Data Summary 1
• COUNTIF / COUNTIFS
• AVERAGEIF / AVERAGEIFS
• SUMIF / SUMIFS
• MAXIF
• MINIF
Topic C: Conditional Data Extraction
• IFERROR
• IF
• IFS or Nested IF
Topic D: Conditional Data Summary 2
• DSUM
• DCOUNT / DCOUNTA
• DAVERAGE
• DMAX
• DMIN
Module 3: Organizing Dynamic Data Range with Tables
Topic A: Create and Modify Tables
• Create table
• Styles and Quick Style Sets
• Removing Duplicate Values
Topic B: Sort and Filter Data
• Sorting Data
• Filtering Data
• Advanced Filtering
Topic C: Use Subtotal to Calculate Data
• Total Row with SubTotal Functions
Topic D: Data Validation
• Data Validation Using Lists
• Data Validation Using Whole Number / Decimal
• Data Validation Using Date
• Data Validation Using Formulas
Module 4: Data Visualization
Topic A: Conditional Formatting
• Highlight Cell Rules
• Data Bars
• Icon Sets
• Creating New Rules with Formula
Topic B: Create Charts
• Chart Types
• Chart Insertion Methods
• Resizing and Moving the Chart
• Adding Additional Data
• Switching Between Rows and Columns
Topic C: Modify and Format Charts
• Chart Elements
• Minimize Extraneous Chart Elements
• The Chart Tools Contextual Tabs
• Formatting the Chart with a Style
• Adding a Legend to the Chart
Topic D: Adding Sparklines
• Adding Sparklines
• Editing Sparkline Data
• Removing Sparklines
Topic E: Editing Sparklines
• Showing and Hiding Data
• Changing the Style
• Changing the Sparkline and Marker Color
• Setting Axis Options
Module 5: Setting Up Reports as Pages
Topic A: Working with Different Views
• Using Page Break Preview for Page Setup
• Using Page Layout View for Express Header & Footer
• Using Custom view
Topic B: Managing Multiple Windows
• Arranging Workbooks
• Comparing Workbooks Side by Side
• Synchronous Scrolling and Resetting a Window
4.5
Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.
FREE QUOTATION!
COURSE INCLUDES
COURSE BENEFITS
ALL IN FROM ONLY
RM949/DAY
RRP RM2,500/DAY SAVE RM1,551
*T&C Applies
Customer Service 101
Trainer Indy
Effective Thinking and Solution Mindset (Online Training)
Trainer Dr Alvin
Time & Stress Management (Online Training)
Trainer Dr Alvin
Business English For Office (Online Training)
Trainer Fakitah
Enhancing Business Correspondence (Online Training)
Trainer Fakitah
Occupational Safety & Health (OSH) Management Workshop (Online Training)
Trainer Dominic
RRP RM1,000/day SAVE RM275
Behavioral-Based Safety for Accident Prevention Workshop (Online Training)
Trainer Dominic
RRP RM1,000/day SAVE RM275
Live chat, call or email, we’re here for you
Quorse is Asia’s #1 online training marketplace that connects learners with trainers who seek a value-added training experience on a single platform. Discover training courses from diverse categories, ranging from technical IT certifications to personal development programs.
Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly
Sign in with your social account
or
By signing up, you agree to our Terms of Use and Privacy Policy