Setup Menus in Admin Panel

Course Curriculum

Welcome! Course Introduction
1.1 Welcome 00:00:00
1.2 Excel Made Easy: A Beginner’s Guide to Excel Spreadsheets 00:00:00
1.3 Data Entry Techniques in Excel 00:00:00
1.4 How to Make Your Spreadsheets Look Professional 00:00:00
1.5 Inserting, Deleting, and Modifying Rows & Columns 00:00:00
1.6 Excel Formulas for Beginners 00:00:00
1.7 Excel Functions 00:00:00
1.8 Work Efficiently by Using Cut, Copy, and Paste 00:00:00
1.9 Pasting Values, Formulas and Formats with Paste Special 00:00:00
Microsoft Excel - Useful Tools & Tips
2.1 Inserting a Line Break with Alt + Enter 00:00:00
2.2 Do More with Your Sales Data with Excel’s Text to Columns Feature 00:00:00
2.3 Create Easily Printable Excel Documents 00:00:00
2.4 How to Wrap Text in Excel and Adjust a Cell’s Size 00:00:00
2.5 Insert Hyperlinks into Excel Spreadsheets 00:00:00
2.6 Using Excel’s Freeze Panes to Handle Large Datasets 00:00:00
2.7 Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do 00:00:00
2.8 A Quick Introduction to Excel’s Pivot Tables 00:00:00
2.9 Initial Formatting Is Key for Creating Professional-looking Spreadsheets 00:00:00
2.10 Macros Are a Great Timesaver! Here’s Why 00:00:00
2.11 The Secret to Faster Scrolling in Excel 00:00:00
2.12 Be even quicker: F5 + Enter 00:00:00
2.13 Using Absolute and Relative Cell References 00:00:00
2.14 Find and Select Cells That Meet Specific Conditions 00:00:00
2.15 How to Create Dynamic Names in Excel Spreadsheets 00:00:00
2.16 Using Named Ranges to Make Formulas More Readable 00:00:00
2.17 Custom Number Formatting 00:00:00
2.18 How to Add a Drop-down List in Excel 00:00:00
2.19 Using Custom-sort to Sort Multiple Columns Within a Table 00:00:00
2.20 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts 00:00:00
2.21 Find and Replace – References 00:00:00
2.22 Find and Replace – Formatting 00:00:00
2.23 Green References 00:00:00
2.24 Beauty Saving – The Professional Way of Saving Files 00:00:00
2.25 The Power of F2 00:00:00
2.26 Conditional Formatting 00:00:00
Microsoft Excel - Beginner, Intermediate & Advanced Functions
3.1 Key Excel Functions: If 00:00:00
3.2 Enlarge the formula bar 00:00:00
3.3 Key Excel Functions: Sum, Sumif, Sumifs 00:00:00
3.4 Key Excel Functions: Count, Counta, Countif, Countifs 00:00:00
3.5 Key Excel Functions: Average & Averageif 00:00:00
3.6 Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, & 00:00:00
3.7 Working with text in Excel 00:00:00
3.8 Find the Highest and Lowest Values in a Range: Max & Min 00:00:00
3.9 = and + are interchangeable when you start typing a formula 00:00:00
3.10 Use Round in Your Financial Models 00:00:00
3.11 Excel’s Lookup Functions: Vlookup & Hlookup Made Easy 00:00:00
3.12 Index, Match, and Their Combination – The Perfect Substitute for Vlookup 00:00:00
3.13 Using Excel’s Iferror Function to Trap Spreadsheet Errors 00:00:00
3.14 A Useful Tool for Financial Analysis – The Rank Function 00:00:00
3.15 Create Flexible Financial Models with Choose 00:00:00
3.16 Goal Seek Will Help You Find the Result You Are Looking For 00:00:00
3.17 Perform Sensitivity Analysis with Excel’s Data Tables Functionality 00:00:00
Microsoft Excel - Practical Exercise "Build a P&L From Scratch"
4.1 Introduction to the Case Study 00:00:00
4.2 What You Will See Next 00:00:00
4.3 Understand Your Data Source Before You Start Working on It 00:00:00
4.4 Ordering the Source Worksheet 00:00:00
4.5 Create a Code: The Best Way to Organize Your Data and Work Efficiently with It 00:00:00
4.6 Learn How to Create a Database 00:00:00
4.7 Using Lookup Functions (Vlookup) to Fill the Database Sheet 00:00:00
4.8 Use Sumif to Complete the Database Sheet 00:00:00
4.9 Using Index & Match as a Substitute for Vlookup 00:00:00
4.10 The Mapping Exercise 00:00:00
4.11 Mapping the Rows in the Database Sheet 00:00:00
4.12 Building the Structure of the P&L Sheet 00:00:00
4.13 A Practical Example of Professional Formatting in Excel 00:00:00
4.14 Populate the P&L Sheet with Sumif 00:00:00
4.15 Learn How to Find Mistakes with Countif 00:00:00
4.16 Calculating Growth Rates in Excel 00:00:00
Microsoft Excel - Building Professional Charts in Excel
5.1 Introduction to Excel Charts 00:00:00
5.2 Beginner’s Guide to Inserting Charts in Excel 00:00:00
5.3 Modifying Excel Charts – The Easy Way 00:00:00
5.4 Making Your Excel Charts Sexier – Proven Tips 00:00:00
5.5 Creating a Bridge Chart in Excel 2016 – As Easy as It Gets 00:00:00
5.6 New Ways to Visualize Your Data – Treemap Charts 00:00:00
5.7 How to Represent Trends with Sparklines 00:00:00
5.8 Stacked Column Chart with a Secondary Axis 00:00:00
5.9 Doughnut Chart 00:00:00
5.10 Area Chart 00:00:00
5.11 Bridge Chart 00:00:00
Introduction to Pivot tables
6.1 Intro to Pivot tables 00:00:00
6.2 Editing a Pivot table 00:00:00
6.3 Formatting a Pivot table 00:00:00
6.4 Adjusting a Pivot table 00:00:00
6.5 GETPIVOTDATA 00:00:00
6.6 Slicers 00:00:00
A practical case study with Pivot Tables
7.1 Introduction to the case study 00:00:00
7.2 Working with an SAP data extraction 00:00:00
7.3 Preliminary mapping of the data extraction 00:00:00
7.4 Creating an output structure of the FMCG model 00:00:00
7.5 Improving the layout and appearance of the FMCG report 00:00:00
7.6 Inserting formulas and automating calculations 00:00:00
7.7 Creating a Master Pivot Table: The main data source for the FMCG report 00:00:00
7.8 GetPivotData is great! Extracting data from the Master Pivot Table 00:00:00
7.9 Combining Slicers and GetPivotData: The key to our success 00:00:00
7.10 Getting fancy with Excel slicers 00:00:00
7.11 This is how the report can be used in practice by high-level executives 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
0 STUDENTS ENROLLED
    Copyright @2019