
Learn the Excel overview: understand the ribbon, tabs, groups, and commands, and how workbooks contain multiple worksheets of cells arranged in rows and columns.
Discover how to build Excel formulas with the equal sign and use addition, subtraction, multiplication, and division, including the plus operator and sum function, to calculate totals from cell references.
Master undo and redo in Excel using the quick access toolbar or Ctrl/Cmd+Z and Ctrl/Cmd+Y to revert actions, recover deleted data, revert formatting, or reverse sorting and filtering.
Learn to change font name in Excel for numbers and text using the ribbon or right-click, with examples like Arial Black and Times New Roman.
Apply font size and font attributes in Excel by using the font size menu or typing custom sizes, and practice bold, italic, underline, and strikethrough with keyboard shortcuts.
Master the format painter to quickly copy cell formatting across single or multiple cells, from the clipboard group in Excel, saving time and ensuring consistent colors and fonts.
Learn how to format grids in Excel, remove gridlines for readability, and apply font and fill colors to data for clearer worksheets.
Master the sumif function in Excel to sum values that meet a single criterion using range, criteria, and an optional sum_range, with practical salary examples.
Learn how the average function in Excel computes the arithmetic mean by summing a range and dividing by observations, ignoring text, with practical examples like salary and age.
Master the countif function in Excel to count cells meeting a criterion, such as salaries above 40,000 or ages 30 and below, and compare with the count function.
Hello All,
I will use my 8+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023
At completion of this course you will very familiar with most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will make you advance in excel:
Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
Create dynamic report with Excel PivotTables
Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks by mastering the power of Macros and VBA
So, what are you waiting for, enroll now and take the next step in mastering Microsoft Excel.
I wish you all to success in your life whatever you learn.