GHS (GH₵)
GH₵
Ghanaian cedi
Euro Member Countries
Nigeria Naira
$
United States Dollar

Import financial statements into Excel

Lesson 67/67 | Study Time: 16 Min
THOMAS FESTUS CUDJOE

THOMAS FESTUS CUDJOE

Product Designer
4.67
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert

Class Sessions

1- Lesson 1: What is Power Query? 2- Lesson 2: Phases in Power Query 3- Lesson 3: Why Power Query? 4- Lesson 1: Introduction to Data Sources in Power Query 5- Lesson 2: Connecting to data from Current workbook 6- Lesson 3: Connecting to data from Excel Workbook 7- Lesson 4: Connecting to Data From CSV or Text file 8- Lesson 5: Connect to Data from Databases: MS Access 9- Lesson 6: Connect to data from Database: SQL Server 10- Lesson 7: Import data from PDF 11- Lesson 8: Import data from web 12- Power Query Data types 13- Filter columns 14- Sorting columns 15- Rearrange columns 16- Filling missing values 17- Splitting columns 18- Split data with delimiter 19- Keep rows 20- Transpose columns 21- Lesson 1: Load destinations 22- Lesson 2: Load destinations Demo 23- Append queries 24- Append queries with different column names 25- Append multiple Excel files 26- Merging queries 27- Introduction to Join kinds 28- Join kinds sample Dataset 29- Left Outer Join 30- Right outer join 31- Full outer 32- Inner Join 33- Left Anti Join 34- Right anti join 35- Join Kinds demo 36- Lesson 1: Grouping data with GROUP BY 37- Lesson 1: Pivot rows 38- Lesson 2: Pivot rows 2 39- Lesson 3: Unpivot columns 40- Adding columns Introduction 41- Adding Conditional columns 42- Adding Columns from Examples 43- Adding Columns from numbers 44- Adding custom columns 45- Adding Columns from Dates 46- Lesson 1: Introduction to data profiling 47- Lesson 2: Data profiling demo 48- Custom column: IF Statement 49- Lesson 1: Copying queries 50- Lesson 2: Duplicte vs reference 51- Lesson 2: Data Source error 52- Lesson 3: Column not found error 53- Lesson 4: Cell Level errors 54- Lesson 5: Handling errors with If otherwise 55- Lesson 4: Supported Excel versions for Power Query 56- Introduction to the Power Query editor 57- Identify column headers 58- Lesson 9: Importing Data from folder 59- Remove Rows 60- Lesson 1: Introduction to errors in Power Query 61- Course conclusion 62- Course Introduction 63- Course Community 64- Project 1 65- Project 2 66- Get started 67- Import financial statements into Excel

18 Weeks Business Intelligence and Data Analytics

18 Weeks Business Intelligence and Data Analytics

Learn advanced Excel, Power BI, SQL and AI. Become a Business Intelligence Analyst or Data Analyst.