Excel Mastery: From Beginner to Advanced with AI

Image

Powered by Froala Editor

Foundation Level

Day-1

  1. Introduction & Ribbon
  • Introduction
  • Grouping Sheet for same data entry
  • Data Moving
  • Data Entry
  • Minimize the Ribbon
  • Customize the Ribbon
  • Get Camera Tool in Excel
  1. Range:
  • Cell, Row, Column
  • Range Examples
  • Fill Series
  • All Cell Expanding at a time
  • Hide Row/Column
  • Unhide Row/Column
  • Custom Lists
  • Name Manager
  • Column width and row height
  • Insert Comments
  • Selective Clearing
  • Copy/Paste
  • Insert Row/Column
  1. Some Other Relevant Tools:
  • Freeze Panes
  • New Line in a Cell
  • Quick Access Toolbar
  • Merge Cell
  • Wrap Text
  • Text Alignment
  • Format Painter
  • Hide Gridlines
  1. Workbook & Worksheets:
  • View Multiple Workbooks
  • Linking Workbooks
  • Rename a Worksheet
  • Insert a Worksheet
  • Delete a Worksheet
  • Zoom
  • Split
  • Spelling
  • Autocorrect

Day-2

  1. Find & Select:
  • Find
  • Replace
  • Replace Partial Matches
  • Go To Special
  • Copy Visible Cells Only
  1. Paste Special:
  • Skip Blanks
  • Transpose
  • Add or Subtract
  • Percent %
  • Paste to .doc: Embed
  1. Round Functions:
  • Round
  • Round Up
  • Round Down
  • MRound
  • Even & Odd
  1. Printing & Page Setup:
  • Header & Footer
  • Page Number
  • Date & Time
  • Page Margins
  • Page Breaks
  • Printing Selected Rows
  • Print Area Adjustment
  • Center on Page
  • Keep the Headers at the Top while printing

Advance Level – 1

Day-3

  1. Format Cell:
  • Data Formatting
  • Numbers to Text
  • Leading Zeros
  • Add Text
  • Remove Unwanted Spaces (TRIM, CLEAN)
  1. Protect File:
  • Protecting Workbooks
  • Protecting Worksheets
  • Protecting Cells
  • Mark as Final
  1. Cell References:
  • Relative Reference
  • Mixed Reference
  • Absolute Reference
  • Hyperlink
  1. Restricted Data Entry:
  • Data Entry only when the Previous Cell is filled
  • Input Message
  • Error Alert
  • Prevent Duplicate Entries
  • Drop-Down List
  • Dependent Drop-Down List

Day-4

  1. Sort & Filter
  • One Column
  • Multi-level Sorting
  • Sort by Color
  • Filtering by Color
  • Number and Text Filters
  • Date Filters
  • Advanced Filter
  • Remove Duplicates
  • Subtotal
  1. Conditional Formatting:
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars
  • Color Scales
  • Icon Sets
  • Find Duplicates
  1. Tables:
  • About an Excel Table
  • Benefits of Excel Table
  • Preparing Data
  • Creating an Excel Table
  • Choosing Formatting Style
  • Sort & Filter Data
  • Show/Hide Total Row
  • Convert Table Back to a Range
  1. Date & Time:
  • Year, Month, Day
  • Date Function
  • Current Date & Time
  • Hour, Min, Sec
  • Time Function
  • DateDif
  • Weekdays
  • Last Day of the Month
  • Day of the Year

Day-5

  1. Count and Sum Functions:
  • Count
  • Countif
  • Countifs
  • Sum
  • Sumif
  • Sumifs
  • Count Blank
  1. Text Functions:
  • Join Strings
  • Partial Strings ( Left , Right , Mid )
  • Text to Columns
  • Lower/Upper Case
  • Combining & Extracting Text
  • Char Searching
  • Substring
  1. Lookup Functions:
  • VLookup
  • HLookup
  • Match
  • Index
  • Xlookup

Day-6

  1. Logical Functions:
  • IF Function
  • AND Function
  • OR Function
  1. Data Analysis:
  • Goal Seek/What if Analysis
  • Data Consolidate
  1. Mail Merge
  • Why Mail Merge
  • Mail Merge Process
  • Final Mail Merge
  1. Advance Plus -1 (ETC)
  • Max, Min & Maxa, Mina
  • Data Ranking with Rank
  • Automatic Update or Change SL No
  • Sequence Function
  • Sequence of Dates

Day-7

  1. Advance Plus -2 (Data Entry)
  • Name and Number Separation
  • Bar Code Maker
  • Convert Meter to Inch
  • Error Handling
  • Data Entry Form Making
  • Blank Cell Row Delete
  1. Data Analysis & Uses of AI (Chatgpt)
  • Data Analysis
  • Quick Statistics
  • Sales Forecasting
  • Excel Skills with ChatGPT

Advance Level – 2

Day-8

  1. PivotTables
  • Introducing PivotTables
  • Creating a PivotTable
  • Creating a Recommended PivotTable
  • Formatting data for use in a PivotTable
  • Connecting to an external data source
  • Managing subtotals and grand totals
  • Summarizing more than one data field
  • Changing the data field summary operation
  • Creating a calculated field / Using PivotTable data in a formula
  • Grouping PivotTable fields
  • Sorting and Filtering PivotTable Data
  • Consolidating data from multiple worksheet
  1. Slicer and Timeline
  • What are Slicers?
  • Slicer Features, Using Slicers, Formatting Slicers
  • Use Slicer from another Pivot Table
  • Disconnect or Delete a Slicer
  • Pivot Table Timeline, Customize a Timeline
  • Visualization using Slicer and Timeline

Day-9

  1. Excel Chart or Graphs
  • Create an Excel Chart, Excel Chart Elements
  • Ignoring error or blank cells in chart
  • Plotting secondary axis in chart
  • To switch row/column data in chart
  • Modifying and Customizing Charts
  1. Playing With Macros
  • What is Macro?
  • Trust Centre and Macros
  • Setting up Excel to Allow Macros
  • Excel Macro Security Setting
  • Trace Developer Tab
  • Macro Recording
  • Use Relative Reference Option

Day-10

  1. Power Query
  • Text Functions in Power Query
  • Date Functions in Power Query
  • Number Functions in Power Query
  • Column from Examples
  • Conditional Column
  • Miscellaneous Topics in Power BI
  • M Language in Power Query
  • Web Scraping using Power Query.
  1. Power Pivot
  • Power Pivot
  • Data modeling concept



Powered by Froala Editor

Image

Md. Aksadur Rahman

Course rating

5.00 average based on 1 rating

Star

90%

Star

80%

Star

65%

Star

60%

Reviews

  • Image

    Anna Dew

    Cover all my needs

    The course identify things we want to change and then figure out the things that need to be done to create the desired outcome. The course helped me in clearly define problems and generate a wider variety of quality solutions. Support more structures analysis of options.

Related Courses

Image
2000.000

Excel Mastery: From Beginner to Advanced with AI
  • Total Hours: 15
  • Total Session: 10