4.44 out of 5
4.44
122 reviews on Udemy

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

Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data
Instructor:
Bluelime Learning Solutions
10,173 students enrolled
English [Auto]
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

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.

You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.4
4.4 out of 5
122 Ratings

Detailed Rating

Stars 5
59
Stars 4
43
Stars 3
14
Stars 2
2
Stars 1
3
f8f356b8b633077a2b017b2dca47c942
Course available for 2 days
30-Day Money-Back Guarantee

Includes

8 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Never Miss Any Course Join Our Telegram Channel Join Channel
+ +