GHS (GH₵)
GH₵
Ghanaian cedi
€
Euro Member Countries
₦
Nigeria Naira
$
United States Dollar
Your cart is empty
Empty notifications
Login
Register
Learn
Data Analytics with Microsoft Excel
Data Analytics with Microsoft Power BI
Data Analytics with SQL
Microsoft Excel Essentials
Python for Data Science
Artificial Intelligence
Data Analytics
Guided Project
SQL
Power BI
Microsoft Excel
Python
Projects
Microsoft Excel
Python
SQL
Power BI
Project challenge
Home
Courses
Career Tracks
Bootcamps
Pricing
Teach on FestMan
Get started
Get started
Your cart is empty
Empty notifications
Import financial statements into Excel
Lesson 67/67
|
Study Time: 16 Min
Course:
Business Intelligence: Power Query for Excel
Previous Lesson
THOMAS FESTUS CUDJOE
Product Designer
4.67
Profile
Book a Meeting
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
Learn advanced Excel, Power BI, SQL and AI. Become a Business Intelligence Analyst or Data Analyst.
Learn more