• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Where to start my learning....|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Where to start my learning....|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumGeneral Excel Questions & Answe…Where to start my learning....
sp_PrintTopic sp_TopicIcon
Where to start my learning....
Avatar
Valerie Vuyovich-Connolly

New Member
Members
Level 0
Forum Posts: 1
Member Since:
August 10, 2020
sp_UserOfflineSmall Offline
1
August 10, 2020 - 9:54 pm
sp_Permalink sp_Print

Good morning, 

I am so far, self-taught, sitting through a lot of youtube videos, google searches, etc. So I am not a beginner, yet sometimes don't county myself as intermediate since there are a few small shortcuts, codes, etc. that I am either not aware of or haven't used often enough to remember. 

I am looking for a recommendation for which learning program would help me. I have 2 scenarios:

1. My paying job: 

Project: Migrate our 'gold' data from 13 shared drives to 1 shareable database

Task: Inventory, prioritize, estimate time, simplify identification of files that need to be moved*, track progress

The inventory portion is completed, we have over 500,000 files, probably 10% are gold. Data cleaning and prioritization is in progress, going fine and using Jupyter Notebook/Python. Once the data is sorted, and prioritization complete, I would like to export the tables into Excel to build a dashboard for 2 purposes:

Enable the poor sod who is going to do the data migration to easily find where they need to start, and enter progress 

Dashboard for leadership to make resource decisions and see progress

2. My hobby/new small business (custom/bespoke clothing)

Project: Build a database where customer information, inventory, item cost and supplies needed are all linked. 

Task: Learn enough excel to be dangerous; move the customer form from Google into an excel-linked pdf form, link everything together. 

What I have:

Google form for customer information (measurements and contact info)

Excel workbook with purchases, including a form for data input, and a few experimental sheets for calculations (supplies & cost based on design and measurements) of certain products. 

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
August 11, 2020 - 9:14 am
sp_Permalink sp_Print

Hi Valerie,

Welcome to our forum! In terms of your first task, it sounds like you have the task in hand and just need help with the reporting side. You mention that you are using Jupyter Notebook/Python for the data cleaning, but then you need to export the tables into Excel. I recommend you look at Power Query. This is the built in Get and Transform/Clean data tool available in Excel and Power BI. Although you've already cleaned the data, you can use Power Query to get the data and load it into Excel Tables.

If you're working with big data and or data spread across multiple tables, then I recommend you look at Power Pivot, which enables you to build relationships between the tables and model the data. It also has a powerful DAX function library to write custom measures.

My Excel Dashboard course is available in a discounted bundle with both Power Query and Power Pivot, so that would be the most cost effective route if you wanted all 3 courses.

In regards to your second task, I suggest you look at Microsoft Forms which integrate with Excel. If you want to improve your general Excel skills then our Excel Expert course will be ideal as it covers everything form the beginner topics (you can skip what you already know) through to the more advanced topics. There's a full syllabus on the course page.

I hope that points you in the right direction, but I'm happy to answer any further questions you might have.

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Geoff McClure, Louis Muti, Misael Gutierrez Sr.
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
David du Toit
Forum Stats:
Groups: 3
Forums: 24
Topics: 6358
Posts: 27805

 

Member Stats:
Guest Posters: 49
Members: 32335
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.