Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Office ProductivityMicrosoftExcel

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

Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data
Rating: 3.9 out of 53.9 (202 ratings)
24,629 students
Created by Bluelime Learning Solutions
Last updated 4/2022
English
English [Auto]

What you'll 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

Requirements

  • You should be able to use a PC at a beginner level

Description

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.


Who this course is for:

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

Instructor

Bluelime Learning Solutions
Learning made simple
Bluelime Learning Solutions
  • 4.1 Instructor Rating
  • 32,874 Reviews
  • 724,616 Students
  • 385 Courses

Bluelime is UK based and creates quality easy to understand  eLearning  solutions .All our courses are 100% video based. We teach hands –on- examples  that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.