IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > Microsoft Excel - Excel from Beginner to Advanced
Microsoft Excel - Excel from Beginner to Advanced by Udemy
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365/2024
Course Highlights
- Master Microsoft Excel from Beginner to Advanced
- Build a solid understanding on the Basics of Microsoft Excel
- Learn the most common Excel functions used in the Office
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
- Maintain large sets of Excel data in a list or table
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Access to a Professional Trainer with 10+ years of Excel Training
Skills you will learn!
Curriculum
3 Topics
Ask Questions
Course Exercise Files
Certificate of Completion
10 Topics
Launching Excel
Microsoft Excel Startup Screen
Introduction to the Excel Interface
Customizing the Excel Quick Access Toolbar
More on the Excel Interface
Understanding the Structure of an Excel Workbook
Saving an Excel Document
Opening an Existing Excel Document
Common Excel Shortcut Keys
Excel Fundamentals Quiz
8 Topics
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 (DOWNLOAD EXERCISE FILE)
Entering and Editing Text and Formulas Quiz
10 Topics
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
Basic Excel Functions Quiz
8 Topics
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
Modifying Worksheets Quiz
12 Topics
Working with Font Formatting Commands
Changing the Background Color of a Cell
Adding Borders to Cells
Excel Cell Borders Continued
Formatting Data as Currency Values
Formatting Percentages
Using Excel's Format Painter
Creating Styles to Format Data
Merging and Centering Cells
Using Conditional Formatting
Editing Excel Conditional Formatting
Formatting Data Quiz
4 Topics
Inserting Images
Inserting Excel Shapes
Formatting Excel Shapes
Working with Excel SmartArt
8 Topics
Creating an Excel Column Chart
Working with the Excel Chart Ribbon
Adding and Modifying Data on an Excel Chart
Formatting an Excel Chart
Moving a Chart to another Worksheet
Working with Excel Pie Charts
Microsoft Excel Charts Quick Guide (DOWNLOAD)
Working with Excel Charts Quiz
7 Topics
Viewing your Document in Print Preview
Changing the Margins Scaling and Orientation
Excel Worksheet Margins
Working with Page Layout View
Adding Header and Footer Content
Printing a Specific Range of Cells
Printing an Excel Worksheet Quiz
4 Topics
Intro to Excel Templates
Opening an Existing Template
Creating a Custom Template
Excel Templates Quiz
1 Topic
Excel 101 - Practice What You've Learned (DOWNLOAD)
1 Topic
Congratulations!
1 Topic
Excel 102 Course Exercise Files -- DOWNLOAD
10 Topics
Understanding Excel List Structure
Sorting a List Using Single Level Sort
Sorting a List Using Multi-Level Sorts
Using Custom Sorts in an Excel List
Filter an Excel List Using the AutoFilter Tool
Creating Subtotals in a List
Format a List as a Table
Using Conditional Formatting to Find Duplicates
Removing Duplicates
Excel List Quiz
8 Topics
Introduction to Excels Function: DSUM()
Excel DSUM Function Single Criteria Continued
Excel DSUM Function with OR Criteria
Excel DSUM Function with AND Criteria
Excel Function: DAVERAGE()
Excel Function: DCOUNT()
Excel Function: SUBTOTAL()
List Functions :Quiz
6 Topics
Understanding the Need for Excel Data Validation
Creating an Excel Data Validation List
Excel Decimal Data Validation
Adding a Custom Excel Data Validation Error
Dynamic Formulas by Using Excel Data Validation Techniques
Data Validation Quiz
8 Topics
Importing Data Into Microsoft Excel
Importing Data from Text Files
Importing Data from Microsoft Access
NEW VERSION -- Import Data From Text Files into Excel
NEW VERSION -- Import Data From a Database into Excel
Microsoft Excel Legacy Import Options for New Excel Versions
Exporting Data to a Text File
Importing and Exporting Data Quiz
10 Topics
Understanding Excel PivotTables
Creating an Excel PivotTable
Modifying Excel PivotTable Calculations
Grouping PivotTable Data
Formatting PivotTable Data
Modifying PivotTable Calculations
Drilling Down into PivotTable Data
Creating PivotCharts
Filtering PivotTable Data
Filtering with the Slicer Tool
7 Topics
Introduction to Excel Power Pivot
Why PowerPivot?
Activating the Excel PowerPivot AddIn
Creating Data Models with PowerPivot
Excel Power Pivot Data Model Relationships
Creating PivotTables based on Data Models
Excel Power Pivot KPIs
6 Topics
Using the Freeze Panes Tool
Grouping Data (Columns and/or Rows)
Print Options for Large Sets of Data
Linking Worksheets (3D Formulas)
Consolidating Data from Multiple Worksheets
Microsoft Excel Managing Large Excel Datasets Quick Guide (DOWNLOAD)
1 Topic
Excel 102 - Practice What You've Learned (DOWNLOAD)
1 Topic
Congratulations!
1 Topic
Excel 103 Course Exercise Files -- DOWNLOAD
10 Topics
Working with Excel Name Ranges
Advantages and Disadvantages of Excel Name Ranges
Editing an Excel Name Range
Using Excel's IF() Function
Excel's IF() Function with a Name Range
Nesting Functions with Excel
Nesting Excels AND() Function within the IF() Function
Using Excel's COUNTIF() Function
Using Excel's SUMIF() Function
Using Excel's IFERROR() Function
7 Topics
Microsoft Excel VLOOKUP() Function
Microsoft Excel HLOOKUP() Function
Microsoft Excel INDEX() Function
Microsoft Excel MATCH() Function
Microsoft Excel INDEX() and MATCH() Function Combined
Microsoft Excel INDEX() and MATCH() Function Combined Continued
Creating a Dynamic HLOOKUP() with the MATCH() Function
5 Topics
Using Excel's LEFT() RIGHT() and MID() Functions
Using Excel's LEN() Function
Using Excel's SEARCH() Function
Using Excel's CONCATENATE() Function
Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD)
4 Topics
Tracing Precedents in Excel Formulas
Tracing Dependents in Excel Formulas
Working with the Watch Window
Showing Formulas
3 Topics
Protecting Specific Cells in a Worksheet
Protecting the Structure of a Workbook
Adding a Workbook Password
4 Topics
Working with Excel's Goal Seek Tool
Working with Excel's Solver Tool
Building Effective Data Tables in Excel
Creating Scenarios in Excel
5 Topics
Understanding Excel Macros
Activating the Developer Tab in Excel
Creating a Macro with the Macro Recorder
Editing a Macro with VBA
Creating Buttons to Run Macros
1 Topic
Excel 103 - Practice What You've Learned (DOWNLOAD)
1 Topic
Congratulations on Completing the Microsoft Excel 103
2 Topics
Welcome to the Course
Understanding the Why and How Behind Excel Macros
11 Topics
Introduction to Project #1: Inserting and Formatting Text
Project #1: Section Exercise Files (DOWNLOAD)
Activating the Excel Developer Tab
Project #1: Start Recording!
Running a Microsoft Excel Macro
Project #1: Running an Excel Macro with a Button
BONUS - Create a Custom Button Using Excel Shapes
Adding the Excel Macro to the Quick Access Toolbar
Project #1: Editing the VBA Recorded by the Macro Recorder
Save a Workbook with a Macro/VBA Code
Practical Uses of Excel Macros
13 Topics
Intro to Excel VBA Concepts
Intro to Excel VBA Object Oriented Programming Concepts
Intro to Excel VBA Exercise Files (DOWNLOAD)
The Visual Basic Editor (VBE)
Introduction to the Excel VBA Immediate Window
Excel VBA Modules
Creating an Excel VBA Procedure
Adding Code to a VBA Procedure
Including Excel VBA Comments
Excel VBA MSGBOX Function
Excel VBA MsgBox Microsoft Help Information
Understanding and Working with Excel VBA Variables
REMINDER: Saving an Excel Workbook with VBA Code
9 Topics
Working with Excel VBA Logic Exercise Files (DOWNLOAD)
Building Logic with an Excel VBA IF Statement
Including an Else Statement in the VBA IF Statement
Expanding the IF Logic with Multiple ElseIf Statements
Working with Excel VBA Select Case Statements
Working with an Excel VBA Do While Loop
Excel VBA Do While Loop Dynamic Condition
Working with an Excel VBA For Each Loop
Working with an Excel VBA For Next Loop
10 Topics
Introduction to Project #2: Interacting with the User
Beyond the Basics Sort Project Exercise Files (DOWNLOAD)
Project #2: Introduction to the Excel VBA Range.Sort Method
Creating the Excel VBA Sort Procedures for this Project
Project #2: Prompting the User for Information
Continue Excel VBA InputBox
Project #2: Building Logic into Your Macros
Project #2: Alerting the User of Errors
Using Excel VBA Error Control Statements
Create a Button to Run the Sort Procedure and Save
9 Topics
Introduction to Project #3: Cleaning Up and Formatting Data
Project #3: Exercise Files (DOWNLOAD)
Project #3: Preparing to the Use the Macro Recorder
Project #3: Inserting the Headers
Project #3: Formatting the Headers
Project #3: Testing the Macros
Project #3: Using an Excel VBA Loop to Loop through all Worksheets
Project #3: Testing the Excel VBA Loop
Project #3: Adding Logic to an Excel VBA Loop
7 Topics
Introduction to Project #4: Automate Excel Formulas
Project #4: Automate Sum Function Exercise Files (DOWNLOAD)
Project #4: Start the Procedure to Automate the SUM Function
Working with the Range Address Property
Creating the SUM Function in VBA
Run the Excel VBA Procedure to SUM Records
Project #4: Loop the SUM() Function Over Multiple Worksheets
8 Topics
Introduction to Project #5: Creating the Final Report
Project #5: Final Report Loop Exercise Files (DOWNLOAD)
Project #5: Creating the Final Report Excel VBA Loop
Project #5 - Copying Content with Excel VBA
Project #5 - Pasting Content with Excel VBA
Cleaning Up the Final Report VBA Loop Code
Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet
Project #5 - Running the Final Report Procedure
15 Topics
Introduction to Project #6: Working with Excel VBA User Forms
Project #6: Working with Excel VBA User Forms Exercise Files (DOWNLOAD)
Project #6: Creating an Excel User Form
Project #6: Working with Form and Control Properties
Project #6: Formatting Excel VBA User Form Controls
Project #6: Adding VBA Code to the Initialize Event
Project #6: Using the AddItem Method within a Loop
Project #6: Adding VBA Code to the ComboBox Change Event
Project #6: Adding VBA Code to the Add Worksheet Button
Project #6: Change Worksheet Name
Project #6: Catch Errors When Adding a Worksheet
Add Sheet Procedure Catch Errors
Project #6: Additional Conditions on the Loop
Project #6: Running the Final Report Procedure
Project #6: Showing the VBA User Form On Workbook Open
9 Topics
Project #7: Opening a Text File for Import
Project #7: Opening a Text File for Import
Project #7: Get Data from Text File
Project #7: Importing Multiple Text Files with the GetOpenFilename Method
Project #7: Creating a Loop to Read Each File
Project #7: Adding a New Sheet for Imported Data
Project #7: Clear the Clipboard
Project #7: Working with the ScreenUpdating Property
Project #7: Creating Reusable Code with a VBA Function
1 Topic
Congratulations! You're an Excel Macro/VBA Master
Microsoft Excel - Excel from Beginner to Advanced
Related Excel Courses
Thank You!
Your review has been submitted successfully.