Preview Advanced Microsoft Excel Online Course

BACK TO COURSE

Section I - Excel Functions for Professionals

60. Introduction to Advance Functions in Excel

61. Payment Functions & Loans

62. Future Value Function & Pensions

63. VLOOKUP Function & GradeBooks

64. IF, Concatenate, & Evaluation

65. Conditional Formatting

66. IFERROR Function & Dynamic Amortization Tables

67. Calculating A Grade Example

68. How to Collect Data by Google Forms?

Section J - Statistical Functions Commonly used in Excel

69. Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.

70. Extracting Values with SMALL/LARGE & RANK/PERCENTRANK

71. Randomization with RAND() & RANDBETWEEN

72. Row-Level Calculation with SUMPRODUCT

73. How to Calculate Shipping Cost with SUMPRODUCT?

74. Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS

75. Building a Basic Dashboard with COUNTIFS & SUMIFS

76. Counting Duplicates with COUNTIF & SUMPRODUCT

77. Data Profiling with COUNT & SUMPRODUCT

Macros/VBA

Introduction to Macros

VBA Editor

Basics: VBA Editor

Advanced VBA Editor

Creating / Editing Code

Basics : Creating / Editing Code

Advanced: Creating / Editing Code

Invoking Macros

Beginners : Invoking Macros

Advanced: Invoking Macros

Compiling Code

Basic : Compiling Code

Advanced: Compiling Code

Variables

Understanding Variables

Advanced Variables

Working With Object Model

Basic : Working With Object Model

Advanced

Creating and naming objects

Basic : Creating and naming objects

Advanced: Creating and naming objects

Navigation / Selection Techniques

Beginners : Navigation / Selection Techniques

Advanced: Navigration Techniques

Logic Statement

Logic Statement : Nested IF

Functions - User Defined

What is Logical Statement?

Looping Statement

Basic : Looping Statement

Advanced: Looping Statement

Interactive Code

Basic : Interactive Code

Advanced: Interactive Code

Error Handles

Error Handlings

Advanced

Excel Live Session

Excel Live Session 1

Preview - Advanced Microsoft Excel Online Course - Hindi