Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)

Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX), available at $19.99, has an average rating of 4.25, with 90 lectures, based on 224 reviews, and has 24638 subscribers.

You will learn about Enter data in a spreadsheet Save and open spreadsheet Create formulas and functions Format rows, columns, cells, and data Align text in a cell Adjust rows and columns Find and replace data Insert and delete sheets Sort data Add Borders and Fill Colours Use Number Formatting Use AutoSum Insert Functions Create and edit Macros Create lookups with DAX VBA Scripting Debugging Macros Connect to data sources Analyze data with Pivot Tables and Pivot Charts Prep data with Power Query Consume data with Power Pivot Create queries Create reports This course is ideal for individuals who are Beginners to spreadsheets and excel or Those who need a refresher to excel. It is particularly useful for Beginners to spreadsheets and excel or Those who need a refresher to excel.

Enroll now: Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)

Summary

Title: Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)

Price: $19.99

Average Rating: 4.25

Number of Lectures: 90

Number of Published Lectures: 86

Number of Curriculum Items: 90

Number of Published Curriculum Objects: 86

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Enter data in a spreadsheet
Save and open spreadsheet
Create formulas and functions
Format rows, columns, cells, and data
Align text in a cell
Adjust rows and columns
Find and replace data
Insert and delete sheets
Sort data
Add Borders and Fill Colours
Use Number Formatting
Use AutoSum
Insert Functions
Create and edit Macros
Create lookups with DAX
VBA Scripting
Debugging Macros
Connect to data sources
Analyze data with Pivot Tables and Pivot Charts
Prep data with Power Query
Consume data with Power Pivot
Create queries
Create reports

Who Should Attend

Beginners to spreadsheets and excel
Those who need a refresher to excel.

Target Audiences

Beginners to spreadsheets and excel
Those who need a refresher to excel.

Microsoft Excel is a powerful tool essential for managing and presenting data
in today’s working environment. In this one day excel course,
you will gain the knowledge and skills required to create and edit worksheets, use formulas
and functions, sort and filter detail data visually, and present summary information
in a consumable and professional format.

A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft.

The Power Query and Power Pivot features in Microsoft Excel can make a powerful combination. Power Query enables you to discover, connect to, and import data, and Power Pivot lets you quickly model that data. You will learn how to use the DAX formula language to provide lookup abilities.

I will walk you through step-by-step how to use Power Query to select data, prepare a query, cleanse data, and prepare data for Power Pivot. Also i will walks you through the Power Pivot workflow, showing how to create a data model, import additional data if needed, build relationships between data, and create calculations and measures.

You will learn hands on real-world scenarios for working together with Power Query and Power Pivot.

What You Will Learn Include:

What is Office 365
Setting up Office 365
Excel 2016 user interface
Exploring the Excel Ribbon
Customizing the Quick Access Toolbar
Keeping Tabs on the Ribbon
Entering Data
Opening a new workbook
Entering Data in Excel
Basic Data entry
Entering Data with Autofill
Entering Date
Entering Time
Undo and Redo Changes
Adding Comments
Giving your worksheet a title
Saving your work
Creating Formulas and Functions
Using formulas for arithmetic tasks
Re-using Formulas
Calculating YTD Profits
Calculating Percentage Change
Using Relative and Absolute Reference
Using RANK Function
STD Function
Small and Large Functions
Median Function
Count and counta functions
Formatting
Exploring Fonts
Adjusting Column Width and Row Height
Using Alignment
Designing Borders
Formatting Numbers
Conditional Formatting
Creating Tables
Inserting Shapes
What VBA is and why it is so incredibly useful
What are Macros
Creating Macros using macro recorder
Creating macro manually from scratch
Editing Macros
Debugging Macros
How to write VBA code and execute it in Excel
How to make your macros work with workbooks, worksheets and the data on them
How to find and eliminate errors in your programs and make your macros run
Automation using macros.
Analyse the macro from the Developer tab or the View tab.
Examine the VBA window and VBA components.
Distinguish between absolute and relative references.
How to save workbook with macros
Create a module
Create procedure
Create a sub
Understand the difference between a module and sub
Run the code in a sub
Preparing queries
Cleansing data with Power Query
Enhancing queries
Creating a data model in Power Pivot
Building relationships
Creating Pivot Tables and Pivot Charts
Creating Lookups
Using DAX to link data
Creating data model
Creating relationship between data sources
Analyzing data with PivotTables and PivotCharts
Using Power Query with PowerPivot
Connecting to a variety of data sources with Power BI
Create and publish reports to Power BI Service
Refreshing Data Source
Updating Queries
Using Conditional statements
Using quick and dynamic measures
Transforming data on connected datasets

After completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more.

Course Curriculum

Chapter 1: Installing and Exploring Excel 2016

Lecture 1: Introduction

Lecture 2: What is Excel

Lecture 3: What is Office 365

Lecture 4: Office 365 Setup

Lecture 5: Activating Office 365 Apps

Lecture 6: Logging into Office 365

Lecture 7: Excel 2016 user interface

Lecture 8: Exploring the Excel Ribbon

Lecture 9: Customizing the Quick Access Toolbar

Lecture 10: Keeping Tabs on the Ribbon

Chapter 2: Entering Data

Lecture 1: Opening a new workbook

Lecture 2: Entering Data in Excel

Lecture 3: Entering Data with Autofill

Lecture 4: Entering Date

Lecture 5: Entering Time

Lecture 6: Undo and Redo Changes

Lecture 7: Adding Comments

Lecture 8: Giving your worksheet a title

Lecture 9: Saving your work

Chapter 3: Creating Formulas and Functions

Lecture 1: Introduction

Lecture 2: Using formulas for arithmetic tasks

Lecture 3: Re-using Formulas

Lecture 4: Calculating YTD Profits

Lecture 5: Calculating Percentage Change

Lecture 6: Relative and Absolute Reference

Lecture 7: Using RANK Function

Lecture 8: STD Function

Lecture 9: Small and Large Functions

Lecture 10: Median Function

Lecture 11: Count and counta functions

Chapter 4: Formatting

Lecture 1: Exploring Fonts

Lecture 2: Adjusting Column Width and Row Height

Lecture 3: Using Alignment

Lecture 4: Designing Borders

Lecture 5: Formatting Numbers

Lecture 6: Conditional Formatting

Lecture 7: Creating Tables

Lecture 8: Inserting Shapes

Chapter 5: Excel 2016 Useful Tips

Lecture 1: Add or Remove Worksheets

Lecture 2: Resizing Columns and Rows

Lecture 3: Presenting Excel Data in a Chart

Lecture 4: Making workbook read only

Lecture 5: Changing text alignment

Lecture 6: Freezing panes

Lecture 7: Add and remove columns and Rows

Chapter 6: Sharing and Security

Lecture 1: Sharing workbook and Tracking Changes

Lecture 2: Protectecting workbook from structural change

Lecture 3: Protecing your workbook

Lecture 4: Protecting your worksheet

Chapter 7: Data Preparation Using Power Query

Lecture 1: What is Power Query

Lecture 2: Connecting to a data source

Lecture 3: PLEASE READ

Lecture 4: Preparing your query

Lecture 5: Cleansing data

Lecture 6: Enhancing query

Chapter 8: Data Consumption with Power Pivot

Lecture 1: What is Power Pivot

Lecture 2: Office Versions of Power Pivot

Lecture 3: How to Enable Power Pivot in Excel

Lecture 4: Creating a data model

Lecture 5: Importing data and creating relationships

Lecture 6: Create lookups with DAX

Lecture 7: Analyze data with Pivot Tables

Lecture 8: Analyze data with Pivot Charts

Lecture 9: Refreshing Source Data

Lecture 10: Updating Queries

Lecture 11: Creating new reports

Chapter 9: VBA and Macros

Lecture 1: What are Macros

Lecture 2: What is VBA

Lecture 3: Activating Macros and VBA Tools

Lecture 4: Exploring VBA Tools

Lecture 5: Creating a basic Macro

Lecture 6: Saving a worksheet with a macro

Lecture 7: Creating a another macro: Part 1

Lecture 8: Creating a another macro: Part 2

Lecture 9: Exploring Macros with VBA Editor

Lecture 10: Commenting and deleting macro code

Lecture 11: Editing Macros

Lecture 12: Sorting data with Macros

Lecture 13: Filtering Data with Macros

Lecture 14: Creating buttons to run Macros

Lecture 15: Protecting cells and sheets with Macros

Lecture 16: Debugging Macros: Part 1

Lecture 17: Debugging Macros: Part 2

Lecture 18: Debugging Macros: Part 3

Lecture 19: Manually Create Macros

Lecture 20: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes
2 stars: 5 votes
3 stars: 32 votes
4 stars: 87 votes
5 stars: 97 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu