EXCEL SIFU

EXCEL SIFU смотреть последние обновления за сегодня на .

Clean Up (Almost All) Mobile Numbers | Tutorials | Excel Sifu

2165
41
10
00:08:22
04.03.2021

🤔 frustrated in standardizing phone numbers? 👉🏻Watch this 8 minutes tutorial video on how to do this? My goal is to help people make friends with their data. So that they have more time for their loved ones and themselves. Let me know if you need assistance from my side. 😉 Download eBook: The 5 Magic to Master Business Data 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍 #MSExcel #ExcelSifu #WhyExcel

Create a Fun Math Game in Excel | Excel Sifu

441
8
2
00:24:00
22.08.2021

Using Excel VBA to create a simple math game. 0:00 Introduction 0:39 Show Developer Ribbon in Excel 1:07 Quick Run Through on Visual Basic Editor (VBE) 1:45 Create a New User Form 7:02 Adding Code 19:40 Storing Correct and Incorrect Score 21:03 Triggering User Form from Excel Sheet 22:51 Saving as Macro-Enabled Workbook 23:35 Closing Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #ExcelVBA

Excel Automation is So Simple | Excel Sifu

270
4
0
00:36:06
14.02.2022

Follow this simple tutorial to experience the fun of automation in Excel. 0:00 Introduction and Welcoming 0:29 Showing Developer Ribbon in Microsoft Excel 1:19 Unhide All Rows and Columns with Macro Shortcut Key 7:08 Paste as Values with Macro Shortcut Key 10:40 Automate Page Header and Footer with Macro 19:19 Duplicate Worksheet as Values in New Worksheet via Macro 26:23 Saving Recorded Macro as Macro-enabled Workbook 27:14 Security Warning When Opening Macro-Enabled Workbook 28:32 Making a Macro Available to All Excel Files 35:32 Summarizing and Closing Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #Macro

Easily Format Malaysia Mobile Phone Numbers | Excel Sifu

14581
210
44
00:03:39
18.08.2019

Simple method to format Malaysia mobile phone number to a properly formatted ones. Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍

[Uncut Webinar] e-Commerce Inventory Control | MathIsFun UTAR 2022 | Excel Sifu

14
0
0
02:00:16
11.11.2022

0:00 Welcoming by the Committee 4:55 Welcoming and Introduction by Excel Sifu 12:20 The Overall Flow of e-Commerce Inventory Control 13:13 Setting Up Product 21:15 Setting Up Stock In Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

Secretly Pull Malaysia Petrol Price to Microsoft Excel | Excel Sifu

57
4
0
00:12:24
09.11.2022

This is a simple way for you to retrieve updated data from a website. All is done in Microsoft Excel, Get & Transform. DOWNLOAD THE FILE 🤍 THE WEBSITE THAT HAS PETROL PRICE 🤍 TIMESTAMP 0:00 The Typical Scenario When Copying Petrol Price from a Website 1:40 The End Result 2:04 Step 1: Copy The URL of the Website 2:26 Step 2: Use Get & Transform to Pull Malaysia Petrol Price from Carsome Website 11:12 Step 3: Seeing the Final Result Yourself Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

[Uncut Webinar] One-Tip to Master Excel | Excel Sifu

81
4
1
01:00:28
15.08.2022

This webinar is to show the one-tip to master Microsoft Excel. It goes to the root cause of many struggles in Microsoft Excel. Hope you would remember the magical spell from this webinar. Follow along with the file 🤍 Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

💰 Play Monopoly Game with Microsoft Excel | Excel Sifu

3298
23
4
00:10:15
19.11.2020

Personally I enjoy playing casual monopoly game with my kids. The fallback on traditional game set is counting money. In last MCO (Movement Control Order, aka lockdown in Malaysia), I quickly hop on computer and created this simple solution. After relooking at it, I learned this is similar to business world because 👉 create #SmallWins is for long term success 👉 #digitalization could be as simple as a spreadsheet 👉 be #resourcefulness to use whatever resources available to make things happen What have you learned from a monopoly game❓ Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍 #taiexcel #excelsifu #whyexcel

[Uncut Webinar] DIY Sales Dashboard with Microsoft Excel | Excel Sifu

20
0
0
02:15:22
09.11.2022

Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

3 Methods to Manage Row & Columns in Microsoft Excel | Excel Sifu

84
3
2
00:11:00
14.01.2022

Working with lots of rows and columns in Microsoft Excel is a usual challenge to many. This video shows you three simple ways to hide and unhide rows and columns easily. Let me know in the comment on which one you like the most. DOWNLOADABLE FILE 🤍 TIMESTAMP 0:00 Intro and Welcoming 0:19 Hide/Unhide Rows and Columns with Custom View 2:52 Hide/Unhide Rows and Columns with Grouping 6:08 Hide/Unhide Rows and Columns with Macro 10:05 Closing Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

Dynamic Unpivot Data in Excel | Project Demo | Excel Sifu

128
5
2
00:03:00
11.01.2021

Download eBook: The 5 Magic to Master Business Data 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍

[EXCEL SIFU] Enriching Our Excel Reports with Symbols

16
0
0
00:02:33
16.09.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

QC Data Entry | Project Demo | Excel Sifu

452
4
4
00:03:22
24.05.2021

This project demonstrate one of the ways to simplify QC data entry. Download eBook: The 5 Magic to Master Business Data 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍

Combine Undated Data in Microosft Excel with One Click | Excel Sifu | Project Demo

41
0
0
00:01:51
23.11.2020

Download eBook: The 5 Magic to Master Business Data 👉 🤍 😅When the exported monthly data does not have date? Without date, it's very difficult to compile them into single report. The common solution is to manual copy and paste. 👉Watch this video to see the possibilities on how #Excel able to handle this with #oneClick. ❓ What other common struggles you see when importing data into Excel? Comment below Connect to me in LinkedIn 🤍 Like our FB 🤍 #ExcelSifu #MicrosoftExcel #WhyExcel

[EXCEL SIFU]UNPIVOT with Ease with Power Query

117
5
0
00:03:56
09.10.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

Easy Budget vs Actual Comparison | Project Demo | Excel Sifu

216
5
2
00:04:16
18.01.2021

Download eBook: The 5 Magic to Master Business Data 👉 🤍 This 4 minutes video show you the possibilities on using Microsoft Excel to perform budget comparison. Connect to me in LinkedIn 🤍 Like our FB 🤍 #MicrosoftExcel #Budget #Actual

Turning Multiple Lines to Single Line | Project Demo | Excel Sifu

141
2
2
00:02:46
17.02.2021

Download eBook: The 5 Magic to Master Business Data 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍

Daily Job Sheet | Project Demo | Excel Sifu

148
3
0
00:02:26
17.02.2022

Download eBook: The 5 Magic to Master Business Data 👉 🤍 Connect to me in LinkedIn 🤍 Like our FB 🤍

[EXCEL SIFU]Fast Data Entry in Microsoft Excel

77
1
0
00:03:46
21.10.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

[Uncut Webinar] Create Sales Dashboard is So Easy | Excel Sifu

173
9
2
01:01:57
15.09.2021

This part of video is extracted from a webinar. It show the steps on creating a sales dashboard with PivotTable in Microsoft Excel. This method works for all installed version of Microsoft Excel. EXERCISE FILE 🤍 00:00 Welcoming 2:17 How Many of You Knows PivotTable 3:39 Wrong Way of Creating a PivotTable 4:30 Pre-work Needed Prior Creating a PivotTable 9:43 Creating a PivotTable, The Correct Way 12:07 Introduction to PivotTable 19:22 Formatting Number in PivotTable 20:29 Breakdown Analysis 23:40 Sort PivotTable from Largest to Smallest 25:42 Create PivotChart in Less Than 1 Second 32:08 Simple Ways to Format PivotChart Elegantly 41:11 Renaming Worksheet for Better Organization 43:15 Creating PivotTable for Time-Based Analysis 50:19 Creating PivotChart for Time-Based Analysis 55:26 Creating PivotTable with Proper Alignment 1:01:35 What is Your Biggest Takeaway Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #Dashboard

[Uncut Webinar] Staff Movement Analysis | Excel Sharing for HR | Excel Sifu

685
14
6
01:37:06
18.07.2021

This is a uncut webinar on how to use Microsoft Excel to perform staff movement analysis. The method used in Power Query or "Get & Transform." 0:00 Welcoming 6:25 The Scenario Overview 9:00 The Data 11:17 Checking Excel Version 14:29 The Usage of Power Query (Get & Transform) 15:32 Creating Excel Table Prior Using Power Query 16:53 Import Table & Quick Introduction to Power Query 21:45 Extracting Active Staff Data 34:17 Methods to go to Power Query Editor 35:19 Getting Joined Date 41:45 Showing Joined Date with Resigned Date (Context) 42:53 Method to go to Power Query Editor 44:04 Showing Joined Date with Resigned Date (Power Query) 49:24 Calculating Months of Service 57:53 Analyzing Promotion 1:23:41 Staff Movement Analysis 1:30:39 Taking a Pause & Reflect 1:34:15 Closing & Contact Details Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #PowerQuery

[EXCEL SIFU] Faster Data Entry in Excel: Auto Complete

30
0
0
00:01:54
05.11.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

[Uncut] OBJECTION PARTY | Excel Sifu

54
0
2
00:00:19
09.11.2020

It's a love and hate relationship with #Microsoft #Excel. Let's have some fun by give all sorts of #objection, why people refuse to learn Microsoft Excel. There is no right or wrong answer. Please let your juice of objection flow, and have fun! 😁😉 Connect to me in LinkedIn 🤍 Like our FB 🤍

Auto Insert Multi-lines Footer in Excel | Project Demo | Excel Sifu

253
2
0
00:03:06
07.12.2020

Download eBook: The 5 Magic to Master Business Data 👉 🤍 😅When the multiple lines are required to be inserted in between data. This is usually done manually in Microsoft Excel. 👉Watch this video to see the possibilities on how #Excel able to handle this with #oneClick. ❓ What other common struggles you see when handling some works in Excel? Comment below Connect to me in LinkedIn 🤍 Like our FB 🤍 #ExcelSifu #MicrosoftExcel #WhyExcel

Dynamic Report & Top 10 Chart in Excel | Project Demo | Excel Sifu

60
1
0
00:01:21
26.03.2020

Connect to me in LinkedIn 🤍 Like our FB 🤍

Simple Holiday Planner with Microsoft Excel | Excel Sifu

121
1
2
00:13:34
05.02.2022

This is a simple tutorial that uses Microsoft Excel to plan your holiday. Hope you like it! Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

Transaction Reconciliation with Excel VBA | Excel Challenge | Excel Sifu [DOWNLOADABLE FILE]

981
20
6
00:07:25
20.08.2021

This is automated method to perform transactions reconciliation with VBA in Excel. You could grab the file shown in the video 🤍 0:00 Introduction 0:18 The Overview & Logic Behind 3:06 The Code Walkthrough for Reconciliation 6:44 Wrapping Up Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #ExcelVBA

Excel Madness Event Intro | 2021-08-15 | Excel Sifu

24
1
0
00:03:37
12.08.2021

Look out at fb.com/whyexcel Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

[Uncut Webinar] Import External Excel Files | Excel Sifu

53
4
0
00:17:03
14.12.2020

Download eBook: The 5 Magic to Master Business Data 👉 🤍 This method works from Excel 2007, 2010, 2013, 2016, 2019, 365 and more. The files imported would be able refresh with Refresh All, or change it to another file. Connect to me in LinkedIn 🤍 Like our FB 🤍

Easily Prepare PKPB Letters from Excel | Automation | Project Demo | Excel Sifu

298
5
2
00:03:29
02.11.2020

This video is demonstrating how easy letters could be generated from Microsoft Excel. The context shown is preparing PKPB letter for staff to have inter-state travel. #ExcelProject #ExcelSifu #PKPB Connect to me in LinkedIn 🤍 Like our FB 🤍

Correctly Convert Malaysia Mobile Phone Number to CSV File | Excel Sifu

776
19
8
00:06:42
13.12.2021

This video shows you a simple method to export Malaysia mobile phone number as CSV file by using Microsoft Excel. TIMESTAMP 0:00 Introduction of Scenario 0:40 Understanding the Data 1:39 Making Phone Number Consistent with "+60" 4:18 Taking Out Dashes and Spaces from Phone Number 5:28 Double Check Results 5:40 Copy and Paste as Values 6:02 Closing 6:30 More Videos Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #MalaysiaPhone

[Uncut Webinar] Bahasa | Enhance Employability with Excel | OSHEY Webinar | Excel Sifu

63
0
0
01:43:50
11.03.2022

This is an uncut webinar that share on enhancing employability by improving skill in Microsoft Excel. Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel

[EXCEL SIFU]Speed Up Standard Phrase Entry in Excel

33
1
0
00:03:32
29.10.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

[EXCEL SIFU] 3 SIMPLE STEPS TO CONVERT NUMBER TO PERCENTAGE

89
3
0
00:01:55
14.08.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

Factored Revenue Projection with Excel | Project Demo | Excel Sifu

52
0
0
00:06:05
03.04.2020

Connect to me in LinkedIn 🤍 Like our FB 🤍

Calculate Bonus and Increment by Performance Grading for Human Resources | Excel Sifu

350
11
4
00:11:22
26.01.2022

Using Microsoft Excel to performance performance bonus and increment calculation. This uses three different methods to accomplish this task. DOWNLOAD FILE 🤍 TIMESTAMP 0:00 Welcoming and Introduction 0:14 Understanding the data 0:58 Using Excel Table for Reference Table 1:44 Calculating Increment and Bonus with VLOOKUP Approximate Match 4:40 Calculating Increment and Bonus with INDEX MATCH Approximate Match 7:17 Calculating Increment and Bonus with XLOOKUP Approximate Match 9:56 The Beauty of using XLOOKUP Approximate Match 10:29 Summarizing & Closing Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #HumanResources

[EXCEL SIFU] Practical Macro Recording Course Preview

55
0
0
00:03:56
22.08.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

[Uncut Webinar] HR Headcount Analysis and Dashboard in Microsoft Excel | Excel Sifu

1097
12
0
01:30:44
22.10.2021

This is a online live session about performing headcount analysis and transform the analysis to a dashboard. You could obtain the file from 🤍 0:00 Starting 0:15 Explaining the Data File 1:31 Invitation to Think Like a Boss 2:19 Co-Create The Report Requirements 9:02 Check Report Requirements Against The Data 11:22 Turning Normal Data to Excel Table 12:39 Give a Meaningful Name to The Excel Table 13:31 Check Point on Progress 13:45 Repeating Step 1, Create Excel Table 16:36 Calculating Age from NRIC 26:21 Creating a Pivot Table from Excel Table 27:55 Calculating Total and Average Salary 34:46 Detour: Quick Intro to Pivot Table 36:47 Ad Hoc Coaching on Using Pivot Table 42:14 Formatting Number in Pivot Table 42:49 Changing Pivot Table Headers 43:43 Check Point on Progress 45:25 Making Large Number Easier to Read 49:57 Give Meaningful Name to Worksheet 51:37 Blank Worksheet for Dashboard 51:54 Check Point on Progress 52:20 Use Colour with Purpose for Documentation 55:12 Showing Big Number as Card 1:05:50 Calculating Salary Scale 1:18:20 Creating Charts 1:20:42 The Reason for Not to Use 3D Chart 1:21:45 Creating Charts (continued) 1:22:12 Think Like a GM and Revise the Analysis 1:23:09 Easy Split One Pivot Table Analysis into Two 1:24:15 Creating Charts (continued) 1:25:43 Combining Charts as Dashboard 1:26:38 Final Thought About Dashboard 1:27:24 Wrapping Up 1:29:45 What is your biggest takeaway? 1:30:35 Ending... Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #HR

[EXCEL SIFU]Clean up Reports with Lots of Merged Cells

137
0
0
00:03:44
05.09.2019

Connect to me in LinkedIn 🤍 Like our FB 🤍

[Uncut Webinar] Staff Vaccination Tracking | Excel Sharing for HR | Excel Sifu

484
9
2
02:04:58
08.08.2021

0:00 Welcoming & Introduction 6:35 Common Challenges & The Thinking Process 11:23 Creating Google Form for Staff Vaccination Tracking 27:40 Testing & Fine Tuning Google Form 35:55 Sending Google Form Link 42:34 Automatically Download Submitted Responses to Microsoft Excel 53:05 Recommended Approach in using Excel Table 55:14 Correct Imported Data 58:55 Asking Suggestion on What to See & Saving File 59:34 Segregating Data by Vaccination & Registration Status 1:01:15 Overview of Segregating Data in Power Query 1:01:46 Segregate Data: Not Registered 1:06:34 Segregate Data: Registered and Not Vaccinated 1:09:21 Segregate Data: Vaccinated 1:11:30 Interaction with Participants 1:16:19 Cleaning & Keeping Newer Data 1:35:52 Analyzing Data with PivotTable 1:38:30 Further Correction on Aggregated Data 1:49:51 Presenting in Chart 1:57:04 Summary & Closing 2:04:24 Final Appreciation Download eBook: The 5 Magic to Master Business Data 👉 🤍 Follow Me in Odyess 👉 🤍 Join Me in Odyess 👉 🤍 Connect to me in LinkedIn 🤍 Like our Facebook 🤍 Hash Tag #ExcelSifu #MicrosoftExcel #HumanResources

Назад
Что ищут прямо сейчас на
EXCEL SIFU asmr bosnia шоу голос Yeshua memu app player onu gpon fiberhome relay working jersey cow dairy farm funeral memes (Bakhodir Djalolov) naramaxx zakiylar I shave my head russia paver I Shave My Head BALD девушкой MSI GAMER UCLH oko lele zombie curbal power query